Why are my Subreport and Main Reports returning different data?

Posted on September 11, 2013 at 9:06am
0

I’ve used a crosstab in the Summary band of my Subreport to create a dynamic column/pivot table. When I run this independently its working fine and is returning the data correctly, as expected.

Then when I reference it in another report as a Subreport within the Detail Band, it runs okay with no errors, but with some of the data is missing.

I’ve used the following:

Subreport data expression is      $P{SUBREPORT_DIR} + "mySubreportFile.jasper"

Connection type                              Use a datasource expression

Datasource expression                  $P{REPORT_DATA_SOURCE}

Can anyone advise please? Unfortunately for security reasons, I cannot provide any files to look at.

iReport Designer
zoombaba's picture
zoombaba
4
Joined: Sep 11 2013 - 8:56am
Last seen: 5 years 11 months ago

1 Answer:

0
Posted on September 13, 2013 at 3:13am

Hi,

Try this

Add report as a resource into main report.

And use :repo.resource_name in subreport expression.

This may solve your problem. Let me know.

Thanks

Ajinkya

ajinkya_c's picture
ajinkya_c
945
Joined: Aug 29 2012 - 6:13am
Last seen: 3 years 3 months ago

Hi Ajinkya

Thanks for replying to my question. Due to time constraints I had to find a way to do my report without needing to use a subreport, so in the end I didn't use a subreport at all. But when I need to do another report using a subreport, I will try your suggestion. Thanks again for your help.

Lynsey

zoombaba - 6 years 10 months ago
add comment
Feedback
randomness