TABLE FILE CAR HEADING CENTER "CAR TEST" " " " " PRINT SEATS AS 'SEATS' DEALER_COST AS 'Dealer,Cost' RETAIL_COST AS 'Retail,Cost' BY COUNTRY NOPRINT BY CAR NOPRINT ON COUNTRY SUBHEAD "ON CAR SUBHEAD "<.CAR" ON COUNTRY SUBTOTAL DEALER_COST RETAIL_COST AS '' ON TABLE SET PAGE-NUM OFF ON TABLE SET STYLE * TYPE=REPORT,GRID=OFF,$ END
The output I get is
CAR TEST
SEATS DealerCost RetailCost ENGLAND JAGUAR
2 7,427 8,878 5 11,194 13,491 JENSEN
4 14,940 17,850 TRIUMPH
2 4,292 5,100
ENGLAND 37,853 45,319
FRANCE PEUGEOT
5 4,631 5,610
FRANCE 4,631 5,610
My requirement is I want the columns Seats Dealercost and Retailcost to be moved to the right. I want my subheading moved up. Can somebody help regarding this. Thanks.This message has been edited. Last edited by: Kerry,
WebFOCUS 7.6.7 windows Html,Pdf and Excel
October 15, 2010, 01:11 PM
Ram Prasad E
HTML? PDF? or which format?
For HTML output this works fine.
TABLE FILE CAR
HEADING CENTER
"CAR TEST</2"
PRINT
COMPUTE BLANK_COL/A1=' '; AS ''
SEATS AS ''
DEALER_COST AS ''
RETAIL_COST AS ''
BY COUNTRY NOPRINT
BY CAR NOPRINT
ON COUNTRY SUBHEAD
"<COUNTRY"
ON CAR SUBHEAD
"<CAR"
" <+0>Sales<+0>Dealer Cost<+0>Retail Cost"
ON COUNTRY SUBTOTAL DEALER_COST RETAIL_COST AS ''
ON TABLE SET PAGE-NUM OFF
ON TABLE SET STYLE *
TYPE=REPORT,GRID=ON,$
TYPE=SUBHEAD, BY=COUNTRY, HEADALIGN=BODY, $
TYPE=SUBHEAD, BY=CAR, HEADALIGN=BODY, $
END
Thanks a lot.This is what I am looking for. Now in the output I have Country and Car as subhead.can I display both Country and Car side by side on the same line as Seats,Dealercost and Retailcost. This will help me a lot.
WebFOCUS 7.6.7 windows Html,Pdf and Excel
October 18, 2010, 01:27 PM
swetha
Hey Ramprasad,
your answer helped me a lot.I need one more help.Now I get the country and car in separate lines.what should I do to get both country and car on the same line as Seats,Dealercost and Retailcost. Thanks for your help.