Crystal Reports CR xi with ClearQuest

Technical Questions
Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions

Topic: CR xi with ClearQuest
	<< Prev Page of 2

Author	Message
DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 30 Aug 2011 at 7:34am
	try in the evaluate formula change pick list option to 'Default values for Null'
	IP Logged

bullagirl Newbie Joined: 24 Aug 2011 Online Status: Offline Posts: 12	Posted: 30 Aug 2011 at 8:08am
	still no
	~Randi
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 30 Aug 2011 at 10:47am
	for clarity sake you want a distinct count of the clearquest.id for records that only have a close date or a review date between 8/23/2011 and 8/30/2011. correct?
	IP Logged

bullagirl Newbie Joined: 24 Aug 2011 Online Status: Offline Posts: 12	Posted: 31 Aug 2011 at 3:34am
	I need a unique count for records that have a review date between the range OR a closed date between the range. There may be records that would be identified in both groups. My query shows 32 with Review and 25 with Closed - when run separately. I just can't get those same numbers to appear on the report. The report is showing 32 with Review and 2 with Closed (incidentally, there are 2 records within Review that have a closed date within the range, so I think that's where the 2 is coming from).
	~Randi
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 31 Aug 2011 at 3:58am
	So if you alter your RT to test fot counting only reviewdates what value do we get... name = whatever field to summarize=ClearQuest.id summary type = distinctcount evaluate = use a formula {ClearQuest.review_date} in last7days reset=never place in the report footer If 0 (or empty) look on your detial rows where you know that one of those dates exists and look to make sure there is a value that is a non NULL for the ClearQuest.id on that same detial row. What does this test give us?
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 31 Aug 2011 at 3:59am
	you can also place the RT on the detail section and you can see it change (add or stay the same) per row to know which rows aer being counted and which are being ignored. This can help you determine what is working as intended and what is not.
	IP Logged

bullagirl Newbie Joined: 24 Aug 2011 Online Status: Offline Posts: 12	Posted: 31 Aug 2011 at 7:28am
	Thanks. I'll try that next!
	~Randi
	IP Logged

<< Prev Page of 2

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.