Using MS SQL Server Stored Procedure in Crystal Report

[ychhuong]

I have a stored procedure(MonthlyReport(@month INT)), then i want crystal report use this stored procedure by assign the parameter @month value. I have problem in setting parameter value in vb.net. Can one give me an example.

[amitpatel]

hi,
if u r using stored procedure then use the following code
Dim frm As New DailyReport --here i am passing two date values to the report
CRV.Visible = True
frm.SetParameterValue("@FDate", DTPFrom.Value)
frm.SetParameterValue("@TDate", DTPTo.Value)
CRV.ReportSource = frm
CRV.Show()