Crystal Reports Blank Report

Message

   Hi

The crystal report I have works fine when I run it from crystal reports application. But when I do this by code , it gives me a blank report. I don't know why.

The crystal report has one SQL and one OLD DB (ADO) connection.

Here is the code I use to call the report from a VB application.

Private Sub UserForm_Initialize()

    Dim crxApp As New CRAXDRT.Application

    Dim cr As CRAXDRT.Report

    Set cr = crxApp.OpenReport("C:\Report.rpt")

    cr.RecordSelectionFormula = "{Customers.Name} = '" & frmReport.NameList.Text & "'"

    cr.Database.Tables(1).ConnectionProperties("User ID") = "sa"

    cr.Database.Tables(1).ConnectionProperties("Password") = "password"

    crViewer1.ReportSource = cr

    crViewer1.ViewReport

End Sub

I am passing the SQL user name and password here. 

I am not passing OLE DB historian source username and password.

The OLD DB historian information is used in a sub report.

The report used to work well but don't know calling from VB creates a problem.

Sometimes I get log on error like "API Error" Invalid username and/or password" from crystal viewer informational message box.

Let me know if i m missing something ?