RE: [sqr-users] Double lined Headings in CSV

[Bob Stone <bstone@fastenal.com>]

When I have created CSV files I will make 2 lines of header, and longer
headings take up 2 rows (audits passed) whereas shorter headings I just
print on the 2nd row (single).  It looks quite allright.  You just have to
remember that whenever you're printing out the header rows you need to set
the rowcounter +2.  

Example:
                Part Cnt                                        Audits
Normal  (normal)        Single  Audit           Passed
(datarow1)      10              6               5               5       

If that solution is what you want, perhaps you could try changing the row
height and setting the 'wrap-around' feature in Excel.  I dont know if those
are features that CSV's accept, but you can easily find out.  Save one CSV
copy with the normal header line in there, and save another with the height
changed and wrap around set for those cells.  If you see a reproducable
difference between the 2 files, then you can use that to set height and wrap
around in your SQR for those cells.


-----Original Message-----
From: sqr-users-bounces+bstone=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org]On Behalf Of
Bruce Burnell
Sent: Monday, January 31, 2005 1:37 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] Double lined Headings in CSV


We have an SQR that produces a .csv file.  We are doing this using the
'write' rather than 'print' verbs.  I recognize that is a point of debate
in itself, but we have found that for some extracts, it is much cleaner.
Now some of the column headings are long headings for short fields.  We
would like to stack them, but within the same cell.  Is there a character
we can insert that would cause a line break within a cell?  Some that would
be equivalent to when you press Alt-Enter in a spreadsheet cell?

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