I am trying to figure out the best way to go about populating a textbox with the single value that is retrieved from a fex. For instance we currently associate a company name with the user_profile in our MR environment. I have written a FEX to select the company based on the MR user. But I'm not sure how best to get this into the hidden textbox so it can be used in other queries. Any help is, as always, appreciated.

This message has been edited. Last edited by: DW Marker,

What do you want to do? Use the value of the company in a where clause in other reports?

I have the feeling that you not realy need a textbox but a variable that is available for every report you run.

Please give us more info so we can help you.

You could look into the _site_profile variable in the Configuration section of the WF administrion console. There you can use an include of your fex so it's ran for every report. A value for _site_profile could be like this: -INCLUDE yourfex\n
Make sure that you use a -READ with a &&variable. Here is an example:

 
TABLE FILE COMPANY
PRINT
     COMP_NAME
WHERE UP_USR_NAME EQ '&STRIP_USER';
ON TABLE SAVE AS TMPCOMP FORMAT ALPHA
END
-*
-RUN
-READ TMPCOMP  &&CMPNAME.20.

-RUN
 

Hope this helps,

Definite brain cramp on my part. While we won't need it on every request. It would make sense to just do this as part of the _site_profile, and not make it a function of the UI where it really isn't needed.