COUNTRY BODYTYPE SEATS DEALER_COST RETAIL_COST SALES
ENGLAND CONVERTIBLE 2 7,427 8,878 0
ENGLAND SEDAN 5 11,194 13,491 12000
ENGLAND SEDAN 4 14,940 17,850 0
ENGLAND HARDTOP 2 4,292 5,100 0
JAPAN SEDAN 4 2,626 3,139 43000
JAPAN SEDAN 4 2,886 3,339 35030
ITALY SEDAN 4 4,915 5,925 4800
ITALY COUPE 2 5,660 6,820 12400
ITALY ROADSTER 2 5,660 6,820 13000
pls how do i accomplish thisThis message has been edited. Last edited by: joyesiji,
WebFOCUS 7.6.9 Windows all output (Excel, HTML, PDF)
April 10, 2012, 12:04 PM
susannah
BY COUNTRY NOPRINT ON COUNTRY SUBHEAD "CAR:ON COUNTRY SUBFOOT "Country:
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
April 10, 2012, 05:51 PM
Waz
joyesiji, if you put your output samples in the code tags, then the format will be kept.
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
April 10, 2012, 06:08 PM
joyesiji
Thanks for the hint
WebFOCUS 7.6.9 Windows all output (Excel, HTML, PDF)
April 11, 2012, 07:56 AM
Danny-SRL
joyesiji,
Using your output example for "England", I understand that you want to have "CAR:England" appear over the TITLES. This can only be done if you put "CAR:England" in the HEADING but then you will have to use PAGE-BREAK on COUNTRY. Is that what you want? Leaving our styling:
TABLE FILE CAR
HEADING
"CAR:<COUNTRY "
PRINT BODYTYPE SEATS DEALER_COST RETAIL_COST SALES
BY COUNTRY NOPRINT
ON COUNTRY PAGE-BREAK
FOOTING
"Country:<COUNTRY "
ON TABLE SET PAGE OFF
END
However, if you do not want a PAGE-BREAK, then you can use the following:
TABLE FILE CAR
PRINT
BODYTYPE AS ''
SEATS AS ''
DEALER_COST AS ''
RETAIL_COST AS ''
SALES AS ''
BY COUNTRY NOPRINT
ON COUNTRY SUBHEAD
"CAR:<COUNTRY "
"BODYTYPE<+0>SEATS<+0>DEALER_COST<+0>RETAIL_COST<+0>SALES"
ON COUNTRY SUBFOOT
"Country:<COUNTRY "
ON TABLE SET PAGE OFF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE=ENDEFLT,
$
TYPE=SUBHEAD, HEADALIGN=BODY, $
TYPE=SUBHEAD, ITEM=2, JUSTIFY=RIGHT, border-top=heavy, $
ENDSTYLE
END
Notice the use of null TITLES. Instead they are inserted in the SUBHEAD.
Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF