Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


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

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[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, 2010Report 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, 2003Report 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.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report 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, 2010Report 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: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

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

Copyright © 1996-2020 Information Builders