Details in Report Header?

  • Thread starter Thread starter gtslabs
  • Start date Start date
G

gtslabs

I have a report that summarizes a lot of data. I send this out to
clients every day with newly updated info. As this may get into many
pages I want an eaiser way for my clients to see the newly entered
data. I have done this so far with Conditional Formatting.

However, I was wondering if I can put records in the Report Header
section in addition to the Details Section. I was hoping to have Page
1 just show the new data and then starting on page 2 on show all the
data. Would I need a second Details section in the Report Header?
How would something like this work?

I do have 2 fields for date ranges of new data to report.
 
How do you determine what is 'new data'?

Perhaps your table has a field named EntryDate, with default value set to
=Date() so that it automatically records the date the record was created. If
so, you could type an expression like this into the Field row in query
design:
IsNew: ([EntryDate] >= Date() - 7)
This will show True (-1) for records in the last 7 days, False (0) for older
records, and Null for records that have no entry date. You could then create
a grouping in your report, to show the new records first.

Alternatively, use a subreport. That's often the solution when you need
multiple detail sections
 
Back
Top