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     [CLOSED] HTML how to create a table driven menu

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] HTML how to create a table driven menu
 Login/Join
 
Brenda Wilkerson
Gold member
posted
Hi, new to WF and not sure how to ask what I need. I have a table that has names of reports and their associated fex. I need to create a menu that will list the report name and when that report is clicked, it will execute the associated fex. I will be using this in a group view in a launch block and the report will be displayed in an output block. Any help on this PLEASE?

This message has been edited. Last edited by: Kerry,



WebFOCUS 7.7.03
Windows 7
 
Posts: 55 | Location: USA | Registered: November 02, 2009Report This Post
Enigma006
Master
posted Hide Post
May be you can create a drop down menu with name FEX_NAME. Populate the menu with Report name as display and fex name as value. When button is clicked send that value to a procedure.
Procedure may have code like this.

-INCLUDE &FEX_NAME

This should make that fex run hopefully..

Thanks


8.1.05
HTML,PDF,EXL2K, Active, All
 
Posts: 484 | Registered: February 03, 2009Report This Post
Brenda Wilkerson
Gold member
posted Hide Post
Are you talking about creating a menu control in maintain? So far that is the only place I've found to create a menu.



WebFOCUS 7.7.03
Windows 7
 
Posts: 55 | Location: USA | Registered: November 02, 2009Report This Post
Enigma006
Master
posted Hide Post
No. I am talking about creating on HTML page using HTML Composer.


8.1.05
HTML,PDF,EXL2K, Active, All
 
Posts: 484 | Registered: February 03, 2009Report This Post
<FreSte>
posted
Hi,

Below you'll find a small and VERY BASIC example.
(Just change the server/port)

-Fred-


DEFINE FILE CAR
  FEXNAME/A10 = IF COUNTRY EQ 'ENGLAND' THEN 'fex1' ELSE
                IF COUNTRY EQ 'FRANCE'  THEN 'fex2' ELSE
                IF COUNTRY EQ 'ITALY'   THEN 'fex3' ELSE 'not_set';
END

TABLE FILE CAR
  SUM
    COMPUTE URL/A100 = '<a href=''http://localhost:8080/ibi_apps/WFServlet?IBIF_ex=' || FEXNAME || '''>' | COUNTRY | '</a>';
  BY FEXNAME
WHERE FEXNAME NE 'not_set';
END
 
Report This Post
Enigma006
Master
posted Hide Post
If you want to run all reports from a fex, above way works. If its from html page, u may try the idea I mentioned.
Let us know if something works or the other


8.1.05
HTML,PDF,EXL2K, Active, All
 
Posts: 484 | Registered: February 03, 2009Report This Post
Brenda Wilkerson
Gold member
posted Hide Post
thx, not sure yet, as I said this is new for me and my first. Still trying to create the drop down menu but haven't found how yet. Got a drop down list so just working thru it and going crazy.



WebFOCUS 7.7.03
Windows 7
 
Posts: 55 | Location: USA | Registered: November 02, 2009Report This Post
FrankDutch
Virtuoso
posted Hide Post
We have created a report out of all the fexes (with a dir/s *.fex) and the result gives an overview with internal name, date created, date last runned, by who etc.
Out of that overview we have drop down on each row.
You can either select to edit the fex, or run it.




Frank
prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
DW_Dev
Member
posted Hide Post
Frank,
Can you tell me how you created the run and edit dropdowns.


Webfocus 7.7.04, Windows, HTML,Excel , Active PDF, Active HTML, Flex Enable
 
Posts: 21 | Registered: February 17, 2011Report This Post
FrankDutch
Virtuoso
posted Hide Post
We use an URL that points to the location of the fex and either opens or run that fex.

It is not possible to copy the fex since it has several includes and many decribing comments in Dutch.
Also the fieldnames we use are most of the time in Dutch.




Frank
prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
DW_Dev
Member
posted Hide Post
I was able to figure it out. Used the URL By Field method and built the URL as a compute Column. This forum helps a lot.


Webfocus 7.7.04, Windows, HTML,Excel , Active PDF, Active HTML, Flex Enable
 
Posts: 21 | Registered: February 17, 2011Report 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     [CLOSED] HTML how to create a table driven menu

Copyright © 1996-2020 Information Builders