Filtering the reports based on two parameters and Parameter should satisfy individually
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
Ex: i created X , Y , Z Filters
a. 'X'(It may Text Box and DropDown list) Filter should satisy itself when user click on View Report (when kept Y,Z as empty).
b. 'Y'(It may Text Box and DropDown list) Filter should satisy itself when user click on View Report (when kept X,Z as empty).
c. 'Z' (It may Text Box and DropDown list) Filter should satisy itself when user click on View Report (when kept X,Y as empty).
d. 'X' and 'Y' should Filter the report when Z is empty.
e. 'Y' and 'Z' should Filter the report when X is empty.
As i am new to sharepoint i am not able to locate the location for Query, Now i am just able to get the reports based 2 or 3 data sets, and Filtering the Report based on two parameters
For this i have a idea about query using with IF and elseif condition.
But i dont know in Report Builder 3.0 where should(Location) i write the Query for this type of reports.
Please any body help me for this query and query location, bcz i have to create so many Reports as like this type.
Thanks,
Ali
MD.Liakath ali
December 11th, 2010 2:03am