Report Problem

[livvie]

I have just created a report with 3 sub reports and I have a big problem with it.
1. Unless there is data for all three subreports I get no data at all.


I need help !

 

[P_Henry]

Are the reports linked? I have multiple sub reports and I have set up different queries for each of them and they are not linked. This seems to work.
Priya

 

[livvie]

yes they are all linked but they need to be that's the whole purpose of using a sub report isn't it.

 

[Rich]

Does the main report contain the Parent data?

 

[livvie]

The report is main up of data from 4 tables all linked by id.
I have it grouped by id and have data in the header then in the page footer I have 3 subreports. I had to put then in the footer to suppress duplicates.