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

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

Other recent topics Other recent topics