Mapping result set to rewindable datasource

0

Hi .. I have a very complex (expensive) query that needs to get passed to 4 sub-reports. Since a JDBC results set is not rewindable, I'm looking for a way that I can map the JDBC result set once into a rewindable data source and then pass that to the subreports.

This sounds like something that someone else must have tried to solve before, so does anyone have a solution that can share?

dgrigglestone's picture
Joined: Feb 3 2014 - 9:06am
Last seen: 1 year 7 months ago

1 Answer:

0

Yes, it does look like someone has done before.

Take a look at the following page under "rewindable data source"

http://jasperreports.sourceforge.net/sample.reference/datasource/

hozawa's picture
59069
Joined: Apr 24 2010 - 4:31pm
Last seen: 9 months 3 weeks ago

What was the explicit example you are referring to. I was aware of the section you pointed me to, but alas I do not find any rewindable datasource that can take a JDBC datasource (http://jasperreports.sourceforge.net/api/net/sf/jasperreports/engine/JRR...) and map it to a rewindable datasource .. nor can I find any pointer to logic that will do so. I am looking for an explicit example. If I end up writing myself, I'll try to post back here .. but hopefully someone has real code I can reuse.

dgrigglestone - 6 years 6 days ago
Feedback