crosstab showing 0 values

[kingj1]

Hi all,
I'm using CR XIr2 and want to create a crosstab report that shows the number of cases created in an hour.

I'm using forumula: hour(createtime)

Data:

Hour: # Cases:
-----------------
1 2
2 1
3 0
4 0
5 0
6 0
7 5
8 10
9 15
10 20

etc ....

The problem is that hours 3,4,5,6 don't show in crosstab because the total is 0.

Any ideas ?

 

[kingj1]

I figured it out. FYI, I can get the desired effect by using a Chart-Numeric Axis type.