Hi, I have 20 filters in the report,Is it possible to group some of the filters in one like for example: I have Customers filters and it has toggle option in it , when i expand the toggle then all the filters regarding the customer,product, sales will appear -Customers -Product -Sales CustomerID ProductID SalesID CustomerName ProductCategory SalesMan ProductSubCategory Like the above format can we achive in SSRS?

Hi, This kind of feature is not available in SSRS. Perhaps you can reduce the number by creating a hierarchical filter one for Customers, One for Product and the other for Sales. HTH, Ram

can you explain in brief with example

Hi, What is the data source for your reports. If its SSAS then you need to create separate hierarchies one for Customer (ex: Customer Hierarchy) , one for Products (Product Hierarchy) and one for Sales (Sales Hierarchy) in SSAS and refer these hierarchies in your report parameter section in the report designer. HTH, Ram

my data source is pointing to data base , we are using the ssas cubes ....may be in future we will going to SSAS. so is it not possible without creating the cube?

Hi, This is not possible if you are using a SQL Server DB as a data source. Ram