export to xls multi pages in one detail

rbuser

?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

nardmoseley

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

nardmoseley

That is a good solution for XLSReport. (my suggestion would only work for
XLSData export).

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

rbuser

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