Displaying Value in a Cross Tab if it's Null

[Reghita]

Hi All

does anyone know how can i able to print a value in a cross tab if the currentfield value is null

For example

i want the value 10 to be display if the currentfield value is null. does anyone know how this can be done?

Thanks

 

[lbass]

For your summary field, use:

if isnull({table.field}) then 10 else {table.field}

-LB