Greetings!
I am trying to caluclate the total for a report that I am writing and I cannot seem to figure what sections to put in the total function. Let me explain the report.
The report shows truckloads of lumber that have been deliverd, when they've been delievered, where the lumber came from, and what was delieverd. They layout of the report is as such.
Place #1 that the lumber came from
-Destination #1 that is was delieverd
--Date #1
---Load#1
----Species #1 of Load #1
----Species #2 of Load #1
---Load #2 of Date #1
---- Load #2 Species
--Date #2
...
-Destination #2 of lumber from Place#1
...
Place #2
...
It's a fairly detailed report. The report works fine. The data is split up using Groups, and sub-report in the footer of of the Tract.
The Subreport cycles through the Species, and displays all species type used in the Tract. It does this. The problem that I am having is with the total function.
I need the total amount of lumber delievered for each species from each tract.
I've spent close to 3 hours redesiging the report, cycleing through combinations and I'm stuck. I have no idea why I can't get this total function to calculate.
I can get running totals, and such but no total. I have attached a picture showing the report layout. Each group breaks on a change in it's "group Name" so Group "Cutting_Date" breaks on each change in the Cutting_Date.
I am trying to caluclate the total for a report that I am writing and I cannot seem to figure what sections to put in the total function. Let me explain the report.
The report shows truckloads of lumber that have been deliverd, when they've been delievered, where the lumber came from, and what was delieverd. They layout of the report is as such.
Place #1 that the lumber came from
-Destination #1 that is was delieverd
--Date #1
---Load#1
----Species #1 of Load #1
----Species #2 of Load #1
---Load #2 of Date #1
---- Load #2 Species
--Date #2
...
-Destination #2 of lumber from Place#1
...
Place #2
...
It's a fairly detailed report. The report works fine. The data is split up using Groups, and sub-report in the footer of of the Tract.
The Subreport cycles through the Species, and displays all species type used in the Tract. It does this. The problem that I am having is with the total function.
I need the total amount of lumber delievered for each species from each tract.
I've spent close to 3 hours redesiging the report, cycleing through combinations and I'm stuck. I have no idea why I can't get this total function to calculate.
I can get running totals, and such but no total. I have attached a picture showing the report layout. Each group breaks on a change in it's "group Name" so Group "Cutting_Date" breaks on each change in the Cutting_Date.
Comment