Focal Point
[SOLVED] Subhead Positioning

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

October 15, 2010, 12:27 PM
swetha
[SOLVED] Subhead Positioning
Hello,

I am working with SUBHEAD.My code is

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




WebFOCUS 8.1.05
Windows
http://ibiwebfocus.wordpress.com
https://www.facebook.com/groups/ibi.webfocus/
October 17, 2010, 12:43 AM
swetha
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.


WebFOCUS 7.6.7
windows
Html,Pdf and Excel