Re: Display Group Header with No Data For Group

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?

"Piet Linden" wrote:

On Jan 27, 7:44 pm, Tired and Grumpy <Tired and
Gru...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
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.

Can you write a query to return the values you want? (Sounds like an
outer join). What if you base your report on that?

.

Relevant Pages

  • Re: Dynamic Reporting based on Parameterized Crosstab Query
    ... The tek-tips solution does display the actual date on the report. ... on the first 3 rowwise fields of the crosstab query. ...
    (microsoft.public.access.reports)
  • Re: Page totals error in report - doesnt add correctly
    ... display it on a form or report. ... query based on the Import Table. ... All Totals text boxes properties are set to General number with 2 decimal ...
    (microsoft.public.access.reports)
  • RE: creating a query for a report
    ... I need to form it into a query that will display the following ... > line name, client name, prospect name, etc. ... The header of the report and the body of the report must be displayed in the ...
    (microsoft.public.access.queries)
  • Re: missing field data in several records in a report
    ... Is there something different about the properties of the report controls ... that DO display their data, when compared with those that DON'T? ... > and the query returns all the required fields when run, ... > "Jeff Boyce" wrote: ...
    (microsoft.public.access.reports)
  • Re: Query Problem - Leaving out Records
    ... >main report. ... >> My query is working fine, ... >> One idea I have is to display what my query is ... >> DUMBY part. ...
    (microsoft.public.access.queries)