Page Header Excel Export Error

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

  • Posted 4 August 2017, 2:34 pm EST

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


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

  • Replied 4 August 2017, 2:34 pm EST

    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
    Else
        PageHeader.Visible = true
    End If
  • 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.

    Thanks.
  • 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