Filter Dataset based on results from another Dataset (& Data Source) RRS feed

  • Question

  • Is it possible in SSRS to filter a Dataset based on the output from another Dataset?

    Let me quickly explain:
    I have created a report in BIDS 2008 that has two Data Sources (one against Oracle and another against a SQLServer Data Warehouse).  I'm passing a parameter to my report that is used to do a lookup against my Data Warehouse to get a list of values and feed that as an "IN" filter to my Oracle Dataset.

    Monday, December 14, 2009 3:38 PM


  • May have just found the solution:

    Create a new (internal) Parameter (call it "Filter" or something) and set this parameter's default and available values to the Resultset from my Data WareHouse query.  Then modify the query for the Oracle Dataset to do an "IN (Filter)".

    • Proposed as answer by Kalman Toth Monday, December 14, 2009 3:57 PM
    • Marked as answer by Jerry Nee Monday, December 21, 2009 2:03 AM
    Monday, December 14, 2009 3:53 PM