Joined: 13 Feb 2007
Location: United Kingdom
Online Status: Offline
Posts: 2
Topic: Cross-Tab Tables Posted: 13 Feb 2007 at 8:04am
Hi there,
I'm currently designing a basic cross tab report but I would like to supress rows with negative totals. I've tried to find a way of doing this but with no luck. If anyone can shed any light on this I'd be more than grateful!
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Posted: 13 Feb 2007 at 9:45am
I don't think you can do it b/c it requires filtering out the total column. If you could make a list ahead of time of the rows that will be negative, then you could use this to filter the data before it gets to the cross-tab. But to filter rows after the cross-tab has already processed the data is too late.
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: 09 Nov 2006
Online Status: Offline
Posts: 2458
Posted: 14 Feb 2007 at 9:52am
Sounds like the right way to go about it. People try to do too much with the cross-tab object when a lot of times you are better off cleaning up your data on the server prior to printing it.
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>
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