[RBG7-L] - Re: Printing to a spreadsheet

[David M. Blocker]

RBTI is aware that this is an issue. For the time being the work around I've used is the GATEWAY command - you don't get the nice formatting but no blank columns etc.   David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: [EMAIL PROTECTED] To: RBG7-L Mailing List Sent: Wednesday, August 04, 2004 12:59 PM Subject: [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