VB.NET – Crystal Report blank database

    I’ve created a simple report application that view our monthly payment. But when I click the button view. It prompts the Database Login.

    Server name: HAS VALUE

    Database: NO VALUE

    Login ID: HAS VALUE

    Password: HAS VALUE

    The problem is, the Database field is blank. But I’ve checked the SQL Database. The database is existing.


    Me.Text = "" & oCompany.CompanyName & " - Payment Schedule Report"
      
    Dim iCon As New System.Drawing.Icon(xPath & "\AppIcon1.ico")
      
    Me.Icon = iCon
      
    Me.WindowState = FormWindowState.Maximized
      ComboBox1
    .Text = "Choose Export Format"

       Dim oConnectInfo As New ConnectionInfo
      
    Dim oCRTableInfos As New TableLogOnInfos
      
    Dim oCRTableInfo As New TableLogOnInfo
      
    Dim oTables As Tables
      
    Dim oTable As Table

      cryRpt = New ReportDocument

      cryRpt.Load(xPath & "\Rpt\App_BuyerLedger.rpt")

       With oConnectInfo
      
    'MsgBox(oCompany.CompanyDB)
      
    .ServerName = "" & oCompany.Server & ""
      
    .DatabaseName = oCompany.CompanyDB
      
    .UserID = "" & oCompany.DbUserName & ""
      
    .Password = "p@ssw0rd"
      
    .Type = ConnectionInfoType.SQL
      
    End With

      oTables = cryRpt.Database.Tables
      
    For Each oTable In oTables
      
    'oCRTableInfo = oTable.LogOnInfo
      oCRTableInfo
    .ConnectionInfo = oConnectInfo
      oTable
    .ApplyLogOnInfo(oCRTableInfo)
      
    Next

      oCRTableInfos.Add(oCRTableInfo)

      oParameter()

      CrystalReportViewer1.EnableRefresh = True
      CrystalReportViewer1
    .LogOnInfo = oCRTableInfos
      CrystalReportViewer1
    .ReportSource = cryRpt
      
    'CrystalReportViewer1.Refresh()

    I've created a simple report application that view our monthly payment. But when I click the button view. It prompts the Database Login.Server name: HAS VALUEDatabase: NO VALUELogin ID: HAS VALUEPassword: HAS VALUEThe problem is, the Database field is blank. But I've checked the SQL Database. The database is existing. Me.Text = "" & oCompany.CompanyName & " - Payment Schedule Report"    Dim iCon As New System.Drawing.Icon(xPath & "\AppIcon1.ico")    Me.Icon = iCon    Me.WindowState = FormWindowState.Maximized   ComboBox1.Text = "Choose Export Format"    Dim oConnectInfo As New ConnectionInfo    Dim oCRTableInfos As New TableLogOnInfos    Dim oCRTableInfo As New…

    VB.NET - Crystal Report blank database

    Very Helpfull

    User Rating: Be the first one !
    Add Comment
    1 Answer(s)

      DB Client is Database Client.

       

      One way to check is open 32 bit ODBC administrator and you’ll see the clients you have installed:

       

       

      If the users PC doe snot have them installed the app is not going to find them and CR will not show or populate the connection info.

       

      Don

      Add Comment

        DB Client is Database Client.

         

        One way to check is open 32 bit ODBC administrator and you’ll see the clients you have installed:

         

         

        If the users PC doe snot have them installed the app is not going to find them and CR will not show or populate the connection info.

         

        Don

        Add Comment

        Your Answer

        By posting your answer, you agree to the privacy policy and terms of service.