Jump to content
Changes to the Jaspersoft community edition download ×

using multiple result set

2004 IR Help

Recommended Posts

By: JAmol - jamol

using multiple result set

2005-11-01 22:16

hello ,

We are creating reports with jasper APIs .

We are able to do this with single ResultSet using some useful function like

>> compileReport(jdesign);

>> fillReport(jasperReport, map, new JRResultSetDataSource(rs1)).


Now the requirement is that ,

we are getting multiple ResultSet , each of same

structure using --> Statement.getMoreResults().


Something like each result set is dealing with a customer and its many details .

Previously we were grouping on customer .

now for reason we are thinking of single rs for a customer's detail.


Is is possible in jasper ??

if it is how can we do that ??




Link to comment
Share on other sites

  • 1 year later...
  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

I created a Jasper Report extensions for retrieving all information sets of a multi-result set stored procedure, cache the result and make it possible to retrieve any result set by index. The solution is as is, unsupported with no liability for whatever outcome of using it, but it might serve as a starting point for someone. The jar contains source as well as class files.


The solution, including source packaged into the jar, is now available from the link


Post edited by: torost, at: 2007/09/07 15:45

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...