VB 2005 and Cystal reports

[aerialz666]

Hi, im making a crystal report for my program and after setting it up and running it, it then asks me to login to the database where it is getting the data from, what codes should i add in order to skip this login prompt everytime i run the crystal report / form? thanks im using 05.

[Asgorath]

Hi.
Here's how to avoid login information prompt

Imports CrystalDecisions.CrystalReports.Engine
Imports CrystalDecisions.Shared
 
Dim crDatabase As Database
Dim crTables As Tables
Dim crTable As Table
Dim crTableLogOnInfo As TableLogOnInfo
Dim crConnectionInfo As ConnectionInfo
 
Dim crReportDocument As New CrystalReports1
crConnectionInfo = New ConnectionInfo
With crConnectionInfo
    .ServerName = "Ares"
    .DatabaseName = "Dinefer"
    .UserID = "bb"
    .Password = "aa"
End With
crDatabase = crReportDocument.Database
crTables = crDatabase.Tables
For Each crTable In crTables
    crTableLogOnInfo = crTable.LogOnInfo
    crTableLogOnInfo.ConnectionInfo = crConnectionInfo
    crTable.ApplyLogOnInfo(crTableLogOnInfo)
Next
 
crReportDocument.PrintOptions.PaperOrientation = PaperOrientation.Landscape
crReportDocument.PrintOptions.PaperSize = PaperSize.PaperA4
 
 
CrystalReportViewer1.DisplayGroupTree = False
 
CrystalReportViewer1.Zoom(100)
CrystalReportViewer1.ReportSource = crReportDocument

[shakti5385]

Read crystal report tutorial at my signature!