Patty,
I typically handle these type of designs with data. Consider creating a new table of size groups with records like:
tblSizeGroups
SizeGroup Size ShowGroup
2.5-3.0 2.5 True
2.5-3.0 3.0 True
4.0 4.0 False
Add this table to your report's record source and join on the size fields. In your report, group first by SizeGroup and then by Size. Add code to cancel the On Format event for ShowGroup = False.
As your Management asks for different groupings, just edit the data in your table. Don't ever go to your report design.
Duane Hookom, MVP
MS Access
MS_Access_Professionals@yahoogroups.com
From: no_reply@yahoogroups.com
Date: Fri, 22 Jan 2016 12:07:18 -0800
Subject: [MS_AccessPros] Report footers
From: no_reply@yahoogroups.com
Date: Fri, 22 Jan 2016 12:07:18 -0800
Subject: [MS_AccessPros] Report footers
Hello All:
Report question
We make a product in three sizes - 2.5", 3.0" and 4.0"
There is a report for yield analysis that has a ProductSize header, a detail section, a ProductSize Footer and a Report Footer
The ProductSize header shows the [ProductSize]
The Detail section shows detail data for all withing the size - ie: DateMade, ProductSequence, WeightIn, WeightShipped etc.
ProductSize footer: shows a summary for Product Size - ie: Total WeightIn: (Sum([WeightIn]), Total WeightShipped: (Sum([WeightShipped]), Yield: Sum([WeightShipped])/Sum([WeightIn])
Report Footer: shows a summary for all Product Sizes
Everything works as expected, listing all ProductSequence data within a size, then the summary for that size, then the next size, next summary, next size, next summary, and summaries for all sizes in the report footer.
PROBLEM:
Management wants to continue showing data for each size as we have now but wants another summary after the 3.0" summary that shows the combined summary for ProductSize = 2.50 and ProductSize = 3.00.
Is this possible?
TIA,
Patty
Report question
We make a product in three sizes - 2.5", 3.0" and 4.0"
There is a report for yield analysis that has a ProductSize header, a detail section, a ProductSize Footer and a Report Footer
The ProductSize header shows the [ProductSize]
The Detail section shows detail data for all withing the size - ie: DateMade, ProductSequence, WeightIn, WeightShipped etc.
ProductSize footer: shows a summary for Product Size - ie: Total WeightIn: (Sum([WeightIn]), Total WeightShipped: (Sum([WeightShipped]), Yield: Sum([WeightShipped])/Sum([WeightIn])
Report Footer: shows a summary for all Product Sizes
Everything works as expected, listing all ProductSequence data within a size, then the summary for that size, then the next size, next summary, next size, next summary, and summaries for all sizes in the report footer.
PROBLEM:
Management wants to continue showing data for each size as we have now but wants another summary after the 3.0" summary that shows the combined summary for ProductSize = 2.50 and ProductSize = 3.00.
Is this possible?
TIA,
Patty
__._,_.___
Posted by: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar