Karen
It would be wrong of me
to say I have foolprofmethod for this! I can olnly conwey what I do.
For PDF I am very happy with printing to PDF
For Excel I instead
prepare a semiperment table that I can import from Excel with ODBC.
With semipermenant I mean
a table that is saved with the db (unlike a temp table) but deleted and
recreated next time I need to export to Excel.
I guess you equally could
call a semitemptable. Be aware thoug this is only a concept for a small number
of users where the liklyhood of interference between users are very low
-----Ursprungligt meddelande-----
Fr�n: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] F�r [EMAIL PROTECTED]
Skickat: den 4 augusti 2004 19:00
Till: RBG7-L Mailing List
�mne: [RBG7-L] - Printing to a
spreadsheet
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
