Print Page | Close Window

Cross-Tab Tables

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=210
Printed Date: 07 May 2024 at 1:08pm


Topic: Cross-Tab Tables
Posted By: duncanwright
Subject: Cross-Tab Tables
Date 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!
 


-------------
Thanks

Duncan.


Replies:
Posted By: BrianBischof
Date 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>

Posted By: duncanwright
Date Posted: 14 Feb 2007 at 1:06am
Thanks Brian,
 
I'll look at redesigning the report to filter certain records before using a Cross Tab.
 
Thanks.


-------------
Thanks

Duncan.

Posted By: BrianBischof
Date 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>


Print Page | Close Window