I want to print a report to an Excel spreadsheet so I can do some
moving around of the data. The report has 10 DBLabels in the Detail
band, all placed in a single column right below the one above it.
What I'm hoping for is an excel spreadsheet with 10 rows per data
item, with a blank space before the next record. I can't get it. Here's
the combinations I tried and the results I get:
Detail band: Dynamic
Looks okay on screen, with a small space between each record
regardless of how much white space I have in the report below the
last located DBLabel.
In the "formatting" tab when I go to print the excel spreadsheet:
Line Spacing: Actual: Get random blank lines between some of
the 10 rows per record, and no blank row between records.
Line Spacing: No blank: there are no blank rows at all, between
records or the DBTexts.
Detail band: Static
Line Spacing: Actual: I get a blank row (or 2) between the records,
which is good, but still random blank rows between the 10
rows per record.
Anyone have a "fool proof" way of getting this to print better?
Karen
