How can we get reports based on parameters with Available Values ?
Hi Friends, I am Ali, I need to create a Report with 3 to 4 parameters in Report Builder 3.0 with Available values . 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 am able get the result with default values such as NULL . But i am not able to get the report with Available values. as i am fresher to sharepoint i am not able to speedup my work, Cant move forword untill resolved this, Thanks, Ali MD.Liakath ali
December 25th, 2010 11:10am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics