Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Inserting a sub-group Post Reply Post New Topic
Author Message
annc
Newbie
Newbie


Joined: 20 May 2008
Location: United Kingdom
Online Status: Offline
Posts: 4
Quote annc Replybullet Topic: Inserting a sub-group
    Posted: 20 May 2008 at 6:21am

This is only my second day of using Crystal Reports!

I am trying to create a report totalled by two groups, but do not seem to be able to add a subgroup.
 
What I am aiming for is:
 
Appeal
       Package name               Total per package
Appeal name                         Total of all packages within the appeal
 
Total                                      Total of all appeals
 
I have sorted by appeal and package, and can get the totals of each appeal, but cannot report on the packages within them.
 
Please can someone give me some advice.
IP IP Logged
Elisha83
Groupie
Groupie


Joined: 19 Feb 2008
Location: Malaysia
Online Status: Offline
Posts: 62
Quote Elisha83 Replybullet Posted: 20 May 2008 at 9:50am

You try create the total per package using "Running Total Field" function. Then put as below:-

Field to summarize:packages of each appeal

Type of summary: sum

Evaluate

-For each record

Reset

-On change of group: appeal group

Then click "Ok".

Hopefully it works for you. Is just roughly my understanding on the problem that you encountered. 

3Lish@
IP IP Logged
Lugh
Senior Member
Senior Member
Avatar

Joined: 14 Nov 2007
Online Status: Offline
Posts: 377
Quote Lugh Replybullet Posted: 21 May 2008 at 4:39am
What you are suggesting sounds like a pretty classic sub-group.  Have you gone into the Group Expert, and simply added "package" as a new group?  That should be the solution.

I also highly recommend you get Brian's books.  As they are now available in PDF, you don't even have to wait for shipping!  He has some excellent advice on handling grouping, both for basic scenarios like yours and for more complex structures.


IP IP Logged
annc
Newbie
Newbie


Joined: 20 May 2008
Location: United Kingdom
Online Status: Offline
Posts: 4
Quote annc Replybullet Posted: 21 May 2008 at 4:46am
Thank you.
 
I managed it yesterday afternoon after quite a bit of trial and error!
 
The total count of my Crystal Reports is now 7.  It will certainly save time at month end, although there will still be a bit of tweaking to do in Excel, but I am able to add them as custom reports to The Raiser's Edge, so other people will also be able to run them.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.032 seconds.