Cross Tab and General Crystal Reports question

[Bestbegood]

I have Crystal Reports 10 and I have a cross tab where I display Trouble ticket totals by number of hours open. I display -24 hours open, +24, +48, and +72 hours open with a separate column for each of these showing number of tickets in each time frame. My problem is sometimes one or more of these columns have no tickets to display and they are left off the list. For example their might be only two columns displaying instead of four one is -24 and the other is +72. I would like for every column to display and just have a zero in the columns with no tickets. Unfortunately Crystal does not check my formula which has a ISNULL checker in it. It seems to just skip that column regardless. Does anyone have a fix?

 

[lbass]

Create a manual crosstab instead. Create 4 conditional formulas like:

if {@hoursopen} in -24 to 0 then 1

Then insert summaries on the conditional formulas (sums, not counts). If you have row inflation, could use running totals instead.

-LB

 

[Bestbegood]

THanks that might work..