Focal Point
[SOLVED]URL to a specific report?

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

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,


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, PDF
In 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