RE: [sqr-users] Continous line - no wrap

["SCHATTLING, Paul" <Paul.SCHATTLING@suncorp.com.au>]

I did try to use the write command but i need to write data to the file for
the same line, however getting the data from different sqr select statments
so the data is being written to the file at different times but for the same
line.
Do I need to store the information into a variable until i am ready to print
the whole line? And to give a break between lines do i just create an empty
variable to write between lines?

> -----Original Message-----
> From: don.barclay@srs.gov [SMTP:don.barclay@srs.gov]
> Sent: Tuesday, March 18, 2003 9:21 AM
> To:   sqr-users@sqrug.org
> Subject:      Re: [sqr-users] Continous line - no wrap
> 
> Paul,
> Forget the PRINT command -- WRITE is definitely the way to go.  See if you
> 
> can find another SQR that uses the write command and borrow code from it. 
> The main trick to using WRITE is to open the file for writing, and 
> establishing a location where the file will be created (in a windows 
> directory, Unix server, etc.).
> 
> Once you get past that hurdle, you can create files that stretch out to 
> the right as far as you need to go.  My preference is to create a file 
> with an extension of .xls so EXCEL will automatically open it.  I prefer 
> tab delimited files, so I encode the ASCII character for tab into a 
> variable called $tab, and then create a variable (here called $PrintLine) 
> where I string together all of my variables separated by the tab.  See my 
> code sample below.
> 
> This has worked out great for us.
> 
> Don Barclay
> Westinghouse Savannah River Co.
> Aiken, SC
> 
> encode '<9>' into $Tab
> 
> STRING $EXCEL-EMPLID
>        $STATE
>        $EXCEL-PAYGROUP
>        $BENEFIT_PLAN
>        $DEDCD
>        #P99-DED_YTD
>        #DED_YTD
>        #FINAL-DED_YTD
>        #Z-BALANCE_PERIOD
>        #D-TXGRS_YTD
>        #D-FINAL-TXGRS_YTD
>        #D-BALANCE_PERIOD
>        #E-TXGRS_YTD
>        #E-FINAL-TXGRS_YTD
>        #E-BALANCE_PERIOD
>        #F-TXGRS_YTD
>        #F-FINAL-TXGRS_YTD
>        #F-BALANCE_PERIOD
>        #H-TXGRS_YTD
>        #H-FINAL-TXGRS_YTD
>        #H-BALANCE_PERIOD
>        #Q-TXGRS_YTD
>        #Q-FINAL-TXGRS_YTD
>        #Q-BALANCE_PERIOD
>        #STATE-TXGRS_YTD
>        #STATE-FINAL-TXGRS_YTD
>        #Z1-BALANCE_PERIOD
>        #P99-FED-TXGRS-OLD
>        #P99-FED-TXGRS-NEW
>        #FF-BALANCE_PERIOD
>        #P99-STATE-TXGRS-OLD
>        #P99-STATE-TXGRS-NEW
>        #SS-BALANCE_PERIOD
> BY     $Tab
> INTO   $PrintLine
> 
> WRITE 10 from $PrintLine
> 
> 
> 
> 
> 
> "SCHATTLING, Paul" <Paul.SCHATTLING@suncorp.com.au>
> Sent by: sqr-users-admin@sqrug.org
> 
> 
> 03/17/2003 06:07 PM
> Please respond to sqr-users
> 
>  
>         To:     "'sqr-users@sqrug.org'" <sqr-users@sqrug.org>
>         cc: 
>         Subject:        [sqr-users] Continous line - no wrap
> 
> 
> Don't know if this is possible or not. I am writing an sqr which will 
> create
> a csv file which to be opened in excel (only).
> However, the number of columns is dynamic (based on the number of periods
> select for reporting). I am having a problem because my line is wrapping 
> to
> the next line and as you are probably aware, I would not require this
> wrapping functionality given that I want to open it in excel.
> 
> That is what is happening with 'print' commands. I tried making the setup 
> of
> the page to landscape and made the page width bigger but to no avail.
> I also tried playing with the 'write' commands but am no expert in that
> area.
> 
> Any help would be appreciated.
> 
> 
> 
> 
> --------------------------------------------------------------------------
> ---------
> 
> The contents of this message are the views of the Author and do not 
> necessarily reflect the views of SUNCORP METWAY LTD  ABN 66 010 831 722. 
> 
> The content of this e-mail, including attachments is a confidential 
> communication between the Suncorp Metway Group and the intended addressee.
> 
> Any unauthorised use of the contents is expressly prohibited. If you have 
> received this e-mail in error please contact the sender immediately and 
> then delete the message and any attachment(s).
> 
> http://www.suncorp.com.au
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
> 
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users