How to generate crystal report using stored Procedure?

Venkat Govind

11y953.NET

Hi I want Generate crystal Report Below Query,

select wf.WorkforceId,WorkforcePhoto,BarcodeId,FirstName,wf.Age,wf.DOB,wf.LastName,v.VendorName,wf.SubConFlag,wf.SafetyFlag,

MediFalg,TraiFlag,IRFlag,Mobile,Gender,BloodGroup,PermanentAddress,NextofKin,(CONVERT(VARCHAR(20),wf.ValidFrom,105)

+' to '+CONVERT(VARCHAR(20),wf.ValidTo,105) ) as Validity,EmgContactNo,ValidFrom, 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

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ravi Kumar11y ago
Accepted answer
hi
check the fallowing code.

----- stroed procedure------
create procedure usp_Procedurename
@input1 nvarchar(50)
begin
select wf.WorkforceId,WorkforcePhoto,BarcodeId,FirstName,wf.Age,wf.DOB,wf.LastName,v.VendorName,wf.SubConFlag,wf.SafetyFlag,
MediFalg,TraiFlag,IRFlag,Mobile,Gender,BloodGroup,PermanentAddress,NextofKin,(CONVERT(VARCHAR(20),wf.ValidFrom,105)
+' to '+CONVERT(VARCHAR(20),wf.ValidTo,105) ) as Validity,EmgContactNo,ValidFrom, 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();
}
Ravi Kumar11y ago
design value means
Mohammad Aman11y ago
Go through given link and read article u will find ur solution
Venkat Govind11y ago
I created stored procedure your given format I dont know how to design value from stored procedure
Venkat Govind11y ago
I created stored procedure your given format I dont know how to design value from stored procedure
Mohammad Aman11y ago
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.