Connecting Tech Pros Worldwide Help | Site Map

Summary Page - Best Method

  #1  
Old March 26th, 2007, 11:05 PM
BerkshireGuy
Guest
 
Posts: n/a
I have a report that is grouped based on Month / Year. Then for each
Month / Year, I have a summary for each agency of their sales. For
each group, in the group footer, I total all the agencies together to
get that month/year's over total.

This is great, but now I want the groups total information in a
seperate page (perhaps in the reports footer) so the user can quickly
go to the end of the report if they are only looking for summarized
information. Note: I don't want to total the groups summarized data,
I just want to display it again at the end of the report.

I did this by a subreport. Is that the best method?

Thanks
Brian

  #2  
Old March 27th, 2007, 04:25 AM
Tom van Stiphout
Guest
 
Posts: n/a

re: Summary Page - Best Method


On 26 Mar 2007 15:02:45 -0700, "BerkshireGuy"
<berkshireguy2005-commerical@yahoo.comwrote:

Yes.
Ideally, you would re-use the parent report, just have it suppress the
Details section. NEVER discrepancies between the two.

-Tom.


Quote:
>I have a report that is grouped based on Month / Year. Then for each
>Month / Year, I have a summary for each agency of their sales. For
>each group, in the group footer, I total all the agencies together to
>get that month/year's over total.
>
>This is great, but now I want the groups total information in a
>seperate page (perhaps in the reports footer) so the user can quickly
>go to the end of the report if they are only looking for summarized
>information. Note: I don't want to total the groups summarized data,
>I just want to display it again at the end of the report.
>
>I did this by a subreport. Is that the best method?
>
>Thanks
>Brian
  #3  
Old March 27th, 2007, 02:35 PM
BerkshireGuy
Guest
 
Posts: n/a

re: Summary Page - Best Method


Tom:

Interesting point. Never thought of using the parent as the
subreport. Honestly, I made a copy, which creates more objects than I
need.

Thanks for the tip!

-Brian


On Mar 26, 11:16 pm, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
Quote:
On 26 Mar 2007 15:02:45 -0700, "BerkshireGuy"
>
<berkshireguy2005-commeri...@yahoo.comwrote:
>
Yes.
Ideally, you would re-use the parent report, just have it suppress the
Details section. NEVER discrepancies between the two.
>
-Tom.
>
>
>
Quote:
I have a report that is grouped based on Month / Year. Then for each
Month / Year, I have a summary for each agency of their sales. For
each group, in the group footer, I total all the agencies together to
get that month/year's over total.
>
Quote:
This is great, but now I want the groups total information in a
seperate page (perhaps in the reports footer) so the user can quickly
go to the end of the report if they are only looking for summarized
information. Note: I don't want to total the groups summarized data,
I just want to display it again at the end of the report.
>
Quote:
I did this by a subreport. Is that the best method?
>
Quote:
Thanks
Brian- Hide quoted text -
>
- Show quoted text -

Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
Master Page problem Code Monkey answers 2 June 29th, 2006 04:55 PM
Pass value to new page, insert to SQL DB jenileo answers 0 March 23rd, 2006 04:45 PM
Page Load called twice! Colin Basterfield answers 2 November 18th, 2005 01:57 AM
Directly referencing the overload summary page Alex VanderWoude answers 0 November 12th, 2005 02:30 AM