Why are my Subreport and Main Reports returning different data?

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.

zoombaba's picture
Joined: Sep 11 2013 - 8:56am
Last seen: 5 years 2 weeks ago

1 Answer:

0

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
976
Joined: Aug 29 2012 - 6:13am
Last seen: 2 years 5 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 - 5 years 11 months ago
Feedback