Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] HTML how to create a table driven menu
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] HTML how to create a table driven menu
 Login/Join
 
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, 2009Reply With QuoteReport This Post
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, 2009Reply With QuoteReport This Post
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, 2009Reply With QuoteReport This Post
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, 2009Reply With QuoteReport 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
 
Reply With QuoteReport This Post
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, 2009Reply With QuoteReport This Post
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, 2009Reply With QuoteReport This Post
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, 2006Reply With QuoteReport This Post
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, 2011Reply With QuoteReport This Post
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, 2006Reply With QuoteReport This Post
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, 2011Reply With QuoteReport This Post
  Powered by Social Strata  
 

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-2018 Information Builders, leaders in enterprise business intelligence.