Display Group Header with No Data For Group

  • Thread starter Thread starter Tired and Grumpy
  • Start date Start date
T

Tired and Grumpy

I have a report with one grouping level. Some of the groups will have no
detail records, but I need to display the group headers for all groups. I
have tried everything I can think of. Please help.
 
I have a report with one grouping level. Some of the groups will have no
detail records, but I need to display the group headers for all groups. I
have tried everything I can think of. Please help.
Click to expand...

Can you write a query to return the values you want? (Sounds like an
outer join). What if you base your report on that?
 
The report is based on a query, but the issue is that it is grouped by stages
and some stages do not have any corresponding records. I did try an outer
join, but it made no difference. I just need the group name to appear for all
groups regardless of the fact there is no data for that group. Is there an
event procedure I could apply to the group to force that section to display?
 
You must have a record if you want the report to display something, so
you'll have to add a dummy for each missing stage. Often, an Outer Join can
be used for that but as you don't give any detail on your tables and the
actual query; it's impossible to give you an advice. When you can't use an
Outer Join, the usual trick would be to use an Union query.

You might have to hide the detail section for these dummy records:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

If (Me.Dummy = 1) Then
Cancel = True
End If

End Sub
 
Back
Top