XLS Settings

rbuser

XLSData - I have numerous reports that I would like the detail band
exported to an XLS file. Is there a global setting for this or do I need
to set the band.save properties for each report?

XLSReport - How do you include the formulas instead of just the numeric
result in the output?

Is the a built-in end user dialog that user could set their own options
for the XLS exports?


Thanks - Jon Gray RB 12.01 Build 197

nardmoseley

> XLSData - I have numerous reports that I would like the detail band

Check out the RBuilder help topic for TppXLSDataDevice for details on which
elements are exported. By default all detail band text elements are
exported.


Cell attributes are exported for DataType, Value, and DisplayFormat. There
is no support for formula.


If the end-user is editing the report, the report designer's object
inspector can be used to configure the Report.XLSSettings. There is no
built-in dialog.


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

rbuser

>>
Check out the RBuilder help topic for TppXLSDataDevice for details on
which elements are exported. By default all detail band text elements
are exported.
<<

My XLSData export isn't defaulting to the detail band being exported.
The spreadsheet is created but there isn't anything in it. The
XLSReport is working as expected. I don't have anything set in report
band export properties and I tried a new, simple report and got the same
results.

Is the XLSDataDevice.DefaultBands exposed to a rsClientReport? I can't
seem to gain access to it to set the properties myself from the client
application.

Jon Gray

nardmoseley

I researched this, there is an issue when generating from TrsClientReport. A
fix will be included for RB 12.02.

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