Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Max Value of record count required Post Reply Post New Topic
Author Message
esj318
Newbie
Newbie
Avatar

Joined: 25 Apr 2011
Location: United States
Online Status: Offline
Posts: 1
Quote esj318 Replybullet Topic: Max Value of record count required
     Posted: 25 Apr 2011 at 4:30am
I am counting records and need to get the max value of a group and have it show across all the details of the group. It wont let me use the Running Total for this and says the running total field cannot be summarized.
 
How can i get the count of the records in the group and have it leave the max value(which is the total number of records for the group) on the detail for each record???
 
ex....
 
PartNo   Count    Max Value
abd          1              3
abd          2              3
abd          3              3
def           1              1
fgh           1              2
fgh           2              2
 
 
Cry
 
 
 
I explained it to you in great detail so tell me you still don't get it??
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 25 Apr 2011 at 8:12am
Try this:
 
- Group by PartNo. 
- Put your data in the details section and suppress the group header and footer for the PartNo group.
- Use your running total for the record count.
- Use a Count summary of the records (NOT of your running total!) to get the max value.
 
-Dell
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