I'm getting an error when I try to preview a report in SSRS:
The SortExpression expression for the tablix "Tablix4" refers to the field 'Result'.
If I select Tablix4 in design mode, and click on Properties, under Sorting there is NOTHING LISTED. Even if I add the sort criteria I want (eg: RowNum), I get the same error message.
Note that I spawned this report from another: I copied the .rdl, renamed the copy, and imported it into the SSRS project as an existing item. ('Result' was a valid field in the original dataset, which has since been updated, and no longer contains a 'Result' field).
I've seen phantom error messages like this before, and it is a pain to clean up. Any suggestions how to do this cleanup efficiently?