RE: 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()

      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

      User Rating: Be the first one !
      Add Comment
      1 Answers

        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.