insert zeros(0) in maxtrix report

[arshadjamil]

Dear All,


how can i insert zeros(0) in palce of null in a column
of a matrix report .


Arshad Jamil

[LKBrwn_DBA]

You could use the NVL() function.

[arshadjamil]

Dear LKBrwn,

I have take these steps
Frist i set property to 0 if values is null of fields.
Second I take placeholder and move field in this placeholder as
placeholder_xyz := nvl(my_field_name,0)
even i set placeholder property to 0 if values is null.

but i did not get my desire result .


Arshad Jameel
Pakistan

[LKBrwn_DBA]

Try to find a 'format mask' property and set to something similar to 999,990
(Notice the trailing ZERO.)