Using UFL on Crystal Enterprise Server 1

[crystalvictim]

We have created a UFL in vb following the steps described in the kb-document named scr_user_defined_functions.pdf and it works fine locally (i.e. we're able to use it within the crystal reports designer).

Now my question is, how to use this ufl on our enterprise server, so that we'll be able to publish reports using the ufl-functions on the server and schedule these reports as usual.

Does mere copying the dll onto the server and registering it via regsvr32 do the trick or is there something more to configure ?

as always - any help's appreciated

cheers.

 

[crystalvictim]

Okay, in the meantime we found out that just copying and registering is definitly NOT everything that is required.

the report can be run on the server and is getting the status 'success' but when trying to view this instance, an error occurs:

Fehler in Formel . '//global stringvar array felder; ' The remaining text does not appear to be part of the formula.. Datei ~ce5c430c08fe83416.rpt. [Auf Cache/Page Server: BRUDEREP1.pageserver]

There are some kb-articles concerning this message, but as far as I understand the situation described is not exactly the same, so before messing around with our registry we'd like to hear your statments on this issue.

 

[crystalvictim]

By the way (I forgot it again :-( ), we're using CR8.5/CE8.5

 

[Nuffsaid]

Hi

We simply copied the dll to the C:\winnt\crystal folder on the Enterprise 8.5 box and it worked. One thing I might mention is that we also have installed CR 8.5 on the same box. We did this back in the CE 8.0 days to resolve some issues then, and we just kept on with the practice.

Do you have CR installed on the CE box? If not, probably worth a shot.

Nuffsaid.

 

[crystalvictim]

nuffsaid,
we have CE and CR installed on the CE-Server. Within the CR on the server, we can use the UFL without problems.
But I have to say that the file is probably not located in 'winnt\crystal' but resides at another location. Perhaps this only matters for CE and not CR and therefore causes the problem. I'll have a talk about this with our administrator tomorrow and keep you informed, after we've checked this out and tested again.

thanks for your advice!

 

[crystalvictim]

nuffsaid,

SUCCCESS
We copied the file to winnt\crystal AND registered it via regsvr32.exe.

Now it seems to work.

Thanks again for your help!

 

[crystalvictim]

Hm..... simple functions definitely do work (e.g. the LCaseConversion example function).
Now we have created a function (that works fine with CR) that basically converts certain report information into csv and saves it to a file on a server.
the account that runs the ce-processes (e.g. page server etc.) has the required permissions to access this path and create a file.
Nevertheless the report produces and error saying that there is not enough memory available.
Running the report locally - with the same path - works.

Has anybody experience with running such more complex functions/UFLs on an enterprise server and can tell me, if there are any more requirements or if it is simply not possible to create/write to files from a UFL. (I can't believe that it's impossible as I remember having heard about something like a csv-ufl).

cheers,
Frank