Report Total Problem

[Mitch Powell]

I have a report using a data source with 15 columns: Job, Account, Year and
Jan-Dec. The report is grouped by Job. For each Job there are 10 accounts
and 4 years for a total of 10 X 4 = 40 records for each Job. The 40 records
for each job print on a single page and there is a page break for each new
job. Here's my problem:

I want a "Totals" page that shows the total for each of the 40 records
contained in all the preceeding Job pages. This page would look exactly like
the individual Job pages (i.e. 40 records) but would represent report totals.
I put the Account, Year and Month fields (using =Sum([month]) syntax) in the
report footer but all I get in the report footer page is a single record
displaying the first Account and Year. What am I missing?

 

[Marshall Barton]

I have a report using a data source with 15 columns: Job, Account, Year and
Jan-Dec. The report is grouped by Job. For each Job there are 10 accounts
and 4 years for a total of 10 X 4 = 40 records for each Job. The 40 records
for each job print on a single page and there is a page break for each new
job. Here's my problem:

I want a "Totals" page that shows the total for each of the 40 records
contained in all the preceeding Job pages. This page would look exactly like
the individual Job pages (i.e. 40 records) but would represent report totals.
I put the Account, Year and Month fields (using =Sum([month]) syntax) in the
report footer but all I get in the report footer page is a single record
displaying the first Account and Year. What am I missing?

Using expressions for that kind of calculation is not
pratical. Instead, create a new Totals query based on the
report's record source query and do the calculations there.
Then create a new report based on that new query and use it
as a subreport on your wxisting report.

 

[akphidelt]

Im not sure what you are trying to do can be done like the way you want to do
it. What I do when I want to show multiple types of info on a single report
is to create a subreport in the report header or report footer section. So in
your case under the report footer section you would insert a subreport and
create the report that groups the information by jobs and shows the totals.

If you want an easy way to create a subreport... right click on the
subreport, go to properties. Make sure you go to the properties where it says
report. Then under the Record Source... click the little 3 periods "..." and
create a query that does all the grouping and totalling for you.