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,

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

Are you talking about creating a menu control in maintain? So far that is the only place I've found to create a menu.

No. I am talking about creating on HTML page using HTML Composer.

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

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

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.

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,
Can you tell me how you created the run and edit dropdowns.

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.

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.