Home
Crystal Reports Training
Crystal Reports XI
Crystal Reports .NET
Crystal Reports Forum
News
Tech Support
Active Topics
Memberlist
Search
Help
Register
Login
Report Design
Crystal Reports Forum
:
Crystal Reports 9 through 2022
:
Report Design
Topic: Count specific values in report footer
Author
Message
jbalbo
Senior Member
Joined: 17 Feb 2011
Online Status: Offline
Posts: 219
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 Logged
comatt1
Senior Member
Joined: 19 May 2011
Online Status: Offline
Posts: 337
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 Logged
jbalbo
Senior Member
Joined: 17 Feb 2011
Online Status: Offline
Posts: 219
Posted: 13 Nov 2012 at 11:06am
yes , if you had an example that would be great
Thanks
Joe
IP Logged
Printable version
Forum Jump
-- Select Forum --
Announcements
Talk with the Author
Self-Publishing
Job Postings
New feature request
Report Design
Data Connectivity
Technical Questions
Tips and Tricks
Crystal Xcelsius
Report Design
Data Connectivity
Writing Code
Tips and Tricks
Report Design
Data Connectivity
Writing Code
Tips and Tricks
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
HOME
|
FREE EBOOK
|
PROGRAMMING GUIDE
|
PURCHASE
|
REVIEWS
|
CONTACT ME
|
FAQ
|
LINKS
|
PRIVACY
|
CLICK PLAYS
|
KONACAD
© 2004-2026 Brian Bischof. All Rights Reserved.