Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
1 reply Latest Post - ‏2013-01-09T14:28:03Z by SystemAdmin
SystemAdmin
SystemAdmin
15496 Posts
ACCEPTED ANSWER

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
    ACCEPTED ANSWER

    Re: Unwanted rows appear when exported to excel 2007.

    ‏2013-01-09T14:28:03Z  in response to SystemAdmin
    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.