Cross tab not showing Null number values

[pokerace]

I have a crosstab report by year that totals the number of string fields that meet my selection criteria. The crosstab table skips the years where there are no values that meet the chosen criteria. For example,

YEAR Total
2001 5
2002 4
2004 6
2005 3

and I want it to show 0 for a year with no values to total, such as 2003 in the example. I have tried checking the Null To Default value checkboxes in Report Options but that didn't work. Is there something else I need to do?

 

[Madawc]

That's a more general problem in Crystal - it doesn't include groups that have no detail records.

You could try a 'mock crosstab', in which you define all possible totals, rather than letting Crystal create them from the data. This could be done using runnning totals which test for each possible year.


Madawc Williams (East Anglia, UK)