How many subreports is too many?

[pradeep79]

Hi,

I have to create a report for which I need to use about 15 different queries. Because a report can only have one dataset, I assume I will need 14 subreports to acheive this. I have tried the subreports with only 2 child reports, but I'm wondering the impact of a very big report definition.

Is it usual to have so many sub reports embedded in a report? What performance issues I may face if I go ahead with it?

[Taqua]

There is no hard limit. OK, Subreports fork a complete report process so they are more heavyweight than a single band, but still, the penalty should be barely noticeable. From a memory perspective, you dont pay anything, and from a execution time, it should be very low, as the empty sections are processed lightning fast.

In case you have to print just a single value with the subreport, then you can try our newest addition, the "SingleValueQueryFunction". This function fires a parametrized query using the same datasources as the subreports use and return a single value, which then can be used like any other computed function result. The "SingleValueQueryFunction" has the advantage, that you can combine several datasources in one band (as for 0.8.9, the subreports are always banded below the master's root-level band that defined them).

[pradeep79]

In case you have to print just a single value with the subreport, then you can try our newest addition, the "SingleValueQueryFunction". This function fires a parametrized query using the same datasources as the subreports use and return a single value, which then can be used like any other computed function result. The "SingleValueQueryFunction" has the advantage, that you can combine several datasources in one band (as for 0.8.9, the subreports are always banded below the master's root-level band that defined them).

I will definitely check that, that sounds like something I might need soon. Do you mean that I can have several datasets with several queries, then use one SingleValueQueryFunction for each of those datasets? Sounds really interesting..

[pradeep79]

Hi Thomas,

Just checked my report designer, I can't see the SingleValueQueryFunction in it. I assume this is because it uses classic engine 0.8.9-rc6.

Can I update these jar files with the latest ones? will the functions show up if I do it? Is there any other dependencies I need to change??