[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1199
  • Last Modified:

Phantom expressions in SSRS

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?

1 Solution
ValentinoVBI ConsultantCommented:
Given your explanation, trying to solve through questions seems like a tough thing.  So, could you upload the RDL?  I'll then try to find out what's going on.

(before uploading, remove any sensitive parts if needed)
Nico BontenbalCommented:
You could right click the report in the Solution Explorer and choose 'View Code' from the menu. There you can search for the terms mentioned in the error message, 'Result' in your case. This will show you where the expression is used.
Be careful changing the xml, you might damage your report. Make sure you have a back up.
jdallen75Author Commented:
Forgot about that option - thanks.

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now