Bad CSV layout from SQR

I found that some CSVs had layout problems where the file being produced contained unwanted line breaks. This of course mucked up the layout when the CSV was viewed in Excel or whatever.

I added the following to the top of the SQR:

begin-setup
page-size 79 600
end-setup

The page-size command sets the number of rows and columns, respectively (rows weren't an issue).

Edit: In latest version of SQR use the following:

   Declare-Layout my-layout
     paper-size=(a4)       
     orientation=landscape
     MAX-COLUMNS=600
   End-Declare
                                
   Declare-Report THIS_REPORT
      Printer-Type=POSTSCRIPT
      LayOut=my-layout
   End-Declare    


0 comments: