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.
Pinned topic Unwanted rows appear when exported to excel 2007.
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-01-09T14:28:03Z at 2013-01-09T14:28:03Z by SystemAdmin
SystemAdmin 110000D4XK15496 Posts
Re: Unwanted rows appear when exported to excel 2007.2013-01-09T14:28:03ZThis is the accepted answer. This is the accepted answer.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.