export to xls multi pages in one detail

edited May 2011 in Devices
?Dear,

When i have a header and a detail. The detail page make 4 pages.
When i want to print it, I have the header on each page. That's correct.
But when i export this to xls. I want to have the header one time on the
top of the xls sheet and not 4 times for every page.
How can i to this. Or must i set a property.

Thanks



--- posted by geoForum on http://www.newswhat.com

Comments

  • edited May 2011
    You don't specify whether you are exporting to XLSReport or XLSData. From
    the context of the question, I am guessing XLSData. You might try
    implementing the Header BeforePrint event to conditionally set the
    HeaderBand.Save boolean.

    Example:

    uses
    ppReport;


    Report.Header.Save := (Report.AbsolutePageNo = 1);


    -
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited May 2011
    That is a good solution for XLSReport. (my suggestion would only work for
    XLSData export).

    -
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited May 2011
    I'm using XLSReport.
    It doesn't work.
    delphi 2010, Reportbuilder 12.04 build 77

    I change my code to choice for an export or a print.
    if the devicetype = xlsreport then i set the report.header.visible=
    (report.absolutepageno=1)



    --- posted by geoForum on http://www.newswhat.com
This discussion has been closed.