Exporting to XLS and Blank Rows

rbuser

Hi,

I am exporting a report to XLS with the report header and footer
hidden. However I am finding that the resulting XLS seems to have a
number of blank rows where the report header and footers would be if
they were visible.

How can I suppress these blank rows so they don't appear in the XLS?

David.

nardmoseley

David,

ReportBuilder has two XLS export devices: XLSReport and XLSData.

XLSReport exports report pages - it tries to duplicate what you would see
when generating to preview/print/pdf. For RB 15 we added an
XLSSettings.IgnorePageHeight boolean that can be used to prevent blank rows
from being added to represent the bottom of the page.

XLSData export the data to column/row format - it does not consider element
position on the page. By default only detail band elements are exported. To
override the default, use the DefaultBands property to specify which bands
to export or or use the Print To File Setup dialog to define which elements
to export. For RB 15 we added you XLSSettings.IncludeSingleHeader and
IncludeSingleFooter booleans that can be used to export the header/footer
only a single time.

For more details check out the the RBuilder help topics for
TppXLSReportDevice, TppXLSDataDevice, TppXLSSettings.



Best regards,

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

rbuser

Em 29/01/2014 14:43, Nard Moseley (Digital Metaphors) escreveu:


It would be nice if such parameter worked for XLSReport too.

Any chances?

Carlos

nardmoseley

I'll add this to the requested feature list.

Thanks for the feedback,

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