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]:Help Formatting report
Go
New
Search
Notify
Tools
Reply
  
[SOLVED]:Help Formatting report
 Login/Join
 
Member
posted
Using the car file as example

  
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



i will want my report to look like

 
CAR:England
BODYTYPE		SEATS		DEALER_COST		RETAIL_COSTS	SALES
convertible		2		7427			8878		0
sedan			5		11,194			13,491		12000
sedan			4		14,940			17,850		0
hardtop			2		4,292			5,100		0

Country:England

CAR:Japan
BODYTYPE		SEATS		DEALER_COST		RETAIL_COSTS	SALES
sedan			4		2,626			3,139		43000
sedan			4		2,886			3,339		35030

Country:Japan


CAR:Italy
BODYTYPE		SEATS		DEALER_COST		RETAIL_COSTS	SALES
sedan			4		4,915			5,925		4800
coupe			2		5,660			6,820		12400
Country:Italy

pls how do i accomplish this

This message has been edited. Last edited by: joyesiji,


WebFOCUS 7.6.9
Windows
all output (Excel, HTML, PDF)
 
Posts: 20 | Registered: July 06, 2010Reply With QuoteReport This Post
Expert
posted Hide Post
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
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Reply With QuoteReport This Post
Expert
posted Hide Post
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.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6132 | Location: 33.8688° S, 151.2093° E | Registered: October 31, 2006Reply With QuoteReport This Post
Member
posted Hide Post
Thanks for the hint


WebFOCUS 7.6.9
Windows
all output (Excel, HTML, PDF)
 
Posts: 20 | Registered: July 06, 2010Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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

 
Posts: 1936 | Location: Tel Aviv, Israel | Registered: March 23, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]:Help Formatting report

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