Some exporting to Excel queries

rbuser

Hi Guys

We use Delphi XE5 with RB 15.03

We have a report containing 5 sub reports, each sub report containing
the same column layout and field names but from different datasources.

Work well on screen but we need to export to Excel so the client can
perform more data manipulation.

When we opt to export to a 'XLS Report File' its ok but column cells are
merged and we do not want this. Also where the report is long there are
additional blank rows of different sizes that we don't want (I dont know
maybe page breaks?)

When we export to 'XLS Data File' which we believe is just raw data, the
report is empty when we know that data should be there (and is there in
the print preview). Can we not use this export type with sub-reports?

Would an update to a later version of RB help us here?

Thanks

Glenn Greatwood
Key-Data Systems

nardmoseley

Hi Glen,

'XLS Report File' exports report pages. In other words it emulates what you
see in the preview/print. A spreadsheet is a limited format, element
positions are mapped to the nearest column. For best results, set Label,
DBText AutoSize to False and size the width. For header/detail items, use
the same width and text alignment. To prevent blank rows from being added to
the bottom of the page, set XLSSettings.IgnorePageHeight to True.

For 'XLS Data File', use the File | Print To File Setup dialog to configure
which elements to export. For subreports,
access the workspace for each child report and select File | Print To File
Setup.

RB 16 adds new 'Xlsx Report File' and Xlsx DataFile' export to xlsx format.

RB 16 includes the following enhancements for XLS/Xlsx

- XLS/Xlsx, improved accuracy of right aligned text
- XLS/Xlsx, added XLSSettings.DefaultBands property for XLSData
- XLSData, added XLSSettings.PreserveLineBreaks property for XLSData
- XLS/Xlsx, add support for display formats with non quoted chars
- XLSReport, added support for IncludeSingleHeader, IncludeSingleFooter
- XLSData, export RichText, Checkbox as plain text

Here is a link to the RB 16 feature list

http://www.digital-metaphors.com/rbWiki/General/What's_New/RB_16



Best regards,

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