SSRS Invalid Object Name on ARForm

[ckrusen (Calvin Krusen)]

For others that might end up here, a well known problem with the ARForm RDL is that the dataset expression is longer than the textbox that you edit it in. This causes the expression to get truncated.

EDIT

It is the OrderAck RDL that has a notoriously long query expression.

Broken OrderAck Report

The OrderAck report has a notoriously long Query Expression. So long that it can sometimes exceed the max length allowed by the Report Builder’s editor. So just opening the Query Expression to view it, may not load the entire expression. Then if you use the Ok button to close it, it might get updated with the truncated query. This probably didn’t happen to you. But has to other people (after they’ve made earlier edits to it). The steps to modify the built-in report are: Duplicate the rep…