Cross tab to show null value

[sdzlkds]

Where a field has, for example 4 values, is it possible to set up a cross tab to show all values even when some of the values do not appear?

So, I would like the cross tab to always show A,B,C&D - like this

A=1
B=5
C=2
D=4

But if there is no data meeting C, the cross tab returns

A=1
B=5
D=4

So, what I would like would be

A=1
B=5
C=0
D=4

I'd be grateful for any advice if this is possible

I'm using Crystal v10, but have access to V11

Thanks

 

[lbass]

Please see thread149-1567016.

-LB