Distinct Count help
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=15605
Printed Date: 03 May 2025 at 12:16am
Topic: Distinct Count help
Posted By: ssturde
Subject: Distinct Count help
Date 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'?
|
Replies:
Posted By: ssturde
Date 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.
|
|