How to generate crystal report using stored Procedure?

Question

Hi I want Generate crystal Report Below Query select wf.WorkforceIdWorkforcePhotoBarcodeIdFirstNamewf.Agewf.DOBwf.LastNamev.VendorNamewf.SubConFlagwf.SafetyFlag MediFalgTraiFlagIRFlagMobileGenderBloodGroupPermanentAddressNextofKin(CONVERT(VARCHAR(20)wf.ValidFrom105) +' to '+CONVERT(VARCHAR(20)wf.ValidTo105) ) as ValidityEmgContactNoValidFrom ValidTo from mstr_workforce as wf inner join mstr_vendor as v on v.VendorCode=wf.VendorCode inner join workforce_photo as wp on wp.WorkforceID=wf.WorkforceID where wf.WorkforceId=@Input1 above selected query i Created Stored Procedure the Procedure Name is ViewId i cant Get selected variable in database Filed Export How can I do that Report Regards Venkat

Ravi Kumar · Answer

hi check the fallowing code. ----- stroed procedure------ create procedure usp_Procedurename @input1 nvarchar(50) begin select wf.WorkforceIdWorkforcePhotoBarcodeIdFirstNamewf.Agewf.DOBwf.LastNamev.VendorNamewf.SubConFlagwf.SafetyFlag MediFalgTraiFlagIRFlagMobileGenderBloodGroupPermanentAddressNextofKin(CONVERT(VARCHAR(20)wf.ValidFrom105) +' to '+CONVERT(VARCHAR(20)wf.ValidTo105) ) as ValidityEmgContactNoValidFrom ValidTo from mstr_workforce as wf inner join mstr_vendor as v on v.VendorCode=wf.VendorCode inner join workforce_photo as wp on wp.WorkforceID=wf.WorkforceID where wf.WorkforceId=@Input1 end ------------------ c# code ------------------------- ReportDocument MedicalReport = new ReportDocument(); DataTable dt = new DataTable(); SqlDataAdapter da1 = new SqlDataAdapter(usp_Procedurename con); da1.SelectCommand.CommandType = CommandType.StoredProcedure; da1.SelectCommand.Parameters.AddWithValue(@input1 textbox1.text); dt.Clear(); da1.Fill(dt); if (dt.Rows.Count > 0) { MedicalReport.Load(Server.MapPath(ReportName.rpt)); MedicalReport.SetDataSource(dt); CrystalReportViewer1.ReportSource = MedicalReport; CrystalReportViewer1.DataBind(); }

Mohammad Aman · Answer

Go through these links .. i hope it will help you. http://www.aspsnippets.com/Articles/Create-Crystal-Report-using-Stored-Procedure-in-ASPNet-with-C-and-VBNet.aspx OR https://www.youtube.com/watch?v=imEvvm2FBXY Accept it as a correct ANS.

Ravi Kumar · Answer

design value means

Mohammad Aman · Answer

Go through given link and read article u will find ur solution

Venkat Govind · Answer

I created stored procedure your given format I dont know how to design value from stored procedure

Venkat Govind · Answer

I created stored procedure your given format I dont know how to design value from stored procedure