Rpts: Force Group Header Even If No Data

  • Thread starter Thread starter S Jackson
  • Start date Start date
S

S Jackson

I have a report that is grouped by a field named [Region]. The report is
launched from a dialog form which contains a Region List Box. The report
prints data for Regions selected in the list box. If there is no data
present for one or more of the Regions selected, the report does not print
the Group Header for that Region. However, is there a way to force the
report to put in the Group Header for all the Regions selected regardless of
whether data is present and then put in a text box in that Detail Section
that says "No data" for regions containing no data?

I've looked at report properties and events, the group properties, . . .
can't figure this one out. Is it possible? Would it be the On Format event
of the report?

TIA
S. Jackson
 
The only way you can is to have the query be an outer join
on the Regions table. That way, you will have a header
for regions with no data.



Chris Nebinger
 
Back
Top