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.
Hi evryone, I'm completely new to webfocus and I am already hitting a wall it what i thought would be a simple design.
What I want to do is create a drill down report simialr to a grid in which when you click the drill down feild it it inserts the report between the rows od the parent report. Is this possible? When I realized that the drill down generates a new report for each drill down I thought maybe I could insert a hidden line with a iframe in it and use that to target the drill down. the report is sorta like:
COMPANY SALES INVENTORY A 1000 500 B 1000 500 EAST 250 100 WEST 400 300 SOUTH 300 75 NORTH 50 25 C 1000 500
where when you click on b it inserts the 4 rows between B and C.
is this at all possible?
what would also be sweet if that when click a new drill down it doesn't close the previous drill downs. I've done similar reporting in VB and MS Access and also crystal, but Webfocus is a totally new animal.
In the next major release this will be a feature. We are calling this an 'accordian' report. It can be done, somewhat today, eg first report. TABLE FILE X SUM D BY A END
A D A1 99 A2 99 A3 99
drill on A1 second report is ..
DEFINE FILE X BVALUE=IF A EQ 'A1' THEN B ELSE ' ' ; END TABLE FILE X SUM D BY A FOLDLINE BY B END
You may be able to get what you want if, instead of running a new report when clicking on a hyperlink, you simply show data that was extracted, but hidden, in the main report.
Here's an example of hidden data being shown when something is clicked on.
-*-- Hide and Show DIVS to demonstrate displaying extra data for a cell on a -*-- report -SET &ECHO=ALL;
DEFINE FILE CAR CONTINENT/A10 = IF COUNTRY IN ('ENGLAND', 'FRANCE', 'ITALY', 'W GERMANY') THEN 'Europe' ELSE IF COUNTRY EQ 'JAPAN' THEN 'Asia' ELSE '???'; COUNTRY_DETAIL/A50 = COUNTRY || (' is a country in ' | CONTINENT); END TABLE FILE CAR PRINT COUNTRY COUNTRY_DETAIL CAR MODEL DEALER_COST RETAIL_COST SALES COMPUTE COUNTER/I4 = COUNTER + 1; BY COUNTRY NOPRINT BY CAR NOPRINT BY MODEL NOPRINT ON TABLE HOLD FORMAT ALPHA END
' ; END TABLE FILE HOLD PRINT LINK_OPEN AS '' COUNTRY AS 'Country' CAR AS 'Car' MODEL AS 'Model' DEALER_COST AS 'Dealer,Cost' RETAIL_COST AS 'Retail,Cost' SALES AS 'Sales' COUNTRY_EXTRA AS '' BY COUNTRY NOPRINT BY CAR NOPRINT BY MODEL NOPRINT
ON COUNTRY SUBHEAD " "
HEADING CENTER "Car Sales" " "
ON TABLE HOLD AS HOLD01 FORMAT HTMTABLE ON TABLE SET PAGE NOLEAD ON TABLE SET STYLE * TYPE=REPORT, GRID=OFF, SQUEEZE=ON, $
Read-Only Topic
I'm completely new to webfocus and I am already hitting a wall it what i thought would be a simple design. 
' onClick="fnToggle(''' || EDIT(COUNTER) || ''')">';