Using fields from main query in subquery

0
I was read a lot suggestions from google, but for iReport 5.1.0 it's doesn't work.
 
I want use fields from main reports dataset in sub-query dataset for filtering. For example, I want to insert repeating table into detail section for each row from main dataset.
 
The main query: select field1, field2 from table group by field1, field2
 
The sub-query: select * from table where field1 = $P{field1_from_main_qury} and field2 = $P{field1_from_main_qury}
 
So, how I can do that?
 
Would be great step-by-step instruction for 5.1.0 version.
 
Thanks in advance.
yuriy.bolgov's picture
Joined: Oct 24 2013 - 9:13am
Last seen: 2 months 3 weeks ago

1 Answer:

0

Hi,

Are you mapped parameter in subreport parameter map in subreport properties?

Thanks

Ajinkya

 

ajinkya_c's picture
945
Joined: Aug 29 2012 - 6:13am
Last seen: 2 years 11 months ago
Feedback
randomness