Internet Explorer Script Error

[Former Member]

I seem to get a weird IE Script error for any report I try to run on Crystal Developer XI. This is only specific to a Date/Time parameter. When I click the calendar button to select a date, it gives me the following IE Error:

An error has occurred in the script on this page.

Line: 159

Char: 1

Error: Object expected

Code: 0

URL: file:///C:\an html file somewhere in my Documents and Settings directory.

I am then prompted if I want to continue running scripts on this page. If I click Yes, it will not do anything. Same result if I click No.

This is happening to all my reports that have a Date/Time parameter.

Any ideas?

[former_member260594]

Hello Eric,

The prompting files either did not install correctly or became corrupt. If you have a system (CR or Enterprise ) that is working we can copy the files from that system to the one it is not working on.

If you are using CR XI R2 copy the C:\Program files\Business Objects\Common\3.5\crystalreportsviewers115\prompting folder from the working machine.

[Former Member]

Hi Graham.

I copied the folder you mentioned from a working machine with the same service pack (SP4).

Made sure to copy over and replace the old folder while CRXI was closed.

Unfortunately, that did not fix the problem. What else can I try?

[Former Member]

It may be a problem with the parmeters themselves, the regional settings on the browser/operating system or (very unlikely) in the database

What is the browser software and its version?

How are the parameters passed to CR?

What regional settings are set for the OS and the browser?

This should identify where the error is....

[former_member260594]

Sorry, I was having difficulty finding the old knowledge base article that detailed the solution to this. Try the following as well;

Rename "C:\Program Files\Business Objects\common\3.5\bin\prompt.dll" to "prompt.old"

Replace the prompt.dll with one from the working machine.

Now if this still doesn"t work ensure that there are no other copies of "promptengine_calendar.js" anywhere on the system, if there is rename and replace it also

[Former Member]

Well the funny thing is, the parameters were working fine while I was developing reports yesterday.

I came in today to test some stuff and I noticed this started happening for ALL reports that have a date/time prompt.

To answer your question, browser CR is using is IE7.

The date/time parameter is created in CR as a normal DateTime static parameter value with range.

Regional settings on both items are US.

[Former Member]

No progress on that either Graham.

Replaced prompt.dll as well as the JS file. Still getting the same error.

[Former Member]

What was the resolution to this issue?? I'm having the same problem... running CR XI R2.

Thanks!

Suzanne

[Former Member]

I too am experiencing this same issue. I have discovered that if IE is open the problem doesn't occur, but when it is closed the problem returns. I reinstalled IE7 to see if that would help but no joy.

[Former Member]

Have you found a solution to this error yet?

I am having the same error, it doesn't happen on the development machine, only on the user machine.

Both machines are running IE7 with the same regional settings.

The viewer is a winform viewer but the error is the same, it only happens if the date parameter is DYNAMIC and being loaded from the database. If I change it to a static parameter that you have to type in or select from a dropdown calendar, it works ok.

This might be an IE7 javascript security issue...

the client machines have the automatically downloaded Crystal Reports 2008 redistributable package that you can include from within Visual Studio 2008 if you have CR2008 and are using ClickOnce deployment.

Maybe this error would go away if you package your own CR redist. but I haven't tried that yet.

I will post here once I find a solution!

Edited by: Talal Nehme on Nov 19, 2008 4:59 PM

[Former Member]

Hi,

Try this..

Goto Internet options > Select programs tab > and click on the button reset web settings.

Goto Advanced Tab> Click on the button restore defaults.

Regards,

Vinay

[Former Member]

That corrected the issue. Thank you so much!