Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Subhead Positioning
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Subhead Positioning
 Login/Join
 
Silver Member
posted
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
 
Posts: 39 | Registered: September 03, 2010Reply With QuoteReport This Post
Master
posted Hide Post
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

 
Posts: 542 | Location: Dearborn, MI | Registered: June 03, 2009Reply With QuoteReport This Post
Silver Member
posted Hide Post
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
 
Posts: 39 | Registered: September 03, 2010Reply With QuoteReport This Post
Silver Member
posted Hide Post
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
 
Posts: 39 | Registered: September 03, 2010Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Subhead Positioning

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.