Using One Datasource for Multiple Sub-reports

[dan_thorman]

I have one main report with 2 subreports. The 2 subreports are in the details section of the main report. I want to pass to each the same parameter, and for each to evaluate for the same parameter, so that i get a table that looks something like this:

 

 

brand name 1: condition1count condition1sum condition2count condition2sum

brand name 2: condition1count condition1sum condition2count condition2sum

brand name 3: condition1count condition1sum condition2count condition2sum

 

etc. where condition1count and condition1sum are the results of 1 of the sub-reports and condition2count and condition2sum are the results of the other sub-report.

 

in the main report, i am using a jdbc connection to an oracle database to pull distinct brand names and their unique id's, and i want to pass the unique id to the sub-queries as it is a condition in the query they run.

 

The problem i have is that sub-report 1 is evaluating correctly, but sub-report 2 is returning all null data.

 

What did i do wrong?

[jmurray]

This is a duplicate post. Please use this post

 

 

http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=215&func=view&id=19909&catid=9

 

 

when posting replies.

 

 

 

.

Post edited by: jmurray, at: 2007/01/09 22:55