error msg

[EyeTalion]

not sure why I'm getting this error msg, I have no NULL values being passed...


An unhandled exception of type 'System.NullReferenceException' occurred in pcms.exe

Additional information: Object reference not set to an instance of an object.

It bombs on the bold line...

Dim cmdView As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter("select purchase_date,credit_card_no,vendor_name,transaction_amt,sales_tax_amt,status_ind from pcms.pcms_pcard_transaction_header where purchase_date between TO_DATE('" & tranPeriod & "','mm/dd/yyyy') and TO_DATE('" & tranPeriodEnd & "','mm/dd/yyyy') ", objCon)
        ds = New DataSet()
        cmdView.Fill(ds, "cards")
 
        Dim oRpt As CrystalReport1 ' create new report object 
        [b]oRpt.SetDataSource(ds)[/b]
        CrystalReportViewer1.ReportSource = oRpt

[Cander]

Dim oRpt As CrystalReport1 ' create new report object


you comment says create new report, but you didnt use the New keyword.

[EyeTalion]

good eye...that did it