Hi Friends, I am Ali, I need to create a Report with 3 to 4 parameters in Report Builder 3.0. 1. My report server configured with sharepoint integrated mode, and Created report with 3 paramenters. 2. here i need to get the report 4 or 5 types 1. Created 3 groups Academic_Year, Class, Section and 2. Created 3 Parameters Ac_year, Class, Section Requiremnts: a. 'Ac_Year'(It may Text Box and DropDown list) Filter should satisy itself when user click on View Report (when kept Class,Section as empty). b. 'Class'(It may Text Box and DropDown list) Filter should satisy itself when user click on View Report (when kept Ac_Year,Section as empty). c. 'Section' (It may Text Box and DropDown list) Filter should satisy itself when user click on View Report (when kept Ac_Year,Section as empty). d. 'Ac_Year' and 'Class' should Filter the report when Section is empty. e. 'Class' and 'Section' should Filter the report when Ac_year is empty. For this i worked like this: 1. Created 3 groups Academic_Year, Class, Section and 2. Created 3 Parameters Ac_year, Class, Section Please check the screen shots here http://picasaweb.google.com/mohammadliyakhatali4/Ali# I used Isnothing Funtcion Academic_Year-->Group Properties-->Filters-->Here =IIF((Isnothing(Parameters!Ac_year.value) and Not Isnothing(Parameters!Class.value) and Not Isnothing(Parameters!Section.value)) or (Isnothing(Parameters!Ac_year.value) and Isnothing(Parameters!Class.value) and Not Isnothing(Parameters!Section.value)) or (Isnothing(Parameters!Ac_year.value) and Not Isnothing(Parameters!Class.value) and Isnothing(Parameters!Section.value)), nothing, Fields!Academic_Year.Value) Operator as "=" Value as "=Parameters!Ac_year.Value" Class Group-->Group Properties-->Filters-->here =IIF((Isnothing(Parameters!Ac_year.value) and Isnothing(Parameters!Class.value) and Not Isnothing(Parameters!Section.value)) or (Not Isnothing(Parameters!Ac_year.value) and Isnothing(Parameters!Class.value) and Isnothing(Parameters!Section.value) or Not Isnothing(Parameters!Ac_year.value) and Isnothing(Parameters!Class.value) and Not Isnothing(Parameters!Section.value)), nothing, Fields!Class.Value) Operator as "=" Value as "=Parameters!Class.Value" Section Group-->Group Properties-->Filters-->here =IIF((Isnothing(Parameters!Ac_year.value) and Not Isnothing(Parameters!Class.value) and Isnothing(Parameters!Section.value)) or (Not Isnothing(Parameters!Ac_year.value) and Isnothing(Parameters!Class.value) and Isnothing(Parameters!Section.value)) or (Not Isnothing(Parameters!Ac_year.value) and Not Isnothing(Parameters!Class.value) and Isnothing(Parameters!Section.value)), nothing, Fields!Section.Value) Operator as "=" Value as "=Parameters!Section.Value" I Executed this report as per my requirments with default values. But i need to get the report with Available values. as i am fresher to sharepoint i am not able to speedup my work, its my target Please help me anybody Thanks, Ali MD.Liakath ali

Hi Ali, Could you please clarify "I Executed this report as per my requirments with default values. But i need to get the report with Available values"? Do you mean there are no available values for your report parameters? Or can't you see the report parameters on your report? If you select the available values for these parameter, the report will be excuted with these report available values. When the report is deployed on sharepoint, the parameter pane is placed at the right hand side. thanks, Jerry

Hi Ali, Could you please clarify "I Executed this report as per my requirments with default values. But i need to get the report with Available values"? Do you mean there are no available values for your report parameters? Or can't you see the report parameters on your report? If you select the available values for these parameter, the report will be excuted with these report available values. When the report is deployed on sharepoint, the parameter pane is placed at the right hand side. thanks, Jerry

Hi jerry, Thanks for giving reply, If i gave the Values in report parameter properties-->available values. When i run the report, first i selected Academic Year and clicked on View report here still Msg box asking for "Please select a value for the parameter 'Class' like this it is asking for select 3 parameters. I need to satisfy individually and based on two conditions, If i select Academic year and clicked on View report it should not ask anything here Report should be genrate depends on that Acadamic year parameter. Thanks, AliMD.Liakath ali