Working with the Report Header

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that I need to use the header section as a cover sheet with summary information. I need to display all of the Projects and PMs that will be in the detail section of the report and the total count of late tasks (new and recurring). My intent is to use the report header section as a summary of the details that are in the report

Any ideas as to how I can do something like this? Only the first Project and PM is being displayed.
 
Create a totals query that is similar to your report's record source. Then
create a subreport based on the new totals query. Place the subreport in
your main report's header section.

--
Duane Hookom
MS Access MVP


WMD said:
I have a report that I need to use the header section as a cover sheet
Click to expand...
with summary information. I need to display all of the Projects and PMs that
will be in the detail section of the report and the total count of late
tasks (new and recurring). My intent is to use the report header section as
a summary of the details that are in the report.
Any ideas as to how I can do something like this? Only the first Project
Click to expand...
and PM is being displayed.
 
I am having the toughest time making this report work...below is a copy and paste layout of the report summary page that I want to make happen. All of the data is in one table. In the first group, I only need to list the Projects and the number of New Watch List items that are high/medium, the Recurring items that are high/medium and then total them for each project. I want to repeat the same thing for each PM. The challenge that I am having is how to get one line for each project and PM in thier respective sections.

Any suggestions would be very much appreciated. I am struggling with this.

RED REPORT : Late Task with downstream Impact - Watch List

By Project:
New Recurring Total by Project
Project High Medium High Medium


By PM:
New Recurring Total by PM
PM High Medium High Medium


Summary Totals
Current Previous Increase / Percent
Week Week Decrease Change
New:
Recurring:
 
Sorry but this doesn't help me much. I can only suggest that you may need to
divide your "sections of records" into separate queries and then create
reports/subreports based on these queries. Then stick them all together in
your main report.

--
Duane Hookom
MS Access MVP


WMD said:
I am having the toughest time making this report work...below is a copy
Click to expand...
and paste layout of the report summary page that I want to make happen. All
of the data is in one table. In the first group, I only need to list the
Projects and the number of New Watch List items that are high/medium, the
Recurring items that are high/medium and then total them for each project. I
want to repeat the same thing for each PM. The challenge that I am having is
how to get one line for each project and PM in thier respective sections.
 
That is probably what I need to do...I was hoping to do it all in one report or perhaps two...thanks...I'll give that a shot
 
Back
Top