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!!!
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!!!

Problem with multiple datasets
Kikala
Umair Malik