SSRS Shared data set filters

• ammit.it2006

  Ten Centuries

  Points: 1280

  More actions

  December 26, 2017 at 10:41 pm

  #334175

  Hi,
  We are working on SSRS 2017 and my organization has fixed the Data Source and Data Set.
  These 2 are Shared mode and further we have set the filters on them as per each report data.

  When we are creating the dataset for a specific report and applying filters using the Shared Dataset then we have limitations like we are able to put the condition on any column based on (=,<>,like IN etc.)
  But we have a situation like
  AND (Column1='xyz' and Column2<>'ABC' or Column1 = '123')
  and ........... some other conditions.
  Basically, it's a migration project and we are stuck because we are not able apply this condition in SSRS while creating a dataset from a Shared data set.

  Kindly help,

  Please let me know if need more information.

  Regards,
  Ammy

• Thom A

  SSC Guru

  Points: 99126

  More actions

  December 27, 2017 at 2:07 am

  #1973549

  You can apply filters to Tablixes and Matrices as well. If you can't, for whatever reason, filter your dataset filter on the object.

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk