Unsuppress null values in a cross tab

[shaleen7]

Currently my crosstab suppresses any month that has no values yet, in other words the field is null.

Current Results
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Total

# Cars 1 3 8 6 5 5 3 2 7 8 48

I would prefer that the months with null values display zeroes in them. See below.

Desired Results:
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

# Cars 1 3 8 6 5 5 3 2 7 8 0 0



Any help would be appreciated.

Thank You

 

[midearth]

Insert a formula into the summary field of the crosstab.

If IsNull({your.field}) then 0 (or "0" if a string field)