Skip to Content
May 13, 2015 at 01:50 AM

Enter Parameter Prompt


Good dayfriends.

I badly need your assistance.

I am working on 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


Dim rpt As New pmt_due_dt

rpt.SetParameterValue("@dt", dt)

rpt.SetParameterValue("@dt1", dt1)


CrystalReportViewer1.ReportSource = rpt