[hopia1020]

I have a dataset, in that dataset I have a query:

SELECT        ID, Name, Price
FROM            tblItems
WHERE        (ID = @Param1)

I design the report already using the said dataset. I'm trying to generate the report, but i got an error message that the source of the report is invalid. Here is my code on my btnGenerateReport.

Dim cryRpt As New ReportDocument
cryRpt.Load("location of my.rptfile")

Dim DA As New DataSet1TableAdapters.tblTransactionDetailsTableAdapter
Dim DS As New DataSet1.tblTransactionDetailsDataTable
        ReportViewer.CrystalReportViewer1.ReportSource = DA.Fill(DS, txtID.Text)
ReportViewer.CrystalReportViewer1.Refresh()
ReportViewer.Show()

What's wrong with my codes? Please help me. Thanks

This post has been edited by macosxnerd101: 07 February 2012 - 11:01 AM
Reason for edit:: Please use code tags

[nK0de]

try adding this, rptDataSource being the data source of the report.

cryRpt.SetDataSource(rptDataSource)

This post has been edited by nK0de: 07 February 2012 - 11:10 AM

[hopia1020]

nK0de, on 07 February 2012 - 11:07 AM, said:

try adding this, rptDataSource being the data source of the report.

cryRpt.SetDataSource(rptDataSource)

I tried it and I got an error message, "The data source object is invalid".