Well, I sure learned something. Didn't know you could print a report to an excel file. Looked up SELMARGIN and it says: ===== Use SELMARGIN to set the left margin for displaying the results of a SELECT command. The default for SELMARGIN is 0 (zero), which sets the margin to column 2. Use SELMARGIN when an ASCII file requires a predefined position or when data has a required starting point.
Note: Setting SELMARGIN to 0 (zero) or 2 begins the left margin at column two. ===== so, I guess it won't work with a PRINT command. How do your users look at the printed report? ~Claudine :) -----Original Message----- From: [EMAIL PROTECTED] [mailto:owner-rbase-l@;sonetmail.com] On Behalf Of Farnsworth Midge D Contr 388 RANS/JT3 Sent: Monday, October 21, 2002 3:13 PM To: '[EMAIL PROTECTED]' Subject: RE: Selmargin If I use GATEWAY, then only one user can be logged into the database. I have 11 different users at one time. -----Original Message----- From: Walker, Buddy [mailto:buddy@;medschool.pitt.edu] Sent: Monday, 21 October, 2002 13:51 To: [EMAIL PROTECTED] Subject: RE: Selmargin If you are using R:Base 6.5++ then I would suggest you use GATEWAY EXPORT XLS4 northfin.xls SEL columns FROM tablename WHE ... ORDER BY ..... Buddy -----Original Message----- From: Farnsworth Midge D Contr 388 RANS/JT3 [mailto:Midge.Farnsworth@;HILL.af.mil] Sent: Monday, October 21, 2002 3:24 PM To: [EMAIL PROTECTED] Subject: Selmargin I am trying to print a report to an Excel file. I have tried to reset the left margin to 1 without any luck. I tried SET SELMARGIN 1 and it didn't do anything. OUTPUT NORTHFIN.XLS SET SELMARGIN 1 PRINT EMNOR WHERE fldate >= .sdate AND fldate <= .edate + ORDER BY fldate, zstart, zstop, flline OUTPUT NORTHFIN.SCH SET SELMARGIN 1 PRINT EMNOR WHERE fldate >= .sdate AND fldate <= .edate + ORDER BY fldate, zstart, zstop, flline What am I doing wrong? ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
