Please Help, I need a report in the following format:
CAR-------Specifications JAGUAR---Seats:2 ----------Model:V12XKE ----------Body:AUTO CONVERTIBLE JAGUAR---Seats:5 ----------Model:XJ12L ----------Body:AUTO SEDAN MASERATI-Seats:2 -----------ModelORA -----------Body:2 DOOR COUPE
The dashes are just to show the alignment. There are just two columns and the value of Seats and Model and Body are under the column titled as Specifications.
Please any ideas/solutions will be appreciated.
Thanks,
Vipul
April 26, 2004, 07:57 PM
Mikel
For example, using OVER phrase:
TABLE FILE CAR HEADING "CAR<+0>Specifications" " " PRINT CAR AS '' COMPUTE TXT1/A40 = 'Model: ' ; AS '' MODEL AS '' OVER COMPUTE FILLER1/A1 = ' '; AS '' COMPUTE TXT2/A40 = 'Body: ' ; AS '' BODY AS '' OVER COMPUTE FILLER2/A1 = ' '; AS '' COMPUTE TXT3/A40 = 'Seats: ' ; AS '' SEATS AS '' OVER COMPUTE HR/A4 = ' ' ; AS '' BY CAR NOPRINT PAGE-BREAK BY MODEL NOPRINT BY BODY NOPRINT ON TABLE SET PAGE NOLEAD ON TABLE SET STYLE * TYPE=REPORT, GRID=OFF, $ TYPE=HEADING, HEADALIGN=BODY, $ TYPE=HEADING, LINE=1, BACKCOLOR=SILVER, $ TYPE=HEADING, LINE=1, ITEM=2, COLSPAN=2, $ TYPE=DATA, COLUMN=SEAT, JUSTIFY=LEFT, $ END Regards, MikelThis message has been edited. Last edited by: <Mabel>,