Focal Point
Calling Report Assistant from Self Service App

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

September 09, 2003, 04:42 PM
Jen
Calling Report Assistant from Self Service App
Does anyone know anything about this topic? The documentation is pretty sparse and confusing. I'm trying to call the Report Assistant in a self-service app, but I want to limit the list of master files that a user sees. Thanks!
Jen
September 10, 2003, 09:19 PM
<Emma Schwarz>
Jen,

There are updates coming for this section of the manual.

You can call HTML Report Assistant with the following url, which will bring up the tool for a particular master:
[URL=http://machinename/ibi_apps/assi
st/jsp/rpasstie.jsp?MasterFile=masterfile
&MRcgiPrefix=http://machinename/ibi_apps/WFServlet&IBIjavapath=
http://machinename/ibi_html/
javaassist&R
eportFlag=0&Type=REPORT&a
ppserverdirectory=/ibi_apps/assist/jsp&
IBIServer=servername&IBIApp=appname]http://machinename/ibi_
apps/assist/jsp/rpasstie.jsp?
MasterFile=
masterfile&
MRcgiPrefix=http://
machinename/ibi_apps/W
FServlet&IBIj
avapath=http://
machinename/ibi_html/
javaassist&Repor tFlag=0&Type=REPORT&appserverdirectory=/ibi_
apps/assist/jsp&IBIServer=
servername&IBIApp=appname[/URL]

In the url, you need to change "machinename" (3 occurences) to your own machine name and "masterfile" to the name of the master you're using.

The parameters &IBIServer and &IBIApp are optional. You would use &IBIServer if you have multiple WebFOCUS servers and want to access other than the default server for data retrieval. &IBIApp would be used if you are using a particular application directory under ibi/apps.

Setting the application path is a way to limit the master files that a user has access to. You can read more about that in the WebFOCUS Developing Applications manual, DN4500514.0303. It is available online.

Let me know if this technique works for you.

Regards,
Emma Schwarz

This message has been edited. Last edited by: <Mabel>,
September 10, 2003, 11:29 PM
Jen
Thank you, Emma!! That works great!

Jen
September 11, 2003, 03:04 PM
Jen
Emma,
I have another question now. What if I want to call up a list of master files, instead of just one? I tried deleting the masterfile parameter in the URL and specifying the App name, but that didn't work.

Thanks!
Jen
September 16, 2003, 03:24 PM
<Emma Schwarz>
Jen,

This will bring up the Master dialogue, it's a different jsp that must be called:

[URL=http://machinename/ibi_apps/
assist/jsp/mastdlg.jsp?MRcgiPrefix=http:/
/machinename/ibi_apps/WFServlet&IBIjavapath=
http://machinename/ibi_html/javaassist&Stan
dalone=true&Type=REPORT&ReportFlag=0&appser
verdirectory=/ibi_apps/assist/jsp]http://
machinename/ibi_apps/assist/jsp/mastdlg.
jsp?MRcgiPrefix=http://machinename/ibi_
apps/WFServlet&IBIjavapath=http://machinename
/ibi_html/javaassist&Standalone=true&Type=
REPORT& ReportFlag=0&appserverdirectory=/ibi_apps/assist/jsp
[/URL]

After selecting a Master file, the Report Assistant tool will come up for that file.

Let me know if it works for you.
Emma

This message has been edited. Last edited by: <Mabel>,
September 16, 2003, 04:39 PM
Jen
I get the following error message when I try that:

ERROR: ERROR_MR_MISSING_STRING IBIMR_cookie

Any ideas?

Thanks!
September 16, 2003, 06:07 PM
<Emma Schwarz>
Jen,

What version of WebFOCUS are you using? 5.2.3?

Thanks,
Emma
September 16, 2003, 07:43 PM
Jen
Version 5.2.1
October 09, 2003, 03:56 PM
<Emma Schwarz>
Jen,

WebFOCUS must be configured for MRE for this to work. I'm not sure if that may be the issue.

However, there are some problems with this that will be corrected in 5.2.4.

Regards,
Emma Schwarz
December 24, 2003, 03:14 AM
<Viswa>
Hi Jen

I have one problem regarding invoking report assistant from an application.
My Requirement is, i need to open the report assistant(from an executed WF Report) and what ever the user has selected, a Report should be genrated and he can save taht report.

Please tell me How can i acheive this.
It would be helpful for me, if you provide an example for the same.


