Creating a report that only summarizes certain categories

  • Thread starter Thread starter Brandon
  • Start date Start date
B

Brandon

I have a report that shows a list of projects from a
project table. The project table has a field called
category and is one to many. A category for a project
could be transportation or it could also be energy. I
want the report to list the individual projects for the
transportation projects, but for the energy projects, I
just want one line that says "Energy projects" and gives
the total for the energy projects. What is the best way
to go about this?

Example

Project Name Plan Date Dollar Savings
Transportation 1 January 05 $10,000
Transportation 2 February 05 $1,000
Transportation 3 April 05 $20,000
Energy Projects $100,000


The energy projects line could be made up of 10 projects
whereas the transportation projects are individual
projects. Thanks for your help.
 
Brandon said:
I have a report that shows a list of projects from a
project table. The project table has a field called
category and is one to many. A category for a project
could be transportation or it could also be energy. I
want the report to list the individual projects for the
transportation projects, but for the energy projects, I
just want one line that says "Energy projects" and gives
the total for the energy projects. What is the best way
to go about this?

Example

Project Name Plan Date Dollar Savings
Transportation 1 January 05 $10,000
Transportation 2 February 05 $1,000
Transportation 3 April 05 $20,000
Energy Projects $100,000


The energy projects line could be made up of 10 projects
whereas the transportation projects are individual
projects.
Click to expand...


Create a group (View menu - Sorting and Grouping) on the
category field. This will separate the transportation
records from the energy records. Specify Group Footer - Yes
in the group's properties.

In the group footer section add a text box bound to the
category field. Add another text box for the total using
the expression =Sum(savingsfield).

Finally add a line of code to the detail section's Format
event:
Cancel = (Me.Category = "Enegery Project")
 
Thanks. I'll try that!

Brandon
-----Original Message-----



Create a group (View menu - Sorting and Grouping) on the
category field. This will separate the transportation
records from the energy records. Specify Group Footer - Yes
in the group's properties.

In the group footer section add a text box bound to the
category field. Add another text box for the total using
the expression =Sum(savingsfield).

Finally add a line of code to the detail section's Format
event:
Cancel = (Me.Category = "Enegery Project")
Click to expand...
 
Back
Top