How to generate crystal report using stored Procedure?

Nov 4 2015 1:58 AM

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

Answers (6)