Doug, Below is a snippet of code that I use to load a temporary table with size/width data. It converts record information into a columnar format. You may be able to use a variation of this technique to obtain the results you are looking for. Output the data via crosstab as a TXT file. LOAD a temporary table with the results of the crosstab. Strip the totals and headers as necessary. Use the temporary table as the basis for sections of your report.
DROP TABLE asq_grid CREATE TEMPORARY TABLE asq_grid + h1 TEXT 8,H2 TEXT 4,S1 TEXT 8,S2 TEXT 8,S3 TEXT 4,S4 TEXT 4,S5 TEXT 4,S6 + TEXT 4,S7 TEXT 4,S8 TEXT 4,S9 TEXT 4,S10 TEXT 4,S11 TEXT 4,S12 TEXT 4,S13 + TEXT 4,S14 TEXT 4,S15 TEXT 4,S16 TEXT 4,S17 TEXT 4,S18 TEXT 4,S19 TEXT 4, + S20 TEXT 4,S21 TEXT 4,S22 TEXT 4,MFG_STYLE TEXT 12 OUTPUT shoe_grid.dat CROSSTAB SUM auth_qty FOR mfg_size BY mfg_width FROM upc_master + WHERE mfgcode = .vMFG AND mfg_style = .vMFG_STYLE OUTPUT SCREEN LOAD asq_grid FROM shoe_grid.dat AS ASCII DROP COL h2 FROM asq_grid DELETE ROW FROM asq_grid WHERE COUNT = LAST --Strips totals DELETE ROW FROM asq_grid WHERE COUNT = LAST --Strips totals John -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Doug Hamilton Sent: Wednesday, February 23, 2011 11:37 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Data Rows to printed columns I need to make a report in which rows of data print as one line of columns near the top of the 8.5 x 11 page. Below the single row of rows is a grid where test results are written. Additional rows of data would print on subsequent pages. I've taken a stab at using a thin cross tab - not much luck I tried creating a custom label with five columns - seems to be ok, I got it to print only one row of "labels" but am fiddling around with File|Page Setup|Layout trying to get the row spacing adjusted so the grid is right under the row of data. Header, detail and page footer bands are Static height. Any other ideas - FTE article, previous emails, subreport... I seem to remember this coming before but can't find anything TIA Doug ________ Header info ________ Row 1 | Row 2 | Row 3 | Row 4 | Row 5 | _________|_______|_______|_______|_______| _________|_______|_______|_______|_______| _________|_______|_______|_______|_______| _________|_______|_______|_______|_______| . . . end of page next page: ________ Header info ________ Row 6 | Row 7 | Row 8 | Row 9 | Row 10| _________|_______|_______|_______|_______| _________|_______|_______|_______|_______| _________|_______|_______|_______|_______| _________|_______|_______|_______|_______| . . . end of page
