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