Open Impromptu web report through url

[bectn]

I need to open an Impromptu web report and pass in a value for a prompt from a .Net application. I would prefer to do it using a URL if possible. Does anyone know if this is possible?

thanks,
Rebecca

 

[Sagae]

There is a great thread in the history that should be able to help you.

http://www.tek-tips.com/viewthread.cfm?SQID=633026&SPID=401&newpid=401&page=1

The problem I am having is this works great as long as you supply the ADMIN login and password. I don't really want that password floating around. I cannot get it to work with a user's id and password yet.

 

[bectn]

Thanks! That is exactly what I'm trying to do and it almost works! Unfortunately, I think I have the same problem as you because my userid and password don't work. I don't have the admin login to try. If I leave out the userid and password, it comes up and asks for the user class. Will it not do that if an admin userid/password is provided?

Rebecca

 

[DoubleD]

I believe Admin will assume Root User Access and run fine. The reason you need to supply a UserId and Password is two reasons:
1. IWR needs to know if you have access to execute the report.
2. IWR needs to know your Userclass in case there is Userclass security built into the catalog.

Pain is stress leaving the body.

DoubleD

 

[Sagae]

DoubleD,

Thanks for taking the time to reply. I am getting frustrated with this. lol
I understand that I need a password, I just don't want it to be the Cognos Admin id and password.

In my current case, I only want to view a PDF of a scheduled report. User class only has Read, although I have also tried Execute to get the URL to complete, but it still does not work with a typical user's id & password.

You think it is Root User access that is the key. How else could I give that access to a user?
I have gone into Access Manager and changed the membership of userclass "user" and added Root userclass and Index Admin. It still does not work. I am missing some small but critical connection setting.

Thanks a million,
Mary

 

[DoubleD]

I beliebe the URL for the PDF of the scheduled report would be changing each time you run the report, since it's creating a new document. Not sure how you would adjust for that.
Have you tried passing the appropriate UserClass in the URL?

I don't have a test environment available to me right now, so I don't think I can dig too much deeper into it. Sorry I'm not able to be any more help. Hope you're able to find an answer.

Pain is stress leaving the body.

DoubleD

 

[bectn]

I've tried passing the userclass in the url, but i still have to select it when the page opens. I used ucl=public. "ucl" is the paramter name i found in an example on the cognos support site and "public" is the userclass that has permissions to open the report.

another thing i need to do is pass a paramater in the url string. any ideas on that?