Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Cross Tabs and Calculated Columns Post Reply Post New Topic
Author Message
cgraham
Newbie
Newbie
Avatar

Joined: 15 Sep 2009
Location: United States
Online Status: Offline
Posts: 1
Quote cgraham Replybullet Topic: Cross Tabs and Calculated Columns
     Posted: 15 Sep 2009 at 2:15pm
I've been using Crystal for about 15 years and ran into something that I can't figure out ...
 
I'm reporting on a CRM application, and have "bucketed" closed tickets within a date range parameter into the following groups via a calculation:
- 0-2 days open
- 3-5 days open
- 6-10 days open
- 10+ days open
 
These are the columns of the crosstab.
 
The rows are the Severity of the case which range from one through four.
 
Here's the problem.  We want the columns and rows of the cross tab to ALWAYS be the same - but if there is no value for a column/row ... it will not show on the cross tab. 
 
Has ANYTONE worked through this to keep columns AND rows consistent ... even when a column header is a formula?
 
Working on a report and my VP is CHOMPING AT THE BIT  :)
Thanks,
Chrissy
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 15 Sep 2009 at 2:46pm

Not sure how you will do this based on your desciription but you need a source that has all of your options then you outer join to that source and use that as your coolumn data rather than the origianl table data.

You could create a table with your strings (0-2 days open, 3-5 days open, etc.) then use a case statement outside of crstal or in a command to create a value in your table to match (basically your datediff() formula you have in crystal) and then outerjoin the 2.
Same concept or your Severity.
Not easy but I hope it helps.
IP IP Logged
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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.