Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Sep 24, 2008 at 07:24 PM

    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

    Add comment
    10|10000 characters needed characters exceeded