Hello, I am in need of help big time.
\r\n
\r\nI have am using Visual Studio 2010 and Crystal Report 10.
\r\n
\r\nThe problem that I am incounting is that I am unable to retreive data from more than one table from a MySql database. I have been stuck on this for too long and need to hjump the hurdle.
\r\n
\r\nI am using a MySql connection string, a dataset and a crystal report which is based on the dataset.
\r\n
\r\nThe main error that I am having is, the browser opens and a form appears saying "The report you requetsed requires further information" With the Server name: DataSetPropertiesDetials, while the User name and Password fields are then enabled.
\r\n
\r\nI am guessing I am missing something in my code.
\r\n
\r\nWhen I retreive data from one table the report is fine, but when I try to use more than one table it throws the error.
\r\n
\r\nMy Code is below and also attached:
\r\n
\r\nImports System.Data.SqlClient
\r\nImports System.Configuration
\r\nImports MySql.Data.MySqlClient
\r\nImports CrystalDecisions.ReportSource
\r\nImports CrystalDecisions.Web
\r\nImports CrystalDecisions.CrystalReports.Engine
\r\nImports CrystalDecisions.Shared
\r\nPublic Class _Default
\r\n Inherits System.Web.UI.Page
\r\n Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
\r\n Dim con As MySqlConnection
\r\n
\r\n Dim rpt As New CrystalReport3()
\r\n Dim myReport As New ReportDocument
\r\n Dim myData As New DataSet
\r\n Dim cmd As New MySqlCommand
\r\n
\r\n Dim cmdUser, cmdProperty, cmdBranch As New MySqlCommand
\r\n Dim daBranch, daProperty, daUser As New MySqlDataAdapter
\r\n
\r\n con = New MySqlConnection()
\r\n
\r\n \'Connection String
\r\n con.ConnectionString = "Server=*****;Database=*****;UID=*****;Password=*****"
\r\n
\r\n Try
\r\n con.Open()
\r\n
\r\n cmdBranch.CommandText = "SELECT branch FROM tblbranch"
\r\n cmdBranch.Connection = con
\r\n daBranch.SelectCommand = cmdBranch
\r\n daBranch.Fill(myData)
\r\n
\r\n cmdProperty.CommandText = "SELECT ref, keys_held, key_no, keys_out, no_name, address_line1, address_line2,key_label FROM tblproperty"
\r\n cmdProperty.Connection = con
\r\n daProperty.SelectCommand = cmdProperty
\r\n daProperty.Fill(myData)
\r\n
\r\n cmdUser.CommandText = "SELECT known_name FROM tbluser"
\r\n cmdUser.Connection = con
\r\n daUser.SelectCommand = cmdUser
\r\n daUser.Fill(myData)
\r\n
\r\n myReport.Load("REPORT LOCATION")
\r\n myReport.SetDataSource(myData)
\r\n myReport.Database.Tables(0).SetDataSource(myData.Tables(0))
\r\n CrystalReportViewer1.ReportSource = myReport \'
\r\n Catch myerror As MySqlException
\r\n MsgBox(myerror.Message)
\r\n End Try
\r\n End Sub
\r\nEnd Class