Geek asks and answers

Problem with SSRS 2008 Export to Excel Page Number

I have several reports that users should export to Excel. I show the page number in the page footer in the text box with this expression: = "Page:" and Globals! PageNumber

When I test this in Visual Studio, Excel Excel export looks fine. Each page number is correct. When I expand the report and export it through the report manager, each page number is "Page: 1".

How to fix it?

+3
source share
2 answers

You must configure the device information settings to use simple headers:

rsreportserver.config. Mine C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer\

excel .

<Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering" Visible="False">
  <Configuration> 
    <DeviceInfo>
        <SimplePageHeaders>True</SimplePageHeaders> 
    </DeviceInfo> 
  </Configuration> 
</Extension>
0

. 2 . . excel .

0

More articles:


All Articles