Hello
i have a problem in the foll code. I am trying to pass a sql query to a report(CRXI r2). But the dataset in the foll code returns null i suppose. the error message(inner exception) is given below..
Dim
odbcAdapter As New OdbcDataAdapter()
odbcAdapter.SelectCommand =
New Odbc.OdbcCommand(StrSql, OpenSQLConnection)
MessageBox.Show(odbcAdapter.SelectCommand.CommandText)
odbcAdapter.Fill(objds,
"testtable)
objReport.SetDataSource(objds)
objClsCrystalRptVw.ReportSource = objReport
error message:
{"Object reference not set to an instance of an object."}
can anyone help me