Need to add CMS authentication in the URL to open instance

[podi80]

Hi,

I want to open report instance using viewrpt.cwr (or any other way) from a client pc. I schedule report using java code on a CE10 server and instances were successfully created, but when I try to open it by passing the URL to the instance, it prompt for the user logon information for CMS server. Is there any way that I could include user login info in the URL. If any body has done this, I appreciate if you can give me some help.

here is my code:

String urlBase = "

http://rptserver/viewrpt.cwr?id="

+ oInfoInstance.getID() + "?";
//APS security
urlBase += "&aps=" + URLEncoder.encode(cmsName) + "&apsuser=" + URLEncoder.encode(user) + "&apspassword=" + URLEncoder.encode(password)
+ "&apsauthtype=" + URLEncoder.encode(cmsAuthType);

URL connection = new URL(urlBase);

But this still ask for the authentication.


Thanks in advance.

 

[Turkbear]

Hi,
the 3 aps... entries ( user, password, authentication) should handle the logging for CMS - are you certain they are passing the correct info( does the URL show the correct stuff) and is it calling the report you expect it to?
This works for our stuff ( Guest view-on-demand is set for this report):

[URL unfurl="true"]http://myserver/viewrpt.cwr?id=29069&apsname=Guest&apsauthtype=secEnterprise&init=actx&promptex-WORK_REQUEST_NO=12[/URL]

Are you actually being prompted for the database login info instead of the CMS ones?






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[podi80]

Hi,

Thanks for the reply, but 3 aps entries does not work for me for some reason. In your code apsname= Guest, I guess you mean here is the user name, not the apsname?. Is the ID you are passing is report id or instance id. I am passing instance ID. I am passing database loging in my code, so it is not prompting for database login. My instances are created without any problem. The URL shows the correct authentication infomation.

This is the error I get when I try to view the instance.

The error message returned is:

File C:\Program Files\Crystal Decisions\Enterprise 10\Web Content\Enterprise10\ePortfolio\en\viewrpt.cwr not found. [On Cache/Page Server: cmsname.pageserver]

I do not have viewrpt.cwr file on my pc, could this be the problem?. I guess this should not be on client pc.

Appreciate your help in this issue.
Thanks.