• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1283
  • 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?

Thanks.
0
jdallen75
Asked:
jdallen75
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)
0
 
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.
0
 
jdallen75Author Commented:
Forgot about that option - thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

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