Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: How do I do it? Post Reply Post New Topic
Author Message
jdanderson02
Newbie
Newbie
Avatar

Joined: 04 Aug 2008
Online Status: Offline
Posts: 3
Quote jdanderson02 Replybullet Topic: How do I do it?
    Posted: 04 Aug 2008 at 10:10am
My guess is that this is pretty simple but my limited usage of Crystal has left me stumped om how to create a summary report. I have several hundred rows of data in a dataset from which I need to create a summary report. The data needs to be summarized by date and location and then totals of some elements for each location during the date period.
 
Here is an example of the dataset:
 
Date Referred Name Location Gender Status HL Referral Date HL Referral Type Bench OTC
7/29/2008 Doe, Jane Waterford Female Open F No
7/29/2008 Smith, John Willimantic Male Open F No
7/24/2008 Mouse, Minnie Waterbury Female Closed 7/24/2008 0:00 V No
7/23/2008 Griffin, Stewart Waterford Male Open No
7/23/2008 Scott, Michael Waterford Male Closed A Yes
7/23/2008 Dingle, Barry Waterford Male Open V No
7/23/2008 Rodriguez, Alex Willimantic Male Open Yes
I need to generate a summary that looks like:
 
 

Gender

 

HL Referral Type

July-08 Referrals

Male

Female

HL Referrals

A

F

V

Waterbury 1 0 1 1 0 0 1
Waterford 4 3 1 0 1 1 1
Willimantic 2 2 0 0   1 0
 
Oh, and then total all columns fo the month, year and overall.
 
This must be simpler than I am making it out to be. Any help would be greatly appreciated. Thanks in advance.
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 04 Aug 2008 at 11:01am
Unfortnately, it's actually not that simple. There is a lot going on in here. Since you have limited knowledge of Crsystal, it will probably take a bit of time for you to get working.

First off, to get the basic summaries working, create a new group based on Location. This will get you the formatting you want. Secondly, you want to put the records the Details section and right-click on them and choose Insert > Summary to get the subtotals in the Group Footer section. Then hide the Details section.

The next tricky part is counting the Males and Females. You need a 'Male' formula that returns 1 if the field is Male and the same for Female. Put each formula in its own column. It would  be like:
if {table.Location} == 'Male' then
    1;

Work on that for a while and see how much progress you make, then report back to let us know how its going. 
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
jdanderson02
Newbie
Newbie
Avatar

Joined: 04 Aug 2008
Online Status: Offline
Posts: 3
Quote jdanderson02 Replybullet Posted: 04 Aug 2008 at 1:12pm
Thanks, Brian. This is helpful. I'l let you know how it comes out. Thanks, Jay.
IP IP Logged
jdanderson02
Newbie
Newbie
Avatar

Joined: 04 Aug 2008
Online Status: Offline
Posts: 3
Quote jdanderson02 Replybullet Posted: 11 Aug 2008 at 11:09am
Thank you, Brian. This approach was exactly what I needed. Thanks for your help.
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.031 seconds.