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....