cancel
Showing results for 
Search instead for 
Did you mean: 

Enter Parameter Prompt

paul_aziz
Explorer
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member188030
Active Contributor
0 Kudos

Could you try below code..

  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.SetDataSource(ds)

rpt.SetParameterValue("@dt", dt)

            rpt.SetParameterValue("@dt1", dt1)

            CrystalReportViewer1.ReportSource = rpt

Thanks,

Bhushan

Answers (1)

Answers (1)

paul_aziz
Explorer
0 Kudos

Thanks so much. It worked like magic. I am very grateful. Have a blessed day