Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Cross Tab: not surpressing columns required Post Reply Post New Topic
Author Message
Valmont
Newbie
Newbie
Avatar

Joined: 29 Jan 2007
Online Status: Offline
Posts: 39
Quote Valmont Replybullet Topic: Cross Tab: not surpressing columns required
    Posted: 13 Sep 2007 at 10:10am
Suppose I have a crosstab. Nothing special. It just shows the types of products sold - daily. The products are renamed (and ordered) by using "Special Order". Very basic until now.

Example:

                Expensive Suits | Mediocre Suits | Cheap Suits |
13/sep2007          5           |        0       |         3
12/sep2007          0           |        0       |         2


But suppose a certain product was never ever sold (see Mediocre Suits). Then the column for this product never appears. How can I force CR XI to make this column appear and showing only zero's?

I need the appearance of all columns (sold or not sold)  for programming purposes later on.


Edited by Valmont - 13 Sep 2007 at 10:18am
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 13 Sep 2007 at 1:21pm
Yeah, this is tricky. One option is to add a dummy record in the table with a Mediocre Suit and count of zero just to get it in the list. Another option is to have a table with every suit type in it and then do an left outer join to make it get up in the list (and convert nulls to zero).
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>
IP IP Logged
Valmont
Newbie
Newbie
Avatar

Joined: 29 Jan 2007
Online Status: Offline
Posts: 39
Quote Valmont Replybullet Posted: 14 Sep 2007 at 1:35am
Another option is to have a table with every suit type in it and then do an left outer join to make it get up in the list (and convert nulls to zero).
 
That's exactly what I did. Doesn't work. Converting nulls is just a setting in CR right? I did!


Edited by Valmont - 14 Sep 2007 at 1:37am
IP IP Logged
Keerthana_CR
Newbie
Newbie


Joined: 14 Sep 2007
Online Status: Offline
Posts: 3
Quote Keerthana_CR Replybullet Posted: 14 Sep 2007 at 1:45pm
Make sure you used the right outer join or left outer join as needed based on where you used this table with every suit type in it
 
Thank you
IP IP Logged
Post Reply Post New Topic
Printable version 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.031 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.