Solved

Creating Summary Page of Group Counts

Posted on 2008-10-28
2
251 Views
Last Modified: 2008-11-04
Hello everyone and thanks in advance for any help. I have a report that has two levels of groupings and a count of how many records for each group. What I want to do is create a summary page at the end of the report that will show each group title and the count associated with it. I can't seem to figure out how to get the group name and count in the report footer(maybe it should be in a different section?) to create the summary of the report.

Summary Page Example:
Total Record Count: 5000
Group A Record Count: 1000
    User 1 Record Count: 500
    User 2 Record Count: 500

Group B Record Count: 2000
    User 3 Record Count: 1000
    User 4 Record Count: 1000

Group C Record Count: 500
    User 5 Record Count: 500

Group D Record Count: 1500
    User 6 Record Count: 750
    User 7 Record Count: 750

Again thanks for any help.

Ken
0
Comment
Question by:kw7669
2 Comments
 
LVL 17

Accepted Solution

by:
MIKE earned 125 total points
ID: 22831605
Use VARIABLES to accumulate and then display the summary totals. Use multiple Report footer sections if needed to have the summary appear in a more "polished" straight looking summary.

0
 
LVL 100

Expert Comment

by:mlmcc
ID: 22854331
An easier way would be to use a subreport that just shows the summary and put it in the report footer.

mlmcc
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question