Problem with multiple datasets

Hello. Here is the problem: There are 3 datasets in my report:

ds1
-------
select id1,field11, field12....
from table1
where field11=@param11 and field12=@param12 ....

ds2
-------
select id2, id1, field21, field22
from table2

ds3
-------
select id3, id1, field31, field32
from table3

ds1 contains a data for main part of report, ds2 and ds3- for it's tables.
there are references:
table1.id1=table2.id1 and table1.id1=table3.id1

i set values of @param1, @param2.... and receive SEVERAL ROWS from table1.
how can i create references ds1-ds2 and ds1-ds3 in my report to generate
SEVERAL REPORTS (1 report = 1 row from table1). And tables in these reports
should contain correct data (all rows from ds2 and ds3 which have the same
id1 as the current row from ds1.

Thanks for your help!!!


Answer this question

Problem with multiple datasets

  • Kikala

    You could try using subreports and passing the parameter values around as necessary, basically giving you a report within a report.

  • Umair Malik

    thanks a lot!
  • Problem with multiple datasets