cancel
Showing results for 
Search instead for 
Did you mean: 

CR10 - Export to CSV using latest JRC

Former Member
0 Kudos

Post Author: tle

CA Forum: JAVA

Hi , I have a web app in weblogic 8.1 that calls the crviewer to display reports created using CR10 designer from developer edition.

The JRC that comes with it does not export to csv. I read in some postings that the latest JRC bundled in Crystal Reports for Eclipse supports export to csv and the jrc libs can be used for app developed in other IDEs. But the sample codes in the Crystal Reports for Eclipse bundle contains references to "clientDoc" which is a component of RAS, if I'm not wrong. I would like to find out :

1) if I can just replace the jrc lib in weblogic workshop with the new jrc lib and do a csv export without a RAS?

2) Or had anyone successfully did an export to csv with a setup similar to mine using any other method?

Any advice is greatly appreciated. Thanks in advance.

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Post Author: Ted Ueda

CA Forum: JAVA

Hello tle,Currently, the only way to get CR4E JRC patches is via the Eclipse software upgrade manager - so it requires installing Eclipse. Once you've installed Eclipse and CR4E, you'd start Eclipse, go to Help -> Software Updates -> Find and Install... then let Eclipse connect and find the newest versions. It won't delete old versions - it'll install the newest jars in <eclipse install>/plugins/com.buxinessobjects.sdks.jrc.11.8.0_<build number>You'd copy the jar files and the viewer folder from there to your application. Sincerely,Ted Ueda

Former Member
0 Kudos

Post Author: tle

CA Forum: JAVA

Hi Ted,

Nice to hear from you again.

I was using ReportExportControl. Then I switch to ReportClientDocument controller and it seems to work for the report I'm trying out on. I just replace the portion of the codes done with ReportExportControl with found this piece of code I found somewhere on the net:

ReportClientDocument rpt = new ReportClientDocument(); rpt.open(report, 0);ParameterFieldController paraController = rpt.getDataDefController().getParameterFieldController();paraController.setCurrentValue("", field1,val1);parController.setCurrentValue("", field2, val2);

I managed to do a csv export but the data is not usable. It seems that group header lines are printed instead of the detail line records for reports with group headings...

I guess that's where the CR4E update you mentioned comes in. But I'm not sure how to get it, it seems that Eclipse is required to get the patch. I can't find a place to download it like the other hot fixes. Any pointers?

Also, it only mentions resolution of a fix for repeated Page Header lines, so I'm not sure if the update will help what i'm facing, but I'll still give it a try.

Also, it seems that crosstab reports does not export to csv.

Any pointers on getting the CR4E update will be greatly appreciated. Thanks in advance!

Regards,tle

Former Member
0 Kudos

Post Author: Ted Ueda

CA Forum: JAVA

Are you setting the parameter field values in code? If so, are you setting them via the ReportExportControl or via ReportClientDocument controller?

I've seen issues where the JRC complains about missing parameter field values when (1) correct values are not being set, or (2) corrupt rpt file.

For (1), typically passing the report source to the viewer should identify the parameter that's not being set, since the DHTML viewer will query the user for them. This may not be your issue, since I'm assuming the viewer doesn't show the parameter prompt page.

For (2), typically some corruption has caused parameters to be duplicated within the report, and they refresh fine in the Crystal Report Designer but not in the JRC. Since the JRC uses a different and newer report engine from the CR Designer, I find it less robust to such reports. What happens if you re-create a report with parameters from scratch? Do you still get the same error?

Sincerely,

Ted Ueda

Former Member
0 Kudos

Post Author: tle

CA Forum: JAVA

Thanks Ted for your previous speedy reponse and explanation.

I finally managed to get the new jrc(that comes with the eclipse bundle) to work with the current web app on weblogic.

In case it is helpful to anyone, what I did was:

1) download the bundle2) Copy the lib and crystalviewer directory under plugins\com.business.objects.sdks.jrc.11.8.0_11.8.4v1094 into weblogic.3) READ THE RELEASE NOTES - very important as it contains information, known bugs and their workarounds etc, for the various IDE, platforms etc. 4) Change the export and viewer-invoking part of the codes using the sample codes found at http://devlibrary.businessobjects.com/BusinessObjectsXIR2SP2/en/devsuite.htm

But I hit the error "missingparametervalues" when I try to export from a parameterised report. The report in question works fine when viewed in a DHTML viewer, so it's not an error from the report itself. I also managed to export a report with no parameters using the same export codes. So the error seems to only occurs with the parameterised reports.

I have not managed to find a solution to this anywhere(within my knowledge). If there is anyone who had managed to resolve this, I would really appreciate the help!

Thanks in advance!

Former Member
0 Kudos

Post Author: Ted Ueda

CA Forum: JAVA

The JRC starting with XI including CR4E consists of:1. The Java Report Engine - the 100% pure Java implementation of the Crystal Reports Print Engine.2. The RAS SDK - the API used to interact with the Java Report Engine (this is a modified version of the RAS SDK that comes with the RAS server solution).3. A ReportClientDocument wrapper class for the RAS ReportClientDocument wrapper.You'd not interact directly with the RAS clientDoc, but with the JRC version of the ReportClientDocument.Your current JRC 10 code (that won't be using the ReportClientDocument) should still work with XI and CR4E.I'd recommend the latest patches for CR4E, that has fixes for CSV exports. Sincerely,Ted Ueda