You don't need subreports in order to display your data. I had similar problem and here is what i did:
1. I put everything in 1 select :
Select * from (Select first query) as b left outer join (Select second query) as c on b.primaryid=c.foreignid
this give me evrything in one table so all the data is in 1 dataset
2. In order to avoid duplicates I used grouping
- first table displayed and the list grouping by the column that was b.primaryid
-second table 2 groupings, same as in the first and that what was c.primaryid
Dont forget to click "Mark as Answer" on the post that helped you. Don't "Mark as Answer" if it is not your question.
Can someone please post an answer without posting a link to a link to a link?
RioDD
Member
487 Points
331 Posts
Re: report with multiple datasets
May 21, 2012 09:23 AM|LINK
You don't need subreports in order to display your data. I had similar problem and here is what i did:
1. I put everything in 1 select :
Select * from (Select first query) as b left outer join (Select second query) as c on b.primaryid=c.foreignid
this give me evrything in one table so all the data is in 1 dataset
2. In order to avoid duplicates I used grouping
- first table displayed and the list grouping by the column that was b.primaryid
-second table 2 groupings, same as in the first and that what was c.primaryid
Can someone please post an answer without posting a link to a link to a link?