Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Crystal Reports XI R2 export excel problem

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
Former Member replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question