Solved Force data in and printing of report footers w/no detail records (1 Viewer)

[HarryNeil]

I have a report that summarizes the on-hand quantities of detail records in a group footer. Groups with no details show in the "report view" but not in the "print view," which is according to design.
But I want to process with vba those group footers which have no detail records, force in zero values, and then force them to print. Seems like this ought to be doable. Is it, and how?
Thanks to anybody who can help!

 

[theDBguy]

One possible approach is to force a group to always show up in the records by using an outer join and the Nz() function to show the zero values.

 

[Pat Hartman]

Seems like this ought to be doable. Is it, and how?

Depends. Report View and Print Preview operate very differently. Only limited code runs in Report View and there is no grouping or pagination.