Focal Point
Help on report formatting in a different way

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/3381077331

April 26, 2004, 06:19 PM
<Vipul>
Help on report formatting in a different way
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
-----------ModelBig GrinORA
-----------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,
Mikel

This message has been edited. Last edited by: <Mabel>,
April 26, 2004, 08:48 PM
<Vipul>
Thks Mikel,

It worked. Hurray.

Really appretiate your help.

Vipul