hi everyone,
i have a aspx page which contains 2 dropdownlist control and 1 checkbox . one Button..to filter data and display reports..
i use sql server views to displya the report in crystal report...
i want to when user checked the checkbox then two dropdownlist would be disable.....report display all records from database...other wise user select the value of dropdownlist and filter record display in crystalreport according to those selected value of dropdownlist ....
how can i implement these case.....please help me
my views is given below..........EmployeeDetails
SELECT 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