How to Suppress the Null for Chart

[rajasan77]

I working CR 2008. I have a chart to show the number of records by "Pending Reason". I dont want to show count in the chart if there is null for the pending reason.

But, Still I want to show all the records(both with null and not null) in the report(detail section)
Can anyone help me???

Thanks,
Raja.

 

[lbass]

Create a formula to use instead of the count:

if not isnull({@pendingreason}) then
1 else
tonumber({@null})

...where {@null} is a new formula that you open and save without entering anything.

Insert a sum on this. If you are summing a value, then replace 1 with that number field.

Another option would be to insert a subreport where you do limit the records to non-null values.

-LB

 

[rajasan77]

<<Insert a sum on this. If you are summing a value, then replace 1 with that number field.>>

I don't understand this. can you please be more specific?

Thanks,

 

[lbass]

I didn't know if you were counting some field or summing a qty/amount field. I put 1 in the formula if you were "counting" although you should use "sum" on this formula to ensure a zero doesn't appear. If your field is a qty/amount, then substitute the name of that field for "1" and again, use sum.

-LB

 

[rajasan77]

Thanks, It worked.