Print Page | Close Window

Crosstab specific order bug?

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=233
Printed Date: 02 May 2024 at 5:43am


Topic: Crosstab specific order bug?
Posted By: Valmont
Subject: Crosstab specific order bug?
Date Posted: 21 Feb 2007 at 2:30pm
CRXI

When creating a crosstab, I need to sort the columns in specified order. The rows are dates:

                UserName
                GROSS    |    NET    |    SCHEDULE  |    IMMEDIATE  (<----- this column is "specified order")
DATE


The second column is sorted in "specified order".

I name the groups in specified order and then I define each group using options like "Is Like" and "Starts With". No problems there.
However, not all colums appear! For example, "IMMEDIATE" doesnt appear.
But if I change the order in the "specified order" tab, for example I let "IMMEDIATE" be the first column instead of "GROSS" then it suddenly appears (with the correct data)! But then again, I may lose "NET" or "SCHEDULE".

Does anyone know what's going on here?


Replies:
Posted By: Valmont
Date Posted: 06 Apr 2007 at 3:53am
Solved.
IMMEDIATE has elements in it which are a subset of NET.
Therefore, CR XI has problems figuring out which column to choose. It picks just the first occurance it sees (determined by the order in cross tab expert).
 
Solution:
Make sure none of the elements in a coumn is also part of another column.

Posted By: BrianBischof
Date Posted: 06 Apr 2007 at 11:17am
What do you mean "subset of NET"? I'm confused about what actually caused you problems. Can you explain a little more?

-------------
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: Valmont
Date Posted: 07 Apr 2007 at 4:47am
I'll gladly do but not this weekend. Let's wait until I am at work so I copy the cross table setup.


Print Page | Close Window