manshack_one Posted April 26, 2011 Share Posted April 26, 2011 We've got some fairly complicated Brio reports that were written in SQR. A large majority of these require up to 15 different queries with one query feeding another one to finally get the result they are looking for. With jasper I know we have subreports and I know you can add multiple datasets. However, can one dataset feed another one through parameters? If I remember right the only parameters I've seen being passed were from report to subreport. I don't think I've seen a dataset to dataset transaction as of yet. I suppose another option would be to convert the logic in the SQR's to java code and put that into a scriptlet and just use a report to format the output. Suggestions? Link to comment Share on other sites More sharing options...
manshack_one Posted April 27, 2011 Author Share Posted April 27, 2011 Don't let the Brio stuff worry you so much.How about just the ability to have one dataset be the input for another dataset? Link to comment Share on other sites More sharing options...
manshack_one Posted August 24, 2011 Author Share Posted August 24, 2011 bump is there a way to run the main query, then have another dataset run a query against those results? Link to comment Share on other sites More sharing options...
Giulio Toffoli Posted August 25, 2011 Share Posted August 25, 2011 yes, you can use subreports, list or tables to print data coming from a sub-dataset which can be filled with a query parametrized on the current fields, parameters or variables. Giulio Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now