Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]URL to a specific report?
Go
New
Search
Notify
Tools
Reply
  
[SOLVED]URL to a specific report?
 Login/Join
 
Silver Member
posted
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
 
Posts: 36 | Registered: November 19, 2014Reply With QuoteReport This Post
Expert
posted Hide Post
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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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
 
Posts: 2282 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Silver Member
posted Hide Post
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
 
Posts: 36 | Registered: November 19, 2014Reply With QuoteReport This Post
Master
posted Hide Post
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
 
Posts: 594 | Location: Michigan | Registered: September 04, 2015Reply With QuoteReport This Post
Master
posted Hide Post
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
 
Posts: 578 | Registered: October 01, 2014Reply With QuoteReport This Post
Expert
posted Hide Post
'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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
Master
posted Hide Post
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
 
Posts: 578 | Registered: October 01, 2014Reply With QuoteReport This Post
Silver Member
posted Hide Post
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
 
Posts: 36 | Registered: November 19, 2014Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]URL to a specific report?

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.