Alignment when exporting to excel

rbuser

I have some questions on how to export a report to excel. The report has a
mixed heading of horizontal and vertical labels (Angle = 90 degrees), and
beneeth the heading I display a vertical line. And for the data I use the
"BlankWhenZero"-property.

The difficulties with the heading is that on exporting to Excel, I haven't
been able to get the labels on the same row. Also the length of the
underlying line is too short no matter what I try. Further, the vertical
alignment of the labels differ (Excel aligns the rotated text at the top)

The problem with the data is that using the "BlankWhenZero", the position of
last column isn't correct. (It gets positioned one to the left) Which is
strange, since the group below that displays the sum of the data gets
positioned just right. (Try to move the DBText-controls several pixels, but
that doens't mak a difference for the Excel-export, but does have an
undesired effect on the normal print)

Could you give me some advise on this please...

nardmoseley

Please create a simple example that we can build and run here. Use standard
Delphi components and RB. Use the DBDemos data or dump some data to
TClientDataSet(s). Send in zip format to support@ and we can check it out
here.


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