Senin, 25 Januari 2016

Re: [MS_AccessPros] Re: Report footers


Hi Patty,

Can you give an example with some data so it is clear exactly what you mean?


warm regards,

~ have an awesome day ~

On 1/25/2016 9:23 AM, patrinod wrote:
Hi Crystal ...

I already have a textbox with a count in the footer area to compute averages. If one of the 2 sizes is made within the SizeGroup the count is > 1. I want to hide the SizeGoup footer if only 1 of the 2 sizes is made.
It's not a big problem having the SizeGroup footer shown if only 1 of the 2 sizes is made, but I'm just an old guy who likes things to look as clean as I think they should. 

Thanks for your input

---In, <strive4peace2008@...> wrote :

while it will take longer for the report to process, you can do this:

1. put a textbox control (visible=no, delete corresponding label) in the group footer:

Name: txtCountSize
ControlSource: =Count(*)

2. then in the group footer OnFormat event:
me.GroupFooter_controlname.visible =  Iif(me.txtCountSize > 1, true, false)

warm regards,

~ have an awesome day ~

On 1/24/2016 10:29 AM, patrinod wrote:
Bill and Duane  ...

Thanks for your solutions.
Bill - I had already tried trying to use the if function, but would get a total of all sizes. I believe it somehow would need a where clause.
Duane - Your solution by creating a new table for the size groups and not having to go back to the table design works great!
QUESTION: If only one of the 2 sizes (2.5 and 3.0) is made within the report time period, is there any way to suppress the SizeGroup footer. A minor annoyance.

Thanks again for your help

---In, <duanehookom@...> wrote :


I typically handle these type of designs with data. Consider creating a new table of size groups with records like:

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
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.
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? 




Posted by: crystal 8 <>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (7)



Tidak ada komentar:

Posting Komentar