savilash
August 4th, 2005, 04:52 AM
hi all,
Please help me.i am working with crystal reports in one of my asp.net application.here i am using one existing report and the data sourceofthe report i am setting by executing one stored procedure and populating a dataset.Then i am assosiating the SetDataSource property of the report as he dataset.But unfortunatelt i am not able to show the data on the report instead it is the showing the default data that the report has previously.Also i have checked the "Discard Saved Data When Loading" property.
this is my complete cord........................
cmd = New SqlCommand("AXSP_LDLCLABSREPORT", con)
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add("@strPatIds", TextBox1.Text)
con.Open()
da = New SqlDataAdapter(cmd)
ds = New DataSet
da.Fill(ds, "result")
con.Close()
rpt.SetDataSource(ds)
rpt.Refresh()
CryReportViewer.ReportSource = rpt
Please Give me the solution or the suggestion that what should i do.
Thanking you
savilash.
Please help me.i am working with crystal reports in one of my asp.net application.here i am using one existing report and the data sourceofthe report i am setting by executing one stored procedure and populating a dataset.Then i am assosiating the SetDataSource property of the report as he dataset.But unfortunatelt i am not able to show the data on the report instead it is the showing the default data that the report has previously.Also i have checked the "Discard Saved Data When Loading" property.
this is my complete cord........................
cmd = New SqlCommand("AXSP_LDLCLABSREPORT", con)
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add("@strPatIds", TextBox1.Text)
con.Open()
da = New SqlDataAdapter(cmd)
ds = New DataSet
da.Fill(ds, "result")
con.Close()
rpt.SetDataSource(ds)
rpt.Refresh()
CryReportViewer.ReportSource = rpt
Please Give me the solution or the suggestion that what should i do.
Thanking you
savilash.