Page Header Excel Export Error

Posted by: gosantoro on 4 August 2017, 2:34 pm EST

  • Posted 4 August 2017, 2:34 pm EST

    <font size="2"> Hi, I´m exporting a report to Excel but when i open the xls file repeates the page header after 40 rows.</font>
    <font size="1"> <font color="#808080">    Dim excelexport As New ActiveReportsExcelExport.ARExportExcel
       excelexport.FileName = TempDir + "\" + FileName
       excelexport.GenPagebreaks = False
       excelexport.TrimEmptySpace = True
       excelexport.export aRep.Pages</font>

    I need help because the excel file must have only one page header. What's wrong?</font>

  • Replied 4 August 2017, 2:34 pm EST

    <span id="_ctl0_MainContent_PostFlatView"> <span> The only way is to re-run the whole report without the page header section visible. Use a class property off the report object called Exporting. You can use the following code in the PageHeader_Format event:

    If Exporting = true then
        PageHeader.Visible = false
        PageHeader.Visible = true
    End If</span></span>
  • Replied 4 August 2017, 2:34 pm EST

    Ok, but I need that the header page appears just one time. My problem is that the page header is repeated each 40 rows and i dont know why.

  • Replied 4 August 2017, 2:34 pm EST

    Sounds like you want more of a Report Header as opposed to a Page Header.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels