Hello, is there a way that I can include instructions to the user on how to run a report as a header as soon as the user hits run before the parameters are inserted? Also, I know I can use Prompt, however my boss does not like that it appears as a dropdown.This message has been edited. Last edited by: FP Mod Chuck,
on how to run a report as a header as soon as the user hits run before the parameters are inserted
Isn't too late to tell how to run once the run is already clicked ?
If you want to add a "how to", add an hyperlink to a document that will tell how to run the report but not from the run button...it's too late ! Except if I did not understand your request properly...
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007
August 08, 2019, 04:25 PM
Waz
This very much depends on what you have built, with what tool, and what sort of access you have to change things.
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!
August 12, 2019, 11:56 AM
Tracie Jones
Martin, no it is not too late because the parameters are not entered yet. This is what I have now, but it is ugly: -DEFAULT &DISPLAY= ' '; -DEFAULT &DISPLAY2= ' '; -DEFAULT &DISPLAY3= ' '; -DEFAULT &DISPLAY4= ' '; -DEFAULT &DISPLAY5= ' ';
-PROMPT &DISPLAY.(Use Begin and End Date to select a Last Work Day range). . -PROMPT &DISPLAY2.(or ). . -PROMPT &DISPLAY3.(Use Begin and End Date to select a Benefits Term Date Range). . -PROMPT &DISPLAY4.(or ). . -PROMPT &DISPLAY5.(Enter Up to 10 Employee ID). .This message has been edited. Last edited by: Tracie Jones,
To clarify your request : you want to display instructions within the auto-prompt which, I think, it's going to be a pain. The -PROMPT feature is for simple user entry. Not fancy ones.
You should better go with an HTML page/form. That way you'll be able to add as many "header instructions" rows you wish.
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007
August 12, 2019, 02:11 PM
Mike in DeLand
Is there any reason you can't build an HTML launch page with parameters and instructions on it? We do that all the time.
Webfocus 8 Windows, Linux
August 12, 2019, 02:16 PM
Hallway
Not the prettiest option, but you could create a different fex file and using the HTMLFORM block (or just create a plain html file) and use an iFrame to hold the report. You can then write your instructions above the iframe that will hold the report and the auto-prompt will be inside the iframe:
-HTMLFORM BEGIN NOEVAL
<body>
<header id="instructions">
<ul>Use the filters below in one of the following methods:
<li>Use Begin and End Date to select a Last Work Day range</li>
<li>Use Begin and End Date to select a Benefits Term Date Range</li>
<li>Enter Up to 10 Employee ID</li>
</ul>
</header>
<iframe src="/ibi_apps/run/ibfs?IBFS_path=/WFC/Repository/[domain and path to your file name].fex" style="width:100%; height:89%;border:none;"></iframe>
</body>
-HTMLFORM END
Hallway
Prod: 8202M1
Test: 8202M4
Repository:
OS:
Outputs:
August 13, 2019, 12:27 PM
Tracie Jones
Thank you Hallway! OK this is the path to the report. IBFS:/SSC Payroll Prod/WFC/Repository/hrimpl/UNCP_Non-Prod_Reports/GA_Reports/HR_Reports/EXIT2.fex
When I substitute it in your code, I am getting no source found. What am I missing?
With that IBFS path, this is how the code should look:
-HTMLFORM BEGIN NOEVAL
<body>
<header id="instructions">
<ul>Use the filters below in one of the following methods:
[*]Use Begin and End Date to select a Last Work Day range
[*]Use Begin and End Date to select a Benefits Term Date Range
[*]Enter Up to 10 Employee ID
</ul>
</header>
<iframe src="/ibi_apps/run/ibfs?IBFS_path=/WFC/Repository/hrimpl/UNCP_Non-Prod_Reports/GA_Reports/HR_Reports/EXIT2.fex" style="width:100%; height:89%;border:none;"></iframe>
</body>
-HTMLFORM END
If that doesn't work, then just run the EXIT2.fex to a new tab like you normally would from the WebFOCUS Home Page, and then copy the URI path from (and including) the "/ibi_apps/..." and replace that in the src attribute of the iframe. You don't need to copy the scheme (ie http:) nor the authority (ie: host (server) name (ie. http[s]://hostname[.domain.com] ). you just need to copy the path. That way it will stay dynamic.
that did not work either. The second thing you told me to try, copied the parameters I used to run the report and just spit out the report with the old parameters. I need it to ask the user for the parameters each time upon execution. Below is the link when exit2.fex is called, I put in parameters, and this is the link to the report.
Originally posted by Hallway: With that IBFS path, this is how the code should look:
-HTMLFORM BEGIN NOEVAL
<body>
<header id="instructions">
<ul>Use the filters below in one of the following methods:
[*]Use Begin and End Date to select a Last Work Day range
[*]Use Begin and End Date to select a Benefits Term Date Range
[*]Enter Up to 10 Employee ID
</ul>
</header>
<iframe src="/ibi_apps/run/ibfs?IBFS_path=/WFC/Repository/hrimpl/UNCP_Non-Prod_Reports/GA_Reports/HR_Reports/EXIT2.fex" style="width:100%; height:89%;border:none;"></iframe>
</body>
-HTMLFORM END
If that doesn't work, then just run the EXIT2.fex to a new tab like you normally would from the WebFOCUS Home Page, and then copy the URI path from (and including) the "/ibi_apps/..." and replace that in the src attribute of the iframe. You don't need to copy the scheme (ie http nor the authority (ie: host (server) name (ie. http[s]://hostname[.domain.com] ). you just need to copy the path. That way it will stay dynamic.
Again... This stupid forum has reformatted my code and replaced my angle brackets with square brackets. 😡
I'll try this one last time:
<body> <header id="instructions"> <ul>Use the filters below in one of the following methods: <li>Use Begin and End Date to select a Last Work Day range <li>Use Begin and End Date to select a Benefits Term Date Range <li>Enter Up to 10 Employee ID </ul> </header> <iframe src="/ibi_apps/run/ibfs?IBFS_path=/WFC/Repository/hrimpl/UNCP_Non-Prod_Reports/GA_Reports/HR_Reports/EXIT2.fex" style="width:100%; height:89%;border:none;"></iframe> </body>
Hallway
Prod: 8202M1
Test: 8202M4
Repository:
OS:
Outputs:
August 13, 2019, 03:27 PM
Tracie Jones
still doesnt work...the instructions show but I get a 404 Error, Source not found in the frame...#sigh
-HTMLFORM BEGIN NOEVAL
Use the filters below in one of the following methods:
Use Begin and End Date to select a Last Work Day range OR
Use Begin and End Date to select a Benefits Term Date range OR
Open the dev tool in the browser and go to the iframe and see what the src is in the iframe. Make sure that the URI is the same i that iframe as the UIR is when you run the report to a new tabe from the WebFOCUS Home Page. Make sure that you are running it from the web portal, and not AppStudio. AppStudio doesn't show you the full URI. Only running the report from the web to a new tab will show you.
Hallway
Prod: 8202M1
Test: 8202M4
Repository:
OS:
Outputs:
August 13, 2019, 03:53 PM
Hallway
quote:
Originally posted by Tracie Jones: that did not work either. The second thing you told me to try, copied the parameters I used to run the report and just spit out the report with the old parameters. I need it to ask the user for the parameters each time upon execution. Below is the link when exit2.fex is called, I put in parameters, and this is the link to the report.
Interesting. Okay then, in the future, when an end user is going to access this report, how would they do that?
Hallway
Prod: 8202M1
Test: 8202M4
Repository:
OS:
Outputs:
August 13, 2019, 04:23 PM
Tracie Jones
We drop it into their webfocus folder and they run it via Developer or the dashboard. I work for the UNC System,so I would drop it into all the UNC campuses folders.