I have a few datasets in a report that have exactly the same structure. What I would like to build is one tablix and a parameter where the user selects which data to see. Based on this parameter, I would like the tablix use the appropriate dataset. However, when I create a tablix, I have to select a dataset and I can't put an expression there! Thanks for the suggestions!-

Hi Erik, Try this, 1. Create 2 tablix 2. Create report level parameter 3. Visibility Tab for each tablix should be value based on the parameter, something like this, = IIf ( Parameter!Filter.Value = '1', TRUE, FALSE ) -- for first Tablix = IIf ( Parameter!Filter.Value = '2', TRUE, FALSE ) -- for second Tablix Does that help you out? Thanks KumarKG, MCTS

Hi Kumar, thanks for your reply. I'm actually trying to avoid having multiple tablixes, because when anything changes, I'd need to change every tablix. Let me describe briefly what I'd like to accomplish: the facts are orders. I need to have an overview of how many orders were placed, received, processed and paid in certain months. All of these date fields are with a role-playing dimension in the orders-cube. The tablix has to show how many orders were placed per month, how many orders were received per month, etc. The easiest way is how you described it, to create 4 tablixes for this. Until so far I've managed to narrow it down to one dataset, but I'm not completely there. I've created an extra report parameter, and the value of this is used in the query (as an expression). The query works very well, however on the "Fields" tab of the dataset, the field source is displayed like this: <?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Time Placed].[Month].[Month]" /> When I'm able to make this "field source" also dynamic to replace the text in bold above to "received", "processed" or "paid" depending on what the user selects in that report parameter, then I think I'm there... any suggestions? Thanks!-

Hi Eric, According to your description, you would like to make "field source" dynamic based on what the user selects in report parameter, right? Please correct me if my understanding is wrong. I am afraid this behavior cannot be completed in Reporting Services right now. However, if you have any concern about this, please submit a feedback at http://connect.microsoft.com/SQLServer/Feedback and hope Microsoft improve this feature in the next service pack or product release. Thanks for your understanding. Thanks, Eileen