Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Tips and Tricks
Message Icon Topic: Distinct Count help Post Reply Post New Topic
Author Message
ssturde
Newbie
Newbie


Joined: 10 Feb 2012
Location: United States
Online Status: Offline
Posts: 2
Quote ssturde Replybullet Topic: Distinct Count help
    Posted: 10 Feb 2012 at 9:22am
I'm trying to chart a distinct count of records based on the change of a formula. My problem is that for one result of the formula all of the records meet the criteria.

For every group record there is a set of tasks in the details. Every group record has 'Task A'. Only a subset has 'Task B'. My formula labels the tasks, but when i try to summarize in a chart with a distinct count of the parent records, it sees the 'Task B' items but then also shows all of the 'Task A' items, thus skewing the total 'Task A' count by the amount of records with 'Task B'.

e.g. 100% of records meet criteria A only 42% meet criteria B therefore 58% do not meet criteria B.

How do I get my chart to differentiate that parent records with 'Task B' should NOT be included in the count of parent records with only 'Task A'?

Edited by ssturde - 10 Feb 2012 at 9:56am
IP IP Logged
ssturde
Newbie
Newbie


Joined: 10 Feb 2012
Location: United States
Online Status: Offline
Posts: 2
Quote ssturde Replybullet Posted: 10 Feb 2012 at 9:42am
Is there a way to filter my record selection to only pull the last child record? This would work in every case, then I'd only have one result for the formula per parent.
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.016 seconds.