Headers in Subqueries

[jmcd2000]

If no data is returned in a subreport the column headers within the reports are not printed - I wish to force them to be printed.

Is there anyway to do that in Access 2002??

Thanks.

 

[CosmoKramer]

You can move the column headers to the main report, placing them above the subreport. This way, they will print whether or not there is data....

Hoc nomen meum verum non est.

 

[jmcd2000]

Thanks but I had already tried it that way - the problem is that if the subreport continues onto a second page the headers cannot be set to repeat.

Any ideas???

 

[CosmoKramer]

Is the subreport near the page header of the main report?? If it is you can put the column headers there...

Hoc nomen meum verum non est.

 

[jmcd2000]

No, I can have 3/4 subreports per main report and they are not at the top of the main report.

I have found a way to check from the main report to see if the subreport has no data but then what to do!

 

[CosmoKramer]

Create a group in the subreport that is grouped on the value =1. This creates a dummy group. Move the column headers back to the subreport's new group header.

Suppress the report header of the subreport and use this group header as the report header. Because it's a group header, it has a Repeat Section property which you can set to Yes, and Access will repeat it at the top of each new page.


Hoc nomen meum verum non est.

 

[jmcd2000]

Thanks again.
I had tried something similar with a group header - the problem seems to be of there is no data in the sub report it never goes into the sub report so controlling the headers within the sub report doesn't work.