CR Logging into SQL Server **Resolved**

[Mark Gambo]

I created a simple CR 8.5 report for my application. When I was setting up the report I typed in the user name and password for a database in SQL Server. But when I run the program I receive messages that tell me that I am not logged into the server. Here is the code from form1:

Dim Report As New CrystalReport1
 
Private Sub Form_Load()
Screen.MousePointer = vbHourglass
CRViewer1.ReportSource = Report
CRViewer1.ViewReport
Screen.MousePointer = vbDefault
 
End Sub
 
Private Sub Form_Resize()
CRViewer1.Top = 0
CRViewer1.Left = 0
CRViewer1.Height = ScaleHeight
CRViewer1.Width = ScaleWidth
 
End Sub

What do need to add to my code inorder to log into the server so that I can display my report?



Thanks

[Mark Gambo]

Bump

[brucevde]

Doesn't the CrystalReport1 object contain Username and Password properties?

[Mark Gambo]

Bruce,
Thanks for the reply, but I was not able to find a UserName nor a Password Properties. What would the format of the property be?

[brucevde]

What is CrystalReport1? Is it not the Crystal OCX? What about a Connection property.

[Mark Gambo]

Bruce,

I figured it out and here it is:

Report.Database.Tables(1).SetLogOnInfo <Server Name>, <Database Name>, <User Name>, <Password>

Thanks for your help