Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Running Total Field query Post Reply Post New Topic
Author Message
nlcdcg
Newbie
Newbie


Joined: 24 Nov 2011
Online Status: Offline
Posts: 10
Quote nlcdcg Replybullet Topic: Running Total Field query
    Posted: 25 Nov 2011 at 12:06am
Hi,
I have a Running Total field that counts the number of times that field is displayed in a report.
 
However some field values appear more than once in the report and I want the running total to count each value only once so I get a total of unique values, not the total number of times each value is displayed.
 
Can anyone tell me how to do this?
 
Thanks in advance.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 28 Nov 2011 at 3:59am
use a distinctcount instead of a count
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.035 seconds.