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
2 Replies
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
ArshadPosted Feb 8, 2010, 12:01 PM
Hi there,
please use the below java script function while onclick of check box
function EnableandDisable(){
if (document.getElementById("chkboxID").checked==true){
document.getElementById("dropdownlist1ID").disabled=true;
document.getElementById("dropdownlist2ID").disabled=true;
}
else{
document.getElementById("dropdownlist1ID").disabled=false;
document.getElementById("dropdownlist2ID").disabled=false;
}
}
Regards,
Arshad
romelevansPosted Feb 7, 2010, 10:54 AM
-Romel Evans