Thanks
Viswa
December 29, 2003, 02:47 PM
Jen
Viswa,
I'm not sure what you mean by calling the report assistant from an executed WF report? What I am trying to do is have a link within my self-service app that when the user clicks on it, it calls up the Report Assistant, and they can then run adhoc reports. We are not using the MRE environment, we chose to go the self service route, but we still want to be able to call the Report Assistant tool. I was able to get this to work, but only for one master file. If you could tell me a little more about what you are trying to do, and what environment you are in, I may be able to help.
Jen
December 30, 2003, 09:36 AM
<Viswa>
Hi jen

I wanted to do, what you have specified in detail.
we have webfocus 521.

Without logging into MRE, i need to call report builder and users need to run the Adhoc Reports.
It would be very helpful for me, if you can provide me with some sample code..You can mail your things to viswakanth@iitiim.com

Thanks in advance..

Thanks
Viswakanth
December 30, 2003, 02:31 PM
webfocuspgm
Hi Jen....
I know Viswa asked for you to mail the info to him but I'd like to see your examples as well..... Could you post more info here I'd like to try this.

Thanks
January 05, 2004, 03:32 PM
<Emma Schwarz>
Note that you need to be licensed for UAS Analytical Reporter to use Report Assistant from a Self-service app.
January 08, 2004, 04:24 AM
susannah
emma, what in the world is UAS Analytical Reporter??i've got MRE . do i therefore have 'UAS Analytial Reporter'??
January 08, 2004, 12:42 PM
<monte2000>
Susannah: UAS is a term we use internally for the most part. Sorry about the confusion. UAS (User Administration Services) is a part of Managed Reporting (MRE) so the short answer is, yes you've got it. Cool
January 09, 2004, 01:23 PM
Jen
Huh? The whole point of me wanting to call Report Assistant from a self serv app is because I don't have MRE (or UAS, whatever that is). I've gotten it to work in the past, with the links in the above posts, but I was only ever able to call one master at a time. But strangely, (or not so strangely), when I try running the same code that used to work, I get the following:
value for &edaapp is missing

Did someone pull the plug on me?? Wink
February 09, 2004, 11:32 AM
<Viswa>
Hai Jen

Can you send me the Code, which you have tried?
it would be of great help to us.

Thanks
Viswakanth
February 11, 2004, 02:37 PM
Jen
The only code you need is an href in your HTML pointing to the following link:

href="http://servername/ibi_apps/assist
/jsp/rpasstie.jsp?MasterFile=mastername&M
RcgiPrefix=http://servername/ibi_apps/WFServlet&IBIjavapath=
http://servername/ibi_html/javaassist&Re portFlag=0&Type=REPORT&appserverdirectory=/ibi_apps/assist/
jsp&IBIApp=appname" target=_blank

Good luck!
Jen

This message has been edited. Last edited by: <Mabel>,
February 16, 2004, 10:32 AM
<Viswa>
Hai Jen

Is this the URL you are trying to say

[URL]http://serverip/ibi_html/javaassist/
jsp/assist/jsp/rpasstie.jsp?MasterFile=c
ar&MRcgiPrefix=http://serverip/ibi_html/
javaassist/jsp/WFServlet&IBIjavapath=http://
serverip/ibi_html/javaassist&
ReportFlag=0&
Type=REPORT&appserverdirectory=/ibi_html/
javaassist/jsp/assist/jsp&IBIApp=test"]
[URL=http://serverip/ibi_html/javaassist/
jsp/assist/jsp/rpasstie.jsp?
MasterFile=car&]
[URL=http://serverip/ibi_html/javaassist
/jsp/]http://serverip/ibi_html/javaassist/jsp/[/URL]
assist/jsp/rpas....jsp?MasterFile=car&[/URL]
MRcgiPrefix=http://s
erverip/ibi_html/
javaassist/jsp
/WFServlet&IBI
javapath=http://serverip/ibi_html/ja vaassist&ReportFlag=0&Type=REPORT&
appserverdirectory=/ibi_html/javaassist/jsp/
assist/jsp&IBIApp=test"
[/URL]

I am trying to use CAR file, which is under ibi/apps/test folder.
When i executed the abovesaid url,i just got "page canot be displayed".

I am using WebFocus 521.
Please let me know is anything needs to done.

Thanks
Viswakanth

This message has been edited. Last edited by: <Mabel>,
February 18, 2004, 03:37 PM
Jen
Viswa,
Try using the exact syntax of the link I posted, except replace servername with the name of your WF server where the car file resides, mastername with car, and app_name with the name of your application where the car file resides. If that doesn't work, then I am out of ideas. We are also using 521.