Results 1 to 4 of 4

Thread: XLS-export header is always repeated per printed page

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Nov 2011
    Location
    Germany Hamburg
    Posts
    140

    Default XLS-export header is always repeated per printed page

    Hallo,

    I create a xls file with DRW. The header is always repeated per printed page.

    I set the parameters as follows:

    Move C_drXLS2007 to myExportOptions.iXLSVersion
    Move C_drNoSheets to myExportOptions.iNewSheet
    Move 50 to myExportOptions.iColumnWidth
    Move True to myExportOptions.bExportDataOnly
    Move True to myExportOptions.bExportPageSections
    Move False to myExportOptions.bExportReportSections
    Move False to myExportOptions.bExportGroupSections
    Move True to myExportOptions.bAllPages
    Move 1 to myExportOptions.iPage

    Click image for larger version. 

Name:	ExcelPage.JPG 
Views:	47 
Size:	114.7 KB 
ID:	12954

    what's wrong ?

    Ralf

  2. #2
    Join Date
    Feb 2009
    Location
    Hengelo, Netherlands
    Posts
    9,097

    Default Re: XLS-export header is always repeated per printed page

    Ralf,

    It makes sense to me as you have bExportPageSections set to true and I assume your header is one of them.
    Regards,
    Data Access Worldwide
    Vincent Oorsprong

  3. #3
    Join Date
    Nov 2011
    Location
    Germany Hamburg
    Posts
    140

    Default Re: XLS-export header is always repeated per printed page

    Hi Vincent,

    But then there is no more header

    Ralf

  4. #4
    Join Date
    Feb 2009
    Location
    Hengelo, Netherlands
    Posts
    9,097

    Default Re: XLS-export header is always repeated per printed page

    Ralf,

    Place the column header objects in the report header section and set the bExportReportSections member to true instead.

    I can imagine that you don't want this in a normal preview or print and you could make a suppress function based on a parameter set from integration code. Suppress when exporting and not when printing/previewing.
    Regards,
    Data Access Worldwide
    Vincent Oorsprong

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •