Hi

Some users in my organization developped their own reports and as they are familiar with Excel and its feature to pull data using web query they would to use it to launch this report and get data directly in Excel.
Could you please help me and tell me what kind of information I should put in and HTML file to make them bypass the login page to MRE and run the report.

Any example or help will be greatly appreciated.


Thanks.

If things are in MRE, you probably shouldn't be trying to "bypass" the login. MRE holds reports and objects in a (somewhat) secure user-based environment so that only authorized users get to the reports and objects they have been given access to. If they are creating their own queries, this is the completey wrong approach. If they are just running report (dynamic prompting or launch pages) you want to look into some "self-service" reporting.

Hi Lee,

First of all thanks for you reply.
I agree we should not bypass the MRE authentication process.
But What I would like to achieve is to create an HTML launcher for those reports that will include all the parameters to authenticate to MRE and also to locate the domain and the fex file to run.
Do you think it is possible?

Thanks in advance.

This is an example URL that calls MRE program bid1.fex in Standard Reports folder Test in Domain francism:

http://server-name/ibi_apps/WFServlet?IBIMR_action=MR_RUN_FEX&IBIMR_sub_action=MR_STD_REPORT&IBIMR_fex=app/bid1&IBIMR_folder=#testyrsaxhlg&IBIMR_domain=francism/francism.htm&IBIMR_Random=34343434&IBIMR_user=fmariani&IBIMR_pass=password

read this article
and/or
read the chapter in the manual on webqueries.
What version are you running (update your signature please); the new 76 has a webquery addin to excel so your users can build their own queries directly from excel.

Hi Susannah,

Thanks for your help.

We are using Webfocus 7.6.1.

Where can find the webquery addin?.

Regards.

i wish i could tell you, Majid, but i don't know. its an 'extra cost' item, and i just saw it demonstrated at Users Group in nyc. Its a little button appearing in excel itself which opens up Report Assist. Pretty fabulously cool. So you should call your sales person and find out if you bought it. It comes in dev studio for free, i'm told, so that you can experiment.

You can, now, build a single query yourself starting from excel..there's a chapter in the manuals on that, even the version 5 manuals. You could build one for your users, and distribute that excel sheet. But this new feature lets them build their own.
Also, update your profile signature here on the point to include your system info.

Tech Memo (TM4649) is the appropriate reference to configure and use the Quick Data add-in. It is included in Dev Studio but requires a license for wide use.

Hi,

Thanks to all of you for the suggestions.

We are using webfocus 7.6.1 and I tried to run the URL sent by Francis after customizing it. But I got the following message:

Cannot execute the request. Please log into Managed Reporting.

The IBIMR_user is set correctly and also the IBIMR_pass.

Also I did the following:

I created a domain called francism with Standard Reports folder Test and fex file called bid1.fex and I am still getting :

Cannot execute the request. Please log into Managed Reporting.

If I succeed to run the fex file this way, I think this is what my users are looking for.

Thnaks to all of you.

quote:

Cannot execute the request. Please log into Managed Reporting.

The IBIMR_user is set correctly and also the IBIMR_pass.

Majid Jeddi,
I was having the same issue today with the same error message. You need to add &IBIMR_drill=RUNNID in addition to the user and pass values.

Here is the post where I found my informationhttps://forums.informationbuilders.com/eve/forums/a/tpc/...811098331#6811098331

Hi Nick,

This works perfectly. But I am having another issue: By removing the user and the password from the URL i was surprised to see myself able to run this URL from another machine and having data. This rise a security issue. doesn't it?
Do you have an idea why i am not asked to enter a login and a password?