vaquas khan

vaquas khan

  • NA
  • 45
  • 0

crystal report with Stored procedure Parameter

Jan 6 2010 5:50 AM
how can i use stored procedure to build the Crystal report  i also want to my parameters aspx page separate from the ReportViewer  ASPX page....

i am using below procedure...


ALTER proc [dbo].[EmployeeDetails]
@FromDate datetime,
@ToDate datetime,
@Id int
as
SELECT     TOP (100) PERCENT dbo.Employee.FirstName, dbo.Employee.LastName, dbo.Employee.EmployeeID, dbo.Area.Addressline1, dbo.Area.Addressline2, 
                      dbo.Area.City, dbo.Area.Country, dbo.Area.Street, dbo.Area.ZipCode, dbo.SalaryDetails.SalaryType, dbo.SalaryDetails.BasicSalary, 
                      dbo.SalaryDetails.StartDate
FROM         dbo.Area INNER JOIN
                      dbo.Employee ON dbo.Area.EmployeeID = dbo.Employee.EmployeeID INNER JOIN
                      dbo.SalaryDetails ON dbo.Area.AreaCode = dbo.SalaryDetails.AreaCode
where dbo.SalaryDetails.StartDate between @FromDate and @ToDate
and dbo.Employee.EmployeeID=@Id 
Order by dbo.Employee.FirstName

please help me....