export excel format

rbuser

Hi,

i have d2007 application with Report Builder 12.04,

In footer band i have many shape that have into label and dbtext object.

when i export report with xls format file the footer band create shape
object, and under there are cell with label caption and dbtext value

There is some settings to create shape and parent object in rights mode
( first shape and after label caption and dbtext value ) ??


I send you example of invoice in pdf format and xls_report file


Best regards
Paolo Angeretti

nardmoseley

This behavior is documented in the RBuilder topic for TppXLSReportDevice.
Labels and DBText are exported to cells, with the dataype, format, and value
being cell attributes. Graphical objects such as Shapes cannot appear below
cells - that is a limitation of XLS.

One option is to use the Report.XLSSettings to ommit the shapes from the XLS
export. Another option is to Or conditionally set the Shape.Brush.Style to
bsClear when exporting to XLS.



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

rbuser

Thank you very much.

I set Shape.Brush.Style to bsClear before print and when I exporting
report to XLS now shape is background and label and text are in foreground.

I would to ask why some text are exported outside of the shape parent

I attached invoice example in excel and pdf format

best regards
Paolo Angeretti

rbuser

You can download invoice xls from
http:\\www.elaborasvilupposoftware.it\download\invoice_export.zip

Paolo Angeretti