Focal Point
[SOLVED]URL to a specific report?
November 07, 2016, 01:44 PM
MelissaReed [SOLVED]URL to a specific report?
I have another tool which we would like to link to a specific report. Does anyone have any experience with building a URL to open a specific report (passing the parameters as well) without having to open it within the WF portal first?
TIA!
This message has been edited. Last edited by: MelissaReed , November 09, 2016 11:58 AM WebFOCUS 8.0.09 Windows, All Outputs
November 07, 2016, 02:00 PM
Francis Mariani Melissa,
Simply view the Repository Tree in any portal (by pressing F8). Then find the appropriate report and run it. When the new browser window opens, right-click and select Properties. You should see the URL. Here is an example:
http://my.wf.server/ibi_apps/views.bip?BIP_REQUEST_TYPE=BIP_RUN&BIP_folder=IBFS%253A%252FWFC%252FRepository%252FTest%252FFrancis%252Fmy_sub_folder&WF_STYLE_HEIGHT=600&WF_STYLE_WIDTH=800&BIP_item=fm_report_1.fex&BIP_rand=92358 This can be cleaned up to:
http://my.wf.server/ibi_apps/views.bip?BIP_REQUEST_TYPE=BIP_RUN&BIP_folder=IBFS%253A%252FWFC%252FRepository%252FTest%252FFrancis%252Fmy_sub_folder&BIP_item=fm_report_1.fex and though not necessary, cleaned up even further by replacing the encoded values:
http://my.wf.server/ibi_apps/views.bip?BIP_REQUEST_TYPE=BIP_RUN&BIP_folder=IBFS:/WFC/Repository/Test/Francis/my_sub_folder&BIP_item=fm_report_1.fex You can add the parameters to the end of the URL:
http://my.wf.server/ibi_apps/views.bip?BIP_REQUEST_TYPE=BIP_RUN&BIP_folder=IBFS:/WFC/Repository/Test/Francis/my_sub_folder&BIP_item=fm_report_1.fex&PARAMETER1=TESTING1&PARAMETER2=TESTING2 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
November 07, 2016, 02:04 PM
MartinY But what about WF security ?
If not available from "outside" WF, the report may not be available, may need to use a Public profile. Isn't it ?
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDFIn Focus since 2007
November 07, 2016, 02:11 PM
MelissaReed Yes, it would need to be available to public, available to anyone. Right now the report within WF is available to anyone who can access our portal.
WebFOCUS 8.0.09 Windows, All Outputs
November 07, 2016, 02:40 PM
Squatch If you put your report inside of a folder under "Reporting Servers" (EDASERVE, in my case), it should be accessible.
http://YOUR_SERVER_NAME/ibi_ap...l/cherwell_graph.fex
So in my reporting server I have a folder called "cherwell" and a graph called "cherwell_graph.fex" inside of it.
(Click on the link to see the entire URL in a new browser window.)
App Studio WebFOCUS 8.1.05M Windows, All Outputs
November 08, 2016, 03:42 PM
GavinL If your 8.0+ and have Restful Services setup in WF you can also do a simple link.
/ibi_apps/rs/ibfs/WFC/Repository/YouFolder/YourSubfolder/YourFile.fex?IBIRS_action=run
In WF8.2 you don't have to put the IBIRS_action=run on the end.
- FOCUS Man, just FOCUS! -----------------------------
Product: WebFOCUS
Version: 8.1.04
Server: Windows 2008 Server
November 08, 2016, 03:49 PM
Francis Mariani 'Restful Services' - is that what the "rs" in the URL stands for?
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
November 09, 2016, 07:20 AM
GavinL quote:
'Restful Services' - is that what the "rs" in the URL stands for?
From my understanding.
- FOCUS Man, just FOCUS! -----------------------------
Product: WebFOCUS
Version: 8.1.04
Server: Windows 2008 Server
November 09, 2016, 12:00 PM
MelissaReed quote:
Originally posted by Francis Mariani:
You can add the parameters to the end of the URL:
http://my.wf.server/ibi_apps/views.bip?BIP_REQUEST_TYPE=BIP_RUN&BIP_folder=IBFS:/WFC/Repository/Test/Francis/my_sub_folder&BIP_item=fm_report_1.fex&PARAMETER1=TESTING1&PARAMETER2=TESTING2 Thank you Francis - This worked great!
WebFOCUS 8.0.09 Windows, All Outputs