Ever run into this issue where you can’t save a report you’re editing in the report builder?
“Failed to save report (report server URL). The sortExpression Expression for the grouping refers to the field ‘ProductName’ Report item expressions can only refer to fields within the current dataset scope’
This is a REALLY irritating one. It happens when you edit a copy of one of the in-box SCCM reports and change the columns being returned. Without us knowing it, there are a lot of settings customized that allow us to click on the top of each column to sort the rows based on our preferences.
When we change the columns returned in an apport, we need to also update the header textbox for each column.
To fix this, right click up here, and go to interactive sorting and click each <<Expr>> box, then choose’Text Box Properties’
And go to Interactive Sorting…
View original post 105 more words