Bringing sub totals from Sub Report to Main Report

[KPR]

I've read posts that come close to solving this but I can't get it to work.
I simply have a report that reports on towns, the farmers that live in that
town and the acres they grow of different crops. I want to summarize the
total acres that each farmer grows and the total acres of each town.

---TOWN ONE-----------------------------------------
--------FARMER1--------------------------------------
-------------WHEAT 100 Acres------
-------------CORN 300 Acres------
-----------------FARMER1 ACRES 400 Acres------
--------FARMER2--------------------------------------
-------------WHEAT 200 Acres------
-------------CORN 600 Acres------
-----------------FARMER2 ACRES 800 Acres------

---TOTAL TOWN ONE ACRES 1200 ACRES

---TOWN TWO-----------------------------------------
--------FARMER3--------------------------------------
-------------WHEAT 500 Acres------
-------------CORN 500 Acres------
------------------FARMER ACRES 1000 Acres------
--------FARMER4--------------------------------------
-------------WHEAT 200 Acres------
-------------CORN 600 Acres------
------------------FARMER ACRES 800 Acres------
---TOTAL TOWN TWO ACRES 1800 ACRES


The Farmer Report is in a sub report that is working great.
How do I bring the TOWN TOTAL ACRES back to my main report?

Thanks,
Ken

 

[John W. Vinson]

I've read posts that come close to solving this but I can't get it to work.
I simply have a report that reports on towns, the farmers that live in that
town and the acres they grow of different crops. I want to summarize the
total acres that each farmer grows and the total acres of each town.

---TOWN ONE-----------------------------------------
--------FARMER1--------------------------------------
-------------WHEAT 100 Acres------
-------------CORN 300 Acres------
-----------------FARMER1 ACRES 400 Acres------
--------FARMER2--------------------------------------
-------------WHEAT 200 Acres------
-------------CORN 600 Acres------
-----------------FARMER2 ACRES 800 Acres------

---TOTAL TOWN ONE ACRES 1200 ACRES

---TOWN TWO-----------------------------------------
--------FARMER3--------------------------------------
-------------WHEAT 500 Acres------
-------------CORN 500 Acres------
------------------FARMER ACRES 1000 Acres------
--------FARMER4--------------------------------------
-------------WHEAT 200 Acres------
-------------CORN 600 Acres------
------------------FARMER ACRES 800 Acres------
---TOTAL TOWN TWO ACRES 1800 ACRES


The Farmer Report is in a sub report that is working great.
How do I bring the TOWN TOTAL ACRES back to my main report?

You want the grand total of all the towns, or what? It looks like you HAVE the
Total Town Acres shown already!

Do you really need a Subreport? I'd approach this by using Sorting and
Grouping to have grouping levels for Crop (if necessary), Farmer, and Town;
the total for each group could be displayed in that section's footer, and - if
desired - the grand total in the Report Footer.

John W. Vinson [MVP]