When I run ti I get: -SET &EX_NAME = 'EX IBFS:/WFC/Repository/PD2_HANA_RNA4/pdash_list_events.fex PDASH_HOT_ALERT=''REG'', PDASH_ASSIGNED=''ALL'', PDASH_GROUPING=''ALL'', PDASH_MANAGER=''ALL'', PDASH_USER=''UNKNOWN'', PDASH_REDONLY='' '', PDASH_DATE=''ALL'', PDASH_FMT=''HTML'' ' ; EX IBFS:/WFC/Repository/PD2_HANA_RNA4/pdash_list_events.fex PDASH_HOT_ALERT='REG', PDASH_ASSIGNED='ALL', PDASH_GROUPING='ALL', PDASH_MANAGER='ALL', PDASH_USER='UNKNOWN', PDASH_REDONLY=' ', PDASH_DATE='ALL', PDASH_FMT='HTML' END (FOC227) THE FOCEXEC PROCEDURE CANNOT BE FOUND: pdash_list_events.fex
How can I use a variable to execute a procedure?This message has been edited. Last edited by: Tamra,
WebFOCUS 7.7.4 Windows HTML, EXCEL, PDF Outputs
February 12, 2017, 03:45 PM
Waz
No, you cant have parameterised fex names in WF8, unless you have your code in the app directories.
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
February 13, 2017, 12:52 AM
Avinash
quote:
HOT
Hi Computernerd1957,
You can try as per below code- If your report have such parameter, It will automatically pass to the report.
If I use the -MRNOEDIT the Include has the correct FEX name but it doesn't execute and gives no errors.
If I use -MRNOEDIT with an "EX" Command it says (FOC227) THE FOCEXEC PROCEDURE CANNOT BE FOUND: pdash_list_events.fex
The Path is fully qualified and the procedure does exist.
WebFOCUS 7.7.4 Windows HTML, EXCEL, PDF Outputs
February 13, 2017, 12:03 PM
eric.woerle
From my understanding, even in 7.x, you never could parameterize the execution of a Fex in the procedure using EX / INCLUDE. From what I understand about how this works is that the EX / INCLUDE gets evaluated before any variables get evaluated. Because of this, .EVAL doesn't work and MRNOEDIT won't work either. What I've always done is to use GOTO's to jump to the fex I need to execute instead of using a variable for the Fex name in the procedure.
Eric Woerle 8.1.05M Gen 913- Reporting Server Unix 8.1.05 Client Unix Oracle 11.2.0.2
February 13, 2017, 12:12 PM
Francis Mariani
-GOTO is the only way. I tried -WRITE to create a fex with one line to -INCLUDE the appropriate fex - that doesn't work either.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
February 13, 2017, 02:05 PM
eric.woerle
ya, EX / INCLUDE are one of the first things to get processed. And from my understanding, there is no way to push the processing of a variable above the processing of the EX / INCLUDE in the order of operations.
As they taught us in grade school... its a "Please Excuse My Dear Aunt Sally" issue (Parentheses/Exponents Multiply/Divide Add/Subtract)
Eric Woerle 8.1.05M Gen 913- Reporting Server Unix 8.1.05 Client Unix Oracle 11.2.0.2
February 13, 2017, 03:34 PM
Waz
what you have to understand is that the WebFOCUS client (items stored in the repository) has a parser to work out what files to send to the reporting server.
If the file has an amper variable in or part of the name, it will not get evalualated, because the code is only at the client , and not reached the WebFOCUS server.
This is why, when you trace (ECHO=ALL) the output of a run, you will find that the original code will change.
The above is true using the Content folder - repository ( WebFOCUS Client). &variables are parsed on the Reporting Server after WebFOCUS Client process identifies the files, fexes, sty, css etc.
Francis's GOTO label is a good easy solution
Just FYI ... In the Application Folder (EDASERVE) on reporting server the following seems to work: ( as Waz indicated)
-SET &ECHO=ALL; -SET &RUNFEX = 'CAR_report_1'; -SET &INCLUDE = '-INCLUDE'; <--- or EX &INCLUDE.EVAL &RUNFEX.EVAL -EXIT
As Eric says - its all about the order of operations
Thank you for participating in the Focal Point Forum! Tamra Colangelo Focal Point Moderator Information Builders
WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5
February 15, 2017, 11:58 AM
eric.woerle
That's an interesting trick Tamra. I'll have to try using that to call a fex in the content area and see what happens. Thanks for that!
Eric Woerle 8.1.05M Gen 913- Reporting Server Unix 8.1.05 Client Unix Oracle 11.2.0.2
February 15, 2017, 01:13 PM
Computernerd1957
I changed one of my procedures to use the goto method, but I have another dynamic procedure that will not work for.
Thanks everyone for the information.
WebFOCUS 7.7.4 Windows HTML, EXCEL, PDF Outputs
February 15, 2017, 03:48 PM
Waz
quote:
SET &RUNFEX = 'CAR_report_1'; -SET &INCLUDE = '-INCLUDE'; <--- or EX &INCLUDE.EVAL &RUNFEX.EVAL
You only need the INCLUIDE or EX set as an amper variable.