Crystal Reports XI R2 export excel problem

[Former Member]

I would like to know how to handling null database fields when exporting to excel.

It seems the exporting process remove all the null field and shift all other database field to left.

thanks

[Former Member · Accepted solution]

Hi Geoffrey,

Use field formulas to create blank spaces whenever empty string (or null) text values are possible.

Example:

if isnull({Q.SAMPLETYPE}) or {Q.SAMPLETYPE} = '' then space(12)

else

{Q.SAMPLETYPE}

Rick