Report with SubReports

[Erik]

Hello:

I have a pretty complicated report. It has five subreports within it. I used Access's Report Wizard to begin building the Report and then Finished it in Design view. The main part of the report is in the Users.LastName.Header section. Employee Work Assignments are in the Employees.Header Detail Section. Then I had five subreports that all link to the main report via a field called "ID_Link". I placed these subreports in the Report Footer Section. When each of these subreports has data, the report looks great. However, if any of the subreports has not data entry for that particular ID_Link, all of the subreports end up being left blank. This is even though some of the other subreports do have data. Is there anything that I can do that will prevent no records in one of the subreports from preventing other subreports from displaying?

This is a real brain twister from me, so if anyone can understand what I am trying to do and has suggestions, I'd sure appreciate them.

Erik

 

[Rich]

Are they linked to each other?

 

[Erik]

Yes - they are linked as far as I can tell. The Link Child Fields is [ID_Link] and the Link Master Fields is [ID].

I'm running this report again, and now it seems to be working correctly. The subreport with data displays, while the subreports without data only display the report label, which is what I want. I have one other subreport that was based on calculations from data in each of the other subreports, so when data is missing, of course, this final subreport will not display. I think I can work around this by having the data source be a table that is created from all of the source data, and then I'll make sure that I do not have null data in that table.

So for now, I don't think I have as big a problem as I originally thought. Thanks for your input Rich.

Erik

 

[Rich]

I'd rather use the HasData method then a make table, just a thought.

 

[Erik]

Can you tell me what the HasData method is and how to use it?