Thanks Paul, it does work like that but users are finding the solution a bit unstable.
We are getting errors when they try and bring certain other Data Items into the report, for instance:
They may drag in Country, Region and the prompted data item, but when they bring across a measure, an error occurs. also, sometimes when filtering the report errors crop up.
As a rule it is not an unstable package but when this new data item is used, we are finding that it is very difficult to get to the end of a report without an error.
The most common error is this: UDA-SQL-0358 Line 7: Syntax error near "like".
Any thoughts?
Stuart