I just started working with SSRS, and figured out how to connect my MDX Query to fuel my report. I also figured out how to use a Matrix in order to have a repeating section. However, i need to have a matrix with repeating section, and in each section, i need to call a different DataSet. so.. Matrix1 would be based off DataSetA. in a cell of Matrix1 i would have a Expression, which calls DatasetB, using a value from DataSetA as parameter. so my expression from within a tablix cell is something like this: =First(Fields!MTD_Trades.Value, "DatasetB") is it possible to pass a MDX query filter (or where clause) using a parameter from this point? (something like this: (pseudocode)) =First(Fields!MTD_Trades.Value, "DatasetB") WHERE Fields!Where_Filter.Value something along these lines.. where the MDX WHERE section is dynamic based off another query UPDATE - solution explanation here is an example of what i am doing: Let's say the application is based on air traffic and the business user here is some aviation authority person. I will give that person a UI that will let them define the slices they want to see. For example they can come in, and create n slices (i.e. International Flights, Flights leaving US, Flights Arriving After Midnight, Flights with 50+ passengers... n). As you can see, they will have the freedom of adding any filters they wish to each slice. Then based on their actions (using GUI), i will generate the necessary MDX queries (one for each slice). My challenge here is to create a SSRS report that will show a separate line for each one of those slices (1-n). Hope that helps in understanding my conundrum. The first part of the query will be the same for each slice (# of flights), but the WHERE section will be different and dynamic for the report.

Hi squarewave24, According to your description, you would like to add a dynamic filter on a tablix cell, right? Please correct me if my understanding is wrong. We could add a filter to dataset, data region, or group, but we could not add a filter to a tablix cell. I assume we need to add a filter to the tablix, in this case, we can create a dataset for the parameter, and then using the parameter in filter expression. For more information about it, please refer to the following article, How to: Add a Filter (Report Builder 3.0 and SSRS): http://msdn.microsoft.com/en-us/library/ee633648.aspx If you have any question, please feel free to ask. Forum Support Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.