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.
Hello! I'm looking to build a table that has all fields sorted vertically and grouping some fields under one title, how is it going to group some fields in one title? the report has to look like one group of fields under one title followed by an other group of fields in a different title, but all groups are sorted above each other (vertically)
this is the code for my fields: TABLE FILE CALL_CENTER/CALL_STATS SUM CALL_STATS.CALL_STATS.CRM_IN_PERSON_CALL WITHIN TABLE WITHIN CALL_STATS.CALL_STATS.Month AS 'In Person' OVER CALL_STATS.CALL_STATS.CRM_EMAIL_REQUESTS WITHIN TABLE WITHIN CALL_STATS.CALL_STATS.Month AS 'Email' OVER CALL_STATS.CALL_STATS.CRM_ONLINE_REQUESTS WITHIN TABLE WITHIN CALL_STATS.CALL_STATS.Month AS 'Online' ACROSS CALL_STATS.CALL_STATS.MonthThis message has been edited. Last edited by: Badr.A,
In your example I see you have 3 fields grouped together with the OVER syntax but the labels must be displaying to the left of the data. Are these the 3 fields that you want a single title above them. I don't see a second group of fields in your example. Do you want a title for the Month field going across. Please clarify.
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005
You need to use the code tag button on the ribbon. The button look like the following, then place your code and sample between the two tags that will be added to you post:
</>
The resulting code tag will be as follow
[code]
TABLE FILE CAR
SUM SEATS OVER
RETAIL_COST OVER
DEALER_COST
BY COUNTRY NOPRINT
ON COUNTRY SUBHEAD
"<COUNTRY"
""
ON COUNTRY SUBFOOT
"this is the subfoot by country"
END
[/code]
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007
Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013
Yes I want to give a title to these three fields, then I will add an other group fields with a title below them!
thank you
quote:
Originally posted by Chuck Wolff: Hi Badr.A
In your example I see you have 3 fields grouped together with the OVER syntax but the labels must be displaying to the left of the data. Are these the 3 fields that you want a single title above them. I don't see a second group of fields in your example. Do you want a title for the Month field going across. Please clarify.
I am not aware of a way to display the data as you are wanting to stack them. You can put the two groupings side by side with the use of OVER and use the HEADING or SUBHEADING to display to column titles you want.
Something like this...
TABLE FILE CAR SUM CAR.BODY.DEALER_COST AS '' CAR.BODY.RETAIL_COST AS '' OVER CAR.BODY.SALES AS '' CAR.BODY.SEATS AS '' BY LOWEST CAR.ORIGIN.COUNTRY ON TABLE SUBHEAD " <+0>Group 1<+0>Group 2<+0> <+0> " ON TABLE SET PAGE-NUM NOLEAD ON TABLE SET ASNAMES ON ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT HTML ON TABLE SET HTMLEMBEDIMG ON ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty, $ TYPE=TABHEADING, HEADALIGN=BODY, $ TYPE=TABHEADING, LINE=1, OBJECT=TEXT, ITEM=1, COLSPAN=1, JUSTIFY=LEFT, $ TYPE=TABHEADING, LINE=1, OBJECT=TEXT, ITEM=2, COLSPAN=1, JUSTIFY=LEFT, $ TYPE=TABHEADING, LINE=1, OBJECT=TEXT, ITEM=3, COLSPAN=1, JUSTIFY=LEFT, $ TYPE=TABHEADING, LINE=1, OBJECT=TEXT, ITEM=4, COLSPAN=1, JUSTIFY=LEFT, $ TYPE=TABHEADING, LINE=1, OBJECT=TEXT, ITEM=5, COLSPAN=1, JUSTIFY=LEFT, $ ENDSTYLE END
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005
I am not aware of a way to display the data as you are wanting to stack them. You can put the two groupings side by side with the use of OVER and use the HEADING or SUBHEADING to display to column titles you want.