Needing to show Values as Null and not 0 in Crosstab

[michbell]

Okay. I'm using CR 9, and Informix (Unix)

I have a crosstab that is displaying null values as 0. And all I want is for the null values to stay blank because I use this crosstab in a line graph, and I don't want the null values appearing as zeros in it. I've been searching through all the threads, and can't find anything that works.

The report groups:
GH1 = {date}, monthly
GH2 = {date}, yearly

The crosstab looks like this: (it's in the RF)

2003 2004 2005
Jan 19% 10% 20%
Feb 20% 12% 19%
Mar 15% 11% 0%
Apr 25% 18% 0%
(and so on through Dec)

in the Crosstab Expert, I've set it up like this:
rows: left(Monthname(Month({date})), 3)
columns: year({date})
summarized field: Max of @% (where @% = Sum({lbs_scrapped},{date},"monthly")/Sum({lbs_produced},{date},"monthly")

I actually would like to just display @%, but I had to set up this field as a maximum because it doesn't give you the option to not summarize in the crosstab expert.

Anyway... as you can see in the crosstab, for the months that have no data (future months), it defaults as 0%, but I would like it to just show as null so that my line graph doesn't show 0 values for future months.

I've tried going to Report Options and unchecking the "convert null values to default". I've also tried using various formulas to suppress the null values, but I guess I'm missing something.

Any help would be greatly appreciated. Sorry for the length!!

 

[smsaji]

Know it's long time since the question has been asked. But if anyone is in such a scenario...

In Design or Preview mode of the Crosstab:

Right click on 'summary field'-> Format Field -> click Number tab -> click Customize button -> uncheck 'Suppress if zero'

-saj