Focal Point
[SOLVED]:Help Formatting report

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

April 10, 2012, 11:21 AM
joyesiji
[SOLVED]:Help Formatting report
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)
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.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

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