cancel
Showing results for 
Search instead for 
Did you mean: 

Failure of WhilePrintingRecords formula in JRC

Former Member
0 Kudos
51

Hi,

I have a report which shows total number of records in its group header for its below group! It uses formula for total:

WhilePrintingRecords;

numberVar x

This report works fine when I set its datasource through XML in report designer CRXI Release 2. But when I run it through Java Reporting Component then its total field shows as zero. So is there any problem with jars used in java environment which fails the formula when run through my application?

Thanks,

Ameya

Accepted Solutions (1)

Accepted Solutions (1)

former_member217070
Active Participant
0 Kudos

Hi, Ameya,

The first thing to do is to make sure you're using the latest JRC jars. The most recent are the CR for Eclipse jars, Patch 5, that came out in March. You can get them from here:

https://boc.sdn.sap.com/node/19020

Regards,

Bryan

Former Member
0 Kudos

Hey Bryan,

Thanks for the reply, I have downloaded latest jars but that still doesn't work for the formula. Is there anything that I am missing? or there is problem with Formula jar.

Regards,

Ameya

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi ted,

I ran the report through my application and exported it as rpt file that is with data. I have Crystal Report XI in which i opened it and its running fine in it! So that makes sure that there is problem with JRC. Thanks for the suggestion to cross check the problem. Hoping for a fix soon!

Regards,

Ameya

ted_ueda
Employee
Employee
0 Kudos

Hello Ameya,

The next version of the JRC - Crystal Reports for Eclipse version 2.0 - is currently in public alpha:

[http://beta.businessobjects.com/CR4EPreview|http://beta.businessobjects.com/CR4EPreview]

Developers of JRC are actively seeking comments especially about any runtime discrepancies between the Java Engine and the Crystal Engine.

The best way to ensure your issue is heard - if you have the opportunity - would be to participate in the alpha.

Sincerely,

Ted Ueda

Former Member
0 Kudos

Hey,

Yes I have run the report through designer by setting it to XML data source, and the formula works fine over their.

For better understanding of the problem; I will describe in brief about report: Their is a Cross tab which gets the count of data under its Group Header. Then on the basis of number of iterations within that group its total iterations is calculated to show the value at the end and there is a reset formula on start of each group.

Hope this might help figure out if there is something else failing to work in java environment!

Thanks,

Ameya

ted_ueda
Employee
Employee
0 Kudos

There may be differences between the Crystal Report Designer and the JRC in handling of the whileprintingrecords formula option.

To see if this is the case, would you be able to save the report with data, then try viewing it in the [Crystal Report Viewer XI|http://www.businessobjects.com/product/catalog/crystalreports_viewer/]? This viewer uses a slightly newer version of the Java Crystal Report engine than the current JRC.

If you see the same behavior with the viewer, this will isolate the issue specific to the handling of the whileprintingrecords in formulas in the Java CR engine.

Sincerely,

Ted Ueda

former_member203619
Contributor
0 Kudos

I don't believe that the issue here is with the formula - but rather that the data isn't getting passed into the report. If you drag one of the fields from the XML datasource into the details section of your report - does any data show up on the report?

Shawn