Report Viewer: UserID and Pwd prompt

[jmeckley]

I have installed Crystal Reports 8 on my local machine and installed the hotfix for the crystal report viewer.

The hotfix solved my previous issue of users not being able to view reports without crystal on their own machines.

Now I have a new issue. Users, including myself are constantly being prompted to enter their username and password. No combination will work. Users are continually prompted until they hit cancel and the report viewer is empty.
[tt]
1. My reports are located in a sub directory of the virtual directory.
2. The reports use an ODBC connection to access the datasource.
3. The datasource is a stored procedure on SQL Server 2000.
4. Here is an example of the URL for my reports
Response.Redirect("reports/newbusinessreport.rpt?user0=rptvwr&password0=rptvwr&promptonrefresh=0&prompt=" & cboIssue.SelectedItem.Value)
5. The username and password passed in the URL only has access to view report information, so I know the permissions are correct. The user is a sql server user not a domain user
[/tt]
Thank you for your assistance

Jason Meckley
Database Analyst
WITF

 

[pgtek]

Hi

this happens if the password is not pass to the querry

what interface are you using to get these report on the web

cheers

pg

pgtek

 

[pgtek]

hi
you can read this article also

http://support.businessobjects.com/library/kbase/articles/c2011281.asp

cheers


pgtek

 

[jmeckley]

I am use the crystal report viewer to view my reports. users can access these reports by clicking on links within my asp.net application.

here is an example of on of the links:
[tt]Response.Redirect("reports/newbusinessreport.rpt?user0=rptvwr&password0=rptvwr&promptonrefresh=0&prompt=" & cboIssue.SelectedItem.Value)[/tt]

The reports datasource is a stored procedure on Sql Server 2000. I use and ODBC connection between the report and datasource.

I do not have any code about linking tables, and passwords and such. I thought all of this was handled by the CRV.

This method worked before I installed the hot fix for crystal 8.0. I installed the hot fix to resolve another problem with users not being able to load CRV without having crystal reports developer 8 on their local machine.

Jason Meckley
Database Analyst
WITF