Filling up empty feilds in cross tab

[raj0927]

Hi,
My cross tabs looks like below
col1 col2 col3
row1 2 8
row2 1 6
row3 3 3 2
Is there any way to fill these empty spaces with values like '-' or '0'. I am using crystal report 2008.

 

[lbass]

Please identify the datatype of the summary field and the type of summary you are using.

-LB

 

[swiss2007]

Go to

File --------> Report Options --------> Check Convert database null values to default and also Convert other null values to default

 

[Madawc]

As swiss2007 says, you can convert null values to zeros, but then you lose information, null can mean 'unknown; while 0 means 'definitely zero.

An alternative for use in a crosstab is to write a formula field, something like

if isnull({your.amount})  
then 0 
else {your.amount}

First check your crosstab settings, one option is to show zeros as blank. It's posible you have that set.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[raj0927]

Thank you