Error in formula running report on a Windows 7 workstation - Crystal X

[meagain]

Hi,

I have a report which runs fine on a Windows XP workstation, but errors out on a Windows 7 workstation. We're using Crystal X, and the error message is:

Report Engine Error 000000515 - Blah blah blah

Error in formula <ProdCodeNDesc>.
'stringvar array x := split({PRODUCT_CODE.PRD_DESC},")");
'
The ) is missing.
Details: errorKind

The ) is there, and if I put another one in, then I get an error on saving the formula. As mentioned, it works fine on an XP, and we'd like to resolve the issue, so the Windows 7 users can run it without error.

The full formula is here if you need to see it:

stringvar array x := split({PRODUCT_CODE.PRD_DESC},")");
numbervar i;
numbervar j := ubound(x);
stringvar y := "";
for i := 1 to j-1 do(
y := y + trim(extractstring(x,"","("))+"; "
);
if len > 2 then
left(y, len-2) else {PRODUCT_CODE.PRD_DESC}

Thanks so much for your assistance in resolving this issue.

Best,
Lori

 

[PeterDimitrov]

Are you using UFL ? If yes, is it registered on the Windows 7 machine ?
I have seen also similar errors when the report connection is not set correctly. Are you using 3rd party software to run the report or do you have a local database ( excel, access etc) ?

http://www.R-Tag.com

Viewer and Scheduler for Crystal reports, SSRS and Dynamic Dashboards.

 

[meagain]

Hi Peter,

Thanks for responding.

I'm not sure on the UFL. How would I know?

Yes, to 3rd party software.

Thanks,
Lori

 

[PeterDimitrov]

Lori, in order to check if an UFL is used open any formula and check the tree Functions\Aditional Functions - it will show you the list of formulas available in UFL dlls and the dll name. First check this on a machine where the report is working and then check the list on a machine where it is not working and find what is missing.

If you are using 3rd party software , it is very likely that this has nothing to do with UFL , but the database connection is not set correctly. Do you have crystal installed on the same machine ? If you do and you can run the report with Crystal , but you cannot run it with the viewer the problem is how the viewer is setting the connection. If you are using ODBC connection, you can check also if the ODBC DSN is set correctly on the computer where the error is happening. If it is OK, contact your vendor. They should be able to resolve this.

http://www.R-Tag.com

Viewer and Scheduler for Crystal reports, SSRS and Dynamic Dashboards.