Adding dymanic filters in reports with SSRS
SSRS report paramters doesn't support runtime selection of operations by default. For example: we want to let users filter data by checking any criteria that equals, not equals or contains any specified value. W e can achieve this by using ssrs expressions. Below is outlined a step-by-step guide to do this. Following is a snapshot of a simple cube to be used in this example: The cube contains orders data including two measures: quantity of products and dollars of orders. It has four dimensions, but for this example lets focus on the Product and Quality dimensions only. The aim is to create a report to view total dollars received from the orders per product quality for specific product categories . Before starting we need to create the reporting project using SSRS and then add the data cube as a shared datasource. I've also added a dataset using query designer. It includes Dollars as measures and Product Name, Category, Quality to group the measure va...