Midge, The SELMARGIN command applies only to use of the SELECT command to control which column the results start in. Your example uses the PRINT command. To control the column your output starts at you will neet to adjust your REPORT definition. -- Jim Bentley American Celiac Society [EMAIL PROTECTED] - email (973) 325-8837 voice (973) 669-8808 Fax
-----Original Message----- From: Farnsworth Midge D Contr 388 RANS/JT3 <[EMAIL PROTECTED]> Sent: Mon, 21 Oct 2002 14:13:14 -0600 To: "'[EMAIL PROTECTED]'" <[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/
