on 09-12-2014 9:19 PM
Hi,
I have installed SAP Crystal Report Viewer 2008, when tries to open output file that has RPT extension, getting error message "this report contains invalid Crystal Reports formulas that cannot be compile".
It seems it requires some DLL files that we already have but we dont know where to place it on SAP Crystal Report Viewer program files folder.
Please help me in resolving this error.
Thank you in advance.
Regards,
Manish Gupta
Hi Manish
Please disregard DJ's posts...
UFLs are supported by all versions of CR and CR viewers.
The error may be caused by a number of variables
Data inconsistency
Missing custom UFLs
Incorrect formula
and more.
I do find your statement:
It seems it requires some DLL files
interesting and wonder if you can tell us why you think this is the case.
Also, do you know if the report is using any custom ufl?
And, you do not mention if the viewer is installed on a computer that has the CR designer installed or not. If not, instal the viewer on a computer that has the CR designer. Can you run the report in the viewer on that computer?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ludek,
we were getting same error with Crystal report Editor 2008, the reason is missing custom DLLs in crystal report program files. Then we placed all the files to C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86, and it worked.
Now because we cannot installed editor on end user machine, so we installed
SAP Crystal report viewer 2008 for Windows from below link:
http://scn.sap.com/docs/DOC-29774, and we did not find similar folder structure as editor on viewer program files, that why we are strugulling where to place those custom DLLs to make crystal report viewer work same as editor.
hope i explained all your questions and the issue I am facing.
thanks.
Manish Gupta
Manish,
If the report contains formulae that reference UFLs then it will Not work in the CR Viewer.
Following are the kind of reports that don't work with the free (standalone) CR Viewer per this SAP Note:
1. Reports that have no saved data, unless they are being accessed online from BusinessObjects Enterprise and you have the appropriate rights.
2. Reports that use Business Views as a data source.
3. Reports that use universes as a data source. (Static instances of reports that use universes will open if these reports are downloaded from BusinessObjects Enterprise.)
4. Reports that use Crystal Dictionaries as a data source.
5. Reports that use Crystal Queries as a data source.
6. Reports that depend on UFLs
7. Reports that are successfully using "Perform Grouping on Server". (That is, the generated report SQL contains a "group by" clause.)
If you want UFLs to work with the Viewer, please have a look at the 3rd-party Crystal report viewers listed at: http://www.kenhamady.com/bookmarks.html
-Abhilash
Hi Manish,
UFL's are not supported in Crystal Reports Viewer 2008 yet.
usually C:\WINDOWS\assembly..
--DJ
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Manish,
The Crystal Reports Formula Editor can access User
-Defined Functions through a User Function Library (UFL). A User Function Library is a specially designed Dynamic Link Library that exposes one or more functions that you create. UFLs can be designed and programmed in any language that supports the development of Windows DLLs.
The 32-bit version of Crystal Reports Professional Edition includes the User Function Library U2LCOM.DLL. This UFL is installed in your \Program Files\Common Files\business objects\3.5\bin
directory when you install Crystal Reports and provides an interface through which you can expose User-Defined Functions in Automation Servers.
Place it here: C:\Program Files\SAP BusinessObjects\Crystal Reports 2011\Crystal Report Viewer
Regards,
DJ
hi,
i downloaded SAP Crystal report viewer 2008 for Windows for below link:
http://scn.sap.com/docs/DOC-29774
and that has got below folder structure:
C:\Program Files (x86)\Business Objects\Crystal Reports Viewer 2008
I tried to place those dlls in all folder but no luck
Please help me...
Hi Manish,
Crosstabs with calculated members or conditional formulae could cause issues like these.
Try commenting one formula at-a-time to zero-in on a formula that might be the potential cause of the report not working from the Viewer.
P.S: Since you're using the CR Viewer 2008, I hope the report is developed in CR 2008 too.
-Abhilash
hi Abhilash,
I know those are formulas thats requires DLL that i mentioned...but the issue is that where to please those dll so that crystal viewer can compile and execute those functions.
additionally, the rpt file is out put file generated by crystal editor 2008 source code only...we are trying to open the output file to see the output/result.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.