Focal Point
[CLOSED] How to create a URL to execute a report

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

April 20, 2012, 12:38 PM
nsk110483
[CLOSED] How to create a URL to execute a report
Hi All,

I have done all my reporting in MRE and have always given access to MRE to my users who could access the reports from MRE. However, now I have a requirement where I have to create a luanch page for a report which the clients could access, enter their own parameters and then run the report. How can I deliver the same report to the client who will not have access to MRE?

I have tried the publish utility, but it did not create any .htm page in the /ibi_html/publish directory.
I am using 7.6.9 version.

I appreciate any help
Thanks

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


In Focus since 2008
WebFOCUS 8.2.0.1
Windows 7 - IE,Chrome,Firefox
Excel, PDF, HTML, AHTML, XML
JavaScript, jQuery, D3.js, Highcharts
April 22, 2012, 06:27 PM
Waz
Publish is one way.

Using BI dashboard, and the public view is another.


I would suggest looking into the reasons why publish is not working, as there may be unseen issues with your installation.


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!

April 23, 2012, 12:34 PM
Darin Lee
First, I would warn you about setting things up like this because you are basically poking a hole in your secured MRE environment. That being said, we have found several reasons to do this for internal applications.

Here's a basic url:
http://~servername~/ibi_apps/WFServlet?IBIMR_action=MR_RUN_FEX&IBIMR_sub_action=MR_STD_REPORT&IBIMR_drill=RUNNID&IBIWF_action=WF_SIGNON&IBIC_user=~userid~&IBIC_pass=~password~&IBIMR_domain=~domain/domain.htm~&IBIMR_flags=&IBIMR_folder=~foldername~&IBIMR_fex=app/~fexname.fex~&IBIF_ex=app/~fexname.fex~IBIMR_random=


item in between ~ are things that you would replace according to your environment. Notice that this includes a user id and password. If your WF server is operating with security on, there's no way around that part. You just need to figure out the best way to "hide" those things if it matters. The IBIMR_domain will be the domain information for the location wher the fex lives in MRE. You can look at the properties of the domain to get the info. Same with the IBIMR_folder and fexname. Last, but not least, there is a property in your client configuration that prevents external access to MRE procedures. I think it's call MR_ANONYMOUS_RUN_ACCESS or something like that. This must be enabled for you to accomplish what you're trying to do. Then the IBIMR_drill=RUNNID in the URL tells it you are running as anonymous.

Again, remember that you are changing your system's security so make sure that changes you make are not allowing unintended access somewhere else.


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat