SSRS 2005 Export to Excel without redundent white space

Hi

Is it possible to export reports to excel without all the redundant columns

I have tried the deviceInfo settings in the url and config file

/Reports/Pages/Report.aspx ItemPath=ReportServerProject1/Report1&rc: RemoveSpace=0.5in

and

<Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering">
<Configuration>
<DeviceInfo>
<RemoveSpace>0.5in</RemoveSpace>
</DeviceInfo>
</Configuration>
</Extension>

So far the only thing making a difference in the amount of columns exported is aligning all the textboxes outside a table to start and end at column boundries of the table

Any ideas

Thanks



Answer this question

SSRS 2005 Export to Excel without redundent white space

  • SSRS 2005 Export to Excel without redundent white space