Numbertodate with CR XI

[JCGSTL]

I've just upgraded to CR XI from 8 and one of my formulae has stopped working. I was using the following to convert a number to a date (after running ufltdate.exe and then copying two dlls to the \WINDOWS\CRYSTAL and \WINDOWS\SYSTEM directories):

Numbertodate(ToNumber ({Itinery_Date}))

This converts, for example, 20070719 to 19th July 2007.

How can I do this with CRXI?

 

[dgillz]

I use this function every day with crystal XI. I do not know anything about the .exe you are using however. What error message are you getting?

Try to manually register u2ltdate.dll. This is located in my c:\windows\crystal directory.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[JCGSTL]

Many thanks for replying ... and many apologies, I've just realised that didn't explain my problem properly.

The numbertodate function works perfectly in CR XI, but when I try to run a report containing the function via the web using Crystal Report Viewer I get the error message:

Error in File Duty Office Report2: Error in formula . 'Numbertodate(ToNumber ({ItineryV4.IT_Date})) ' UFL 'u2ltdate.dll' that implements this function is missing.

Unable to retrieve Object.
Error in File Duty Office Report2: Error in formula . 'Numbertodate(ToNumber ({ItineryV4.IT_Date})) ' UFL 'u2ltdate.dll' that implements this function is missing.

Obviously u2ltdate.dll IS registered in C:\Windows\Crystal or the function wouldn't work in CRXI.

(BTW, the ufltdate.exe program merely contains the two dlls and instructions on how and where to install them.)

Best regards

 

[dgillz]

So it runs fine in CR itself, but not on the web?

What program are you using to run reports on the web? Whose crystal reports viewer? On all workstations or only on some of them?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[JCGSTL]

Yes, it works perfectly when running the program, but not via the viewer.

I've just upgraded to CRXI (locally) and CR Server (on an SBS 2003 server) and am trying to set the system up. At the moment I am the only user, and am trying to view the reports on my PC via:
//(myserver)/businessobjects/enterprise115/InfoView/main.aspx

 

[dgillz]

Crystal reports server needs to recognize the .dll in that case, not CR itself. You should probably post this question in the crystal enterprise forum (CR server and crystal enterprise are basically the same product).

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[JCGSTL]

I'll do that. Many thanks for your help.