Crystal Report viewer question

[SandyB]

I'm trying to develop crystal reports for a VB.NET app. I created a report and added a crystal report viewer to my form in my app. When I run the app and open the form to display the report, a login screen appears to enter a password. Is there a way to by-pass this - i.e. code the user name and password in the viewer?

[Robby]

Where is the prompt coming from, Crystal or a database connection?

[SandyB]

I'm not sure. I think it's coming from Crystal because on the top of the login screen it says - Main report. I have another form that retrieves data from the database, but the connect string has all the info so the data is automatically retrieved when the form opens.

[pcPirate]

can you show the code of your crystal viewer form ?

 

pcPirate

[hog]

I vaguely remeber this happening to me once? I think there is a post on this site regarding it if you have a search...

[SandyB]

Thanks, hog - I did find some other postings on this issue. I will try the suggestions there.

[Robby]

I've had a prompt from Crystal when the connection to the DB was invalid, it asked for Server name and username/password, is this what you get?

[SandyB]

No - the prompt has the correct database name and userid and it is prompting for a password.

[SandyB]

In case anyone is interested, it was pretty simple:

 

VB:

 

Dim myReport As New CrystalReport1

 

myReport.SetDatabaseLogon("userid", "password")

CrystalReportViewer1.ReportSource = myReport

[pcPirate]

is that mean your problem is solved?

[SandyB]

Yes - but I do remember seeing a question about how to get rid of the logon screen when you have an embedded report. Not sure if that was solved. So far, I haven't needed to do that.