How to use a Dataset or Report's query twice for a chart and a table - second is always empty

[kcd]

I'm trying to work out how best to do reports with a chart then a table representing the same dataset. I need to overcome the positioning of the summary is at the bottom, so intend to use subreports and table-subreports. I am experimenting with two tables and a chart in one detail band.

 

If I set the datasourceexpression for to $P{REPORT_DATA_SOURCE} only the chart displays data (presumably the first subreport type item) and the tables are empty. Seems the data can be consumed only once? Can I reset the increment?

 

If I use a Dataset to query the database it works however it executes the Query three times, once for each table/chart. That will be a massive overhead.

 

Obviously I am not doing this right but I cannot find any examples of using the same dataset more than once.

 

XML code snippets from iReport below. I tried to trim out the irrelevant parts.

Code:

Post Edited by kcd at 09/29/2011 02:48

[darth_fader]

Think there's a trick where the summary band can be displayed at the top of the page. Know I've seen if before, but haven't used it. I'll try to dig it up.

[kcd]

There is the dummy group header with the chart set to evaluate Report instead of Now. I use that and but it seems to flag the rows as used so they no longer display in the table.

[szaharia]

Hi,

Please log this RFE on our tracker list.

For the moment the workaround is to implement a custom query executer to retrieve data from a cached datasource or to generate a rewindable datasource based on the retrieved result set.

Thank you,

sanda

 

[kcd]

Ah so I'm not crazy and it isn't an obvious answer! Thanks for your reply

[kcd]

See http://jasperforge.org/projects/jasperreports/tracker/view.php?id=5487

[madhukiran]

Hi .. this link seems to be invalid.. is there a new link for this?

[elp0mme]

https://community.jaspersoft.com/jasperreports-library/issues/5487