Topic
  • 1 reply
  • Latest Post - ‏2013-01-09T14:28:03Z by SystemAdmin
SystemAdmin
SystemAdmin
15496 Posts

Pinned topic Unwanted rows appear when exported to excel 2007.

‏2013-01-08T21:02:07Z |
Hi,

I have a list report in which 2 columns have couple of HTML item added and also have drill thought on those 2 columns.
Report Runs fine on demand in all formats PDF,HTML,EXCEL.
But when the report is Run With Options and Format type is EXCEL 2007 and send a email or saved it added extra blank rows to that report

I have set the Parameters RSVP.EXCEL.XLS2007_ALLOW_WRAPPING_SINGLE_CELL on the batchreportservice and reportservice to TRUE and also on the dispatchers. This seems to resolve in version 8.4 but not on version 10.1.

I need it in version 10.1

Hope i'm clear enough if not just let me know.

Thanks in advance for your help.
Updated on 2013-01-09T14:28:03Z at 2013-01-09T14:28:03Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    15496 Posts

    Re: Unwanted rows appear when exported to excel 2007.

    ‏2013-01-09T14:28:03Z  
    Hi,

    I got the solution. This is what i did use conditional formatting on the report output is excel then box type to none else Report output.

    Thanks.