Another RS newbie here, so please excuse me if this one's obvious!
I'm modifying an existing report with several datasets and I've added a new one (Territory). I want to filter this dataset to a single row using a field from another dataset - when I try this is get:
The filter value expression for the data set ‘Territory’ refers to the field ‘CustomerID’. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope.
Can anyone show me a workaround for this - thanks in anticipation.
I'm modifying an existing report with several datasets and I've added a new one (Territory). I want to filter this dataset to a single row using a field from another dataset - when I try this is get:
The filter value expression for the data set ‘Territory’ refers to the field ‘CustomerID’. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope.
Can anyone show me a workaround for this - thanks in anticipation.