Home Devices
New Blog Posts: Merging Reports - Part 1 and Part 2

Exporting to XLS and Blank Rows

edited January 2014 in Devices
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.

Comments

  • edited January 2014
    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

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited February 2014
    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
  • edited February 2014

    I'll add this to the requested feature list.

    Thanks for the feedback,

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

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.