Hi Guys! I have 3 parameters declared in my SP, what I want is though i am not supplying 1 of the parameter to SP it shud execute as usual, is it possible for me? Actually I am using this SP for my sql reports where i want to select parameters from drop down list. For example I have deptno and actno as parameters,if i am selecting deptno and actno it shud display only those reports, if i am selecting only deptno then it shud display reports of all actno under that dept. Can any one please help me regarding,Its damn urgent. Thanks.