Focal Point
[CLOSED] Header/Instructions upon execution

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6157064196

August 08, 2019, 10:05 AM
Tracie Jones
[CLOSED] Header/Instructions upon execution
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,


tbj
Prod WF 8.1.05,Test WF 8.1.05, WINDOWS 7 Platform, Oracle 12
Excel, PDF, Alpha
August 08, 2019, 01:12 PM
MartinY
quote:
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.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs: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,


tbj
Prod WF 8.1.05,Test WF 8.1.05, WINDOWS 7 Platform, Oracle 12
Excel, PDF, Alpha
August 12, 2019, 01:34 PM
MartinY
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?


tbj
Prod WF 8.1.05,Test WF 8.1.05, WINDOWS 7 Platform, Oracle 12
Excel, PDF, Alpha
August 13, 2019, 01:17 PM
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.

For more info on a URI structure, see here: https://en.wikipedia.org/wiki/...ifier#Generic_syntax

This message has been edited. Last edited by: Hallway,


Hallway

 
Prod: 8202M1
Test: 8202M4
Repository:
 
OS:
 
Outputs:
 
 
 
 
August 13, 2019, 01:31 PM
Hallway
Here is an example of the URI structure:
"          userinfo       host      port
          ┌──┴───┐ ┌──────┴──────┐ ┌┴┐
  https://john.doe@www.example.com:123/forum/questions/?tag=networking&order=newest#top
  └─┬─┘   └───────────┬──────────────┘└───────┬───────┘ └───────────┬─────────────┘ └┬┘
  scheme          authority                  path                 query           fragment

"
You need the path and the query in the iframe as the src

This message has been edited. Last edited by: Hallway,


Hallway

 
Prod: 8202M1
Test: 8202M4
Repository:
 
OS:
 
Outputs:
 
 
 
 
August 13, 2019, 01:43 PM
Hallway
Yeah, I give up on this stupid forum reformatting my code.

Just follow the link to a real website that will show the correct structure https://en.wikipedia.org/wiki/..._Identifier#Examples


Hallway

 
Prod: 8202M1
Test: 8202M4
Repository:
 
OS:
 
Outputs:
 
 
 
 
August 13, 2019, 01:48 PM
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.

/ibi_apps/WFServlet?PG_REQTYPE=REDIRECT&PG_MRsaved=false&PG_Func=GETBINARY&PG_File=ljwdrlty.pdf

This is the link when I hit run, without putting in any parameters

http://webfocusp41-ga.uncecs.e..._apps/WFServlet.ibfs


tbj
Prod WF 8.1.05,Test WF 8.1.05, WINDOWS 7 Platform, Oracle 12
Excel, PDF, Alpha
August 13, 2019, 01:49 PM
Tracie Jones
LOL ok

quote:
Originally posted by Hallway:
Yeah, I give up on this stupid forum reformatting my code.

Just follow the link to a real website that will show the correct structure https://en.wikipedia.org/wiki/..._Identifier#Examples



tbj
Prod WF 8.1.05,Test WF 8.1.05, WINDOWS 7 Platform, Oracle 12
Excel, PDF, Alpha
August 13, 2019, 01:59 PM
Tracie Jones
ok so I used this
/ibi_apps/WFServlet?PG_REQTYPE=REDIRECT&PG_MRsaved=false&PG_Func=GETBINARY&PG_File

But now my instructions are gone....the parameters came up though!


tbj
Prod WF 8.1.05,Test WF 8.1.05, WINDOWS 7 Platform, Oracle 12
Excel, PDF, Alpha
August 13, 2019, 02:37 PM
Hallway
quote:
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 httpSmiler 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.

For more info on a URI structure, see here: https://en.wikipedia.org/wiki/...ifier#Generic_syntax


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





<iframe src=" <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;">"



-HTMLFORM END


tbj
Prod WF 8.1.05,Test WF 8.1.05, WINDOWS 7 Platform, Oracle 12
Excel, PDF, Alpha
August 13, 2019, 03:49 PM
Hallway
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.

/ibi_apps/WFServlet?PG_REQTYPE=REDIRECT&PG_MRsaved=false&PG_Func=GETBINARY&PG_File=ljwdrlty.pdf

This is the link when I hit run, without putting in any parameters

http://webfocusp41-ga.uncecs.e..._apps/WFServlet.ibfs


This looks like a link from when the fex is run in AppStudio. Can you run the exit2.fex from the web portal?


Hallway

 
Prod: 8202M1
Test: 8202M4
Repository:
 
OS:
 
Outputs:
 
 
 
 
August 13, 2019, 03:54 PM
Hallway
Try going here and see if you can navigate to the report and run it in a new tab
http://webfocusp41-ga.uncecs.edu:8080/ibi_apps/


Hallway

 
Prod: 8202M1
Test: 8202M4
Repository:
 
OS:
 
Outputs:
 
 
 
 
August 13, 2019, 04:10 PM
Tracie Jones
Yes, I can run it fine via Developer Studio.

I get this when I go to http://webfocusp41-ga.uncecs.edu:8080/ibi_apps/

401 - Unauthorized

You are not authorized to view this page


tbj
Prod WF 8.1.05,Test WF 8.1.05, WINDOWS 7 Platform, Oracle 12
Excel, PDF, Alpha
August 13, 2019, 04:17 PM
Hallway
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.


tbj
Prod WF 8.1.05,Test WF 8.1.05, WINDOWS 7 Platform, Oracle 12
Excel, PDF, Alpha
August 13, 2019, 04:33 PM
Hallway
I sent you a Private Message. Let's continue this on that thread to avoid the potential of sharing too much private information.


Hallway

 
Prod: 8202M1
Test: 8202M4
Repository:
 
OS:
 
Outputs:
 
 
 
 
August 14, 2019, 03:26 AM
Tony A
quote:
Yeah, I give up on this stupid forum reformatting my code.

Oh come on Mr Hallway, just change the : in the url to &colon; and it should be fine.

Like so ...
          userinfo       host      port
          ┌──┴───┐ ┌──────┴──────┐ ┌┴┐
  https://john.doe@www.example.com:123/forum/questions/?tag=networking&order=newest#top
  └─┬─┘   └───────────┬──────────────┘└───────┬───────┘ └───────────┬─────────────┘ └┬┘
  scheme          authority                  path                 query           fragment


WinkWinkWink

Hope you and the team are all well!

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10