Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Count specific values in report footer Post Reply Post New Topic
Author Message
jbalbo
Senior Member
Senior Member
Avatar

Joined: 17 Feb 2011
Online Status: Offline
Posts: 219
Quote jbalbo Replybullet Topic: Count specific values in report footer
     Posted: 13 Nov 2012 at 5:01am
Hi

I have a report grouped on client.
a client can belong to up to 4 programs
in the footer I display which programs they are in(up to four)

in the report footer I wanted to put a count of

how many clients are in 1 program
how many clients are in 2 programs
how many clients are in 3 programs
how many clients are in 4 programs

Thanks in Advance
Joe

IP IP Logged
comatt1
Senior Member
Senior Member
Avatar

Joined: 19 May 2011
Online Status: Offline
Posts: 337
Quote comatt1 Replybullet Posted: 13 Nov 2012 at 5:43am
well I would do two things

instantiate the variables in header

create four shared variables in formulas to flag a client as in 1/2/3/4 programs

create four running totals to count the number of programs a client is in

group by client

summarize distinct count of programs

in group footer find the count and do a +1 to the shared variable corresponding to number of programs

in report footer reference those shared variables

if you want elaboration I can explain further
IP IP Logged
jbalbo
Senior Member
Senior Member
Avatar

Joined: 17 Feb 2011
Online Status: Offline
Posts: 219
Quote jbalbo Replybullet Posted: 13 Nov 2012 at 11:06am
yes , if you had an example that would be great

Thanks
Joe

IP IP Logged
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