I created a report with multiple fields. I would like to create a generic formula in which it evaluates all the values and if it found a null or empty value it will be replaced by a 'N/A'. I was trying to use the following formula for one of the database value:

if isnull({PID_.CND7/T_EXPRESSION#EXPRESSION}) then "N/A" else {PID_.CND7/T_EXPRESSION#EXPRESSION} = {PID_.CND7/T_EXPRESSION#EXPRESSION}

but I had the error a string is required here.

thanks

for the formula posted I change the data to the same type and it works.

My concern is that I have approx. 140 fields which I would like to evaluate if there is a blank or Null value in order to replace it with a N/A.

If is possible to change all the variable to string an have a generic formula to evaluate all the fields?? I would like the following:

if {mydata}='NULL' then 'N/A'

else if {mydata} = "" then 'N/A'

else {mydata}

when I refer to mydata is approx 140 fields in the report.

thanks

I will create the general function, my only question is how I can change all the fields as string??

or

how can I assign a "N/A"to a boolean field??

Is there is a way to change the data type of the field.

ex change all booleans fields to string

??