Hello,

I am using WebFOCUS 7.7.03. I have reports that have been created or imported into the Managed Reporting Environment. Some of these reports may need to be executed from froms in a Maintain application or from the Managed Reporting Environment. I have tried searching for this, but am only finding examples calling a Maintain proc from the Managed Reporting environment. Is there a way to execute/call/drill down to a Managed Reporting procedure from a Maintain Form?

Thank you in advance for any assistance.

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

Check out this thread. It should give you enough to run an MR report.

To kick off a report from a form, and still be able to return to the Maintain form, I either create a URL from a weblink or enter this code into a JavaScript Trigger. If you give the command the complete path to the report, you can also pass in as many parameters as you want.

The window.open command launches a new window in which to display the report so you don't lose connection to your Maintain application.


url="http://issvmappsaeip.ibi.com/ibi_apps/WFServlet?IBIF_ex=reviewrpt2&IBIC_server=EIPRV&IBIAPP_app=Personnel& YR="+tyear+"&ID="+ MatchVal+ "&VAR2=" + pcode+ "&ts=" + ts;

window.open(url);

Mark

I apologize for the delay in responding to this post. I got pulled off on other projects. The solution provided by Mark works with one concern. I need to be able to limit who runs the reports and tried passing the credentials. It became part of the url and thus is visible to the users. Is it possible to pass the MRE credentials without them being (visible) in the URL?

Thank you,
Deana

quote:

Originally posted by Deana:
I apologize for the delay in responding to this post. I got pulled off on other projects. The solution provided by Mark works with one concern. I need to be able to limit who runs the reports and tried passing the credentials. It became part of the url and thus is visible to the users. Is it possible to pass the MRE credentials without them being (visible) in the URL?

Thank you,
Deana

If you can find an answer to this I would love to know how. We have been trying to mask the URL stream for awhile now with no luck.

After opening a case, at this time there is no way to mask the url so the credentials are going to be visible to the user. I have decided not to execute any Managed Reporting procedures from the Maintain app.

quote:

window.open(url);

quote:

no way to mask the url so the credentials are going to be visible to the user.

When we create a subwindow, we set the location attribute to 'no' so that the current URL isn't visble to the user. Something like: window.open(url, "NewWindow, "location=no") Even with this, there are other ways for the user to ascertain the URL, but if the requirement is to not display the URL, you might want to try this attribute setting.

This message has been edited. Last edited by: David Briars,

David,
Thanks for the suggestion. I did try setting location = "no". I can prevent the URL from displaying, but the string that gets passed, including the credentials still appears in the Title Bar. In researching the location setting, I did find that newer versions of various browsers have disabled the ability to set location = no.
I also tried resetting the text in the title bar. Not surprisingly, the report does not execute at all.

Thank you again for the suggestion. I appreciate your assistance.

Deana