Rpts: Force Group Header Even If No Data

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










-----Original Message-----
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


.