Enter Parameter Prompt

32 Views

Good dayfriends.

I badly need your assistance.

I am working on vb.net 2013 project with MySql database. I have reports created with Crystal report. I used dataset as my report source

Alll my reports work fine except one. I created the two crystal based date parameters (dt and dt1) to filter records that occured between the two dates.

Even though, I provide values for the parameters via a form, the report prompt me to enter values for the parameters.

Please find code block for displaying report below.

Thanks so much for your usual assistance

ElseIf mintSelectedReport = ReportType.SalesByDateDue Then

ds = New db_asfDataSet

datPmt = New db_asfDataSetTableAdapters.get_all_pmtsTableAdapter

datPmt.Fill(ds.get_all_pmts)

Dim rpt As New pmt_due_dt

rpt.SetParameterValue("@dt", dt)

rpt.SetParameterValue("@dt1", dt1)

rpt.SetDataSource(ds)

CrystalReportViewer1.ReportSource = rpt