Passing the log-on credentials in the URL

[Former Member]

Hi all,

http://servername/businessobjects/enterprise115/sap/InfoView/scripts/openDocument.aspx?sDocName=

This is the format of the URL of my Crystal report that was published in SAP Enterprise portal.

I wanted to pass the SAP BW credentials along with the URL, so that on opening the URL I will not be asked for any log on details and it directly opens the Crystal report.

Kindly help me on this issue..

Thanks

Eswari.B

[Former Member · Accepted solution]

Hi Eswari,

See if bypass.asp is configured in your server. If it is configured you can use 'bypass.asp' instead of 'opendocument.asp'. Using bypass.asp allows you to bypass the user login credentials screen.

Regards,

Sanjay

[Former Member · Accepted solution]

Hi,

And also I read this information in an article.

" If you want to call the report directly from a Web page, you will also need to provide the login to the Crystal Enterprise APS. You can include all this in your URL with

http://server/folder/viewrpt.cwr?

id=134&apsuser=guest

&apspassword=&apsauthtype=secEnterprise.

The id is the number of the report object in the Enterprise database, and on Crystal Enterprise Standard you only have a Guest and an Administrator user. "

I tried with this option too and failed.

Similarly, is there any other way for passing the SAP BW Details in the URL.

Thanks

Eswari.B

[Former Member · Accepted solution]

Hi,

For passing SAP BW details, go to report database configuration options in CMC. There you can give the logon information and remove option "Prompt user for logon" and set "Use this information whenever report is run" option.

That way you need not enter the data source details everytime the report is refreshed.

Regards,

Sanjay