Joined: 22 Mar 2007
Location: United States
Online Status: Offline
Posts: 30
Topic: Distinct Count Posted: 31 May 2007 at 10:06am
Hi guys,,, question... im using distinctCount on my report, but i notice that it counts the 0 or blank space (browse data). Is there a way to suppress the count on blank or 0 data...Also, that blank space and 0 only shows up in Crystal.. any idea why?
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Posted: 31 May 2007 at 1:24pm
I don't know that one. I would have to play with the data to figure out what is going on behind the scenes. Sorry.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
Joined: 29 Jan 2007
Online Status: Offline
Posts: 39
Posted: 04 Jun 2007 at 3:32am
I have the same problem as well.What I do is making a cross table and then hide the empty columns/rows. Then the numbers are correct.
However, the empty results are not shown in the details section of the report, which is a good thing. only in crosstables and sometimes while grouping.
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
IP Logged
