creating a new subreport for the first time

[law]

Hi all, I'm attempting to create a subreport, just as a test to see how it works. Here is what I have:

In my main report the sql is:

SELECT distinct name FROM account order by name.

Then I add the "subreport" icon into the main report.

My subreport sql is:

SELECT id, division FROM account where name = $P{name}

I build both reports and run the main one. For some reason I only see main report data, nothing from sub report. Am'I missing something trivial here?

 

 Found it - had to edit Connection Expression

 

 

Post Edited by liw at 08/01/2012 23:01

Post Edited by liw at 08/01/2012 23:02

Post Edited by liw at 08/01/2012 23:47

[law]

 

 

Post Edited by liw at 08/01/2012 22:58