can we show 0 in the report for a dimension object..!!

building reports webintelligence
1

Hi,
can we show 0 in the report for a dimension object which has no value in the database?

We have sectioning on the [category_desc],
Formula: =If ([category_desc] =“A”;“Excelent”;If (category_desc] =“B”;“good”);"") )

It may happen that [category_desc] has no value [=“A”] in the database.

kind regards,
Pratik.

pratik_m :india: (BOB member since 2008-07-10)

2

How about using Alerters on report level? You can code it according to your logic; setting values (like ‘0’) for columns which has NULL/Empty values in database.

Rajat Sapru :us: (BOB member since 2008-08-28)