subreport problem

[livvie]

I have a report with a header and 3 subreports all linked by id but the sub reports will only display if there is data for all three subreports. They need to be linked

 

[hymn]

Do a search on HasData in help you will find the info for your problem

Hope this helps
Hymn

 

[dhookom]

I expect that any of the three will show if there is linked data in the individual subreport. If there is no data, the subreport absolutely will not show. What do you expect to see if there is not data in the subreport? Whatever you want to see can be placed on the main report and set to invisible. If the subreport has no data, then make the controls visible.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[livvie]

If one subreport has no data NONE of the subreports show at all.

 

[hymn]

in the control field of the total the code below works

=IIf([OneofYourSubReports].[Report].[HasData],[OneofYourSubReports].[Report]![Total],0)+(IIf([anotherofYourSubReports].[Report].[HasData],[anotherofYourSubReports].[Report]![Total],0))+(IIf
Etc
the above will give you a total even if one has no data

The sub reports should be placed in the report footer

Hope this helps
Hymn

 

[livvie]

thanks hymn