Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Day 3 Frustration Post Reply Post New Topic
Author Message
hackera40
Newbie
Newbie
Avatar

Joined: 22 Mar 2011
Online Status: Offline
Posts: 9
Quote hackera40 Replybullet Topic: Day 3 Frustration
    Posted: 23 Mar 2011 at 4:31am
For 3 days I have been trying to get my head around this problem.  I am trying to get a count on distinct records on a multi-value field. Here is what I have:
 
Year:     Record#      Date1               Date2                Date3
2008     AAAAA         01/01/2008      02/01/2008       03/01/2008
2008     BBBBB         01/01/2008      02/01/2008       03/01/2008
2008     BBBBB         05/01/2008      06/01/2008
2008     BBBBB         07/01/2008
2008     CCCCC        01/01/2008
2008     DDDDD        01/01/2008      02/01/2008
2008     DDDDD        06/01/2008
 
Total:     4                      4                      3                          2
 
The totals are correct.  I need a unique count for each record# per date count.
 
The record# total needs to tell me how many unique records there are.
 
Date 1 needs to tell me how many dates per unique record.  Same goes for Date2 and Date3.
 
I have very little hair left and I would like to keep the little that I have left. Can anyone help with this? Cry
 
 
IP IP Logged
Keikoku
Senior Member
Senior Member


Joined: 01 Dec 2010
Online Status: Offline
Posts: 386
Quote Keikoku Replybullet Posted: 23 Mar 2011 at 4:42am
Sorry, I am not quite sure what you are looking for.
Can you give an example of the expected output?
IP IP Logged
hackera40
Newbie
Newbie
Avatar

Joined: 22 Mar 2011
Online Status: Offline
Posts: 9
Quote hackera40 Replybullet Posted: 23 Mar 2011 at 4:50am
The output is the total date instances per unique record.  The unique record being "Record#"
 
The totals that I had displayed are the correct results I want to display in my crystal report.
 
So the headers would look like this:
 
Year     Record#         Date1                 Date2             Date3
 
The results should look like:
 
2008        4                    4                        3                      2
 
The problem is getting a summary formula to give me those totals.
BTW .... thanks for your quick reply.
 
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 23 Mar 2011 at 5:36am
create 4 running totals
1 is just a distinctcount(Record#)
 
The others are the same DistinctCount of RecordA field but use an evaluate formula where each date field is not null...
RT 2 would be  Not(isnull(date1))
RT 3 would be  Not(isnull(date2))
RT 4 would be  Not(isnull(date3))
 
Place all 4 RTs in your report footer
 
IP IP Logged
hackera40
Newbie
Newbie
Avatar

Joined: 22 Mar 2011
Online Status: Offline
Posts: 9
Quote hackera40 Replybullet Posted: 23 Mar 2011 at 10:37am
You have made my day!!
 
Thank you very much.  It worked nicely and it helped me with a few other reports that needed attention.  Much appreciated.
 
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.018 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2025 Brian Bischof. All Rights Reserved.