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.
New TIBCO Community Coming Soon
In early summer, TIBCO plans to launch a new community—with a new user experience, enhanced search, and expanded capabilities for member engagement with answers and discussions! In advance of that, the current myibi community will be retired on April 30. We will continue to provide updates here on both the retirement of myibi and the new community launch.
What You Need to Know about Our New Community
We value the wealth of knowledge and engagement shared by community members and hope the new community will continue cultivating networking, knowledge sharing, and discussion.
During the transition period, from April 20th until the new community is launched this summer, myibi users should access the TIBCO WebFOCUS page to engage.
You'll not achieve the format you get with HTML in CSV because the latter is a data format and not a display format, therefore you will not be able to use the HEADING idea for that as the HEADING is not retained.
Your answer lies in the history of Focal Point - all the posts and responses laid down since it's inception.
However, as search seems a little too much, think along these lines -
-* Try each of these in turn
-SET &WFFMT = 'PDF';
-SET &WFFMT = 'CSV';
-SET &WFFMT = 'HTML';
TABLE FILE CAR
SUM COUNTRY NOPRINT
ON TABLE SAVE AS TEMPSAV1
-READ TEMPSAV1 &Country1.A10. &Country2.A10. &Country3.A10. &Country4.A10. &Country5.A10.
-IF &WFFMT EQ 'CSV' THEN :Label01;
TABLE FILE GGSALES
BY REGION NOPRINT
"Country1 <+0> &Country1 <+0> Country4 <+0> &Country4 "
"Country2 <+0> &Country2 <+0> Country5 <+0> &Country5 "
"Country3 <+0> &Country3 "
IF RECORDLIMIT EQ 1
ON TABLE PCHOLD FORMAT &WFFMT
ON TABLE SET HTMLCSS ON
ON TABLE SET PAGE NOLEAD
ON TABLE SET STYLE *
-* Styling as per your needs
FILEDEF CSVOUT DISK CSVOUT.csv
-WRITE CSVOUT Country1,&Country1.EVAL,Country4,&Country4.EVAL
-WRITE CSVOUT Country2,&Country2.EVAL,Country5,&Country5.EVAL
-WRITE CSVOUT Country3,&Country3.EVAL
CMD TYPE CSVOUT.csv
All you have to do is exercise the little grey cells
In FOCUS since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
WebFOCUS App Studio 8.2.06 standalone on Windows 10
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004
COL1 AS 'COLUMN 1' COL6 AS 'COLUMN 6' OVER COL2 AS 'COLUMN 2' COL7 AS 'COLUMN 7' OVER COL3 AS 'COLUMN 3' COL8 AS 'COLUMN 8' OVER COL4 AS 'COLUMN 4' COL9 AS 'COLUMN 9' OVER COL5 AS 'COLUMN 5' COL10 AS 'COLUMN 10' OVER
Thanks to all for your help.This message has been edited. Last edited by: Jagadish,