SSRS Shared data set filters

SSRS Shared data set filters

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.

Please always remember to encapsulate your code in IFCode Markup. For example [code=sql] [/code].Click here to read Jeffs Guide on how to post SQL questions, and get swift and helpful answers from the community