ReportBuilder exporting to Excel problem?

rbuser

(Posted on behalf of a colleague temporarily with usenet access)

Dear sirs,
I am currently experiencing a problem with ReportBuilder not
exporting to Excel properly. I am finding that certain fields are being
swapped around seemingly at random. It seems to be caused by the length
of the data, however while some fields with a certain length will be
swapped, others [in the same column] with the same length will not.

I have tried setting the save length for all fields to be 12, I have
ordered the fields in the 'print to file setup' and specified that it
is exporting to a fixed length text file. To export the file I am using
the ExportToFile function (from txUtils) using the syntax
"ExportToFile(Report,edfXLS,FileName)"

The report is fairly large with 3 groups, 65 columns and 200 rows.
Although the report is driven by a query, the data is calculated by
Delphi at runtime and written to the TppVariables in the report on the
BandBeforeGenerate event.

Any information or suggestions would be very much appreciated.


Richard Pearson
Software Developer
Dollar Finance UK Limited
+(44) 115 934-7477 ext(475)

rbuser

For dense reports like this you can control the size of the column calculation
with the ColSpacing property. Try setting this to a lower value 8000 (in thousandths of mm)
or -1 to disbale all spacing logic.

James Waler
Waler Ltd
http://www.waler.com

rbuser

Many thanks, James - I have passed that on to Richard.