SCCM Reporting – Can’t save a report

Ever run into this issue where you can’t save a report you’re editing in the report builder?

Untitled

“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’

Untitled

And go to Interactive Sorting.  You might notice that the value listed in the box is no longer relevant to the rows you’re returning in your report now.  (Happens to me ALL the time, I always find a good starting report, then save a copy and edit (it’s so hard to get the background looking pretty!))

Untitled
Click the drop down box and change the name to a valid column to fix this issue

Especially if you edited a built-in report, you’ll need to do this for the header of each column.  That means each of these guys:

Untitled

With this done, you should now be able to save the report again.

Advertisements

3 thoughts on “SCCM Reporting – Can’t save a report

  1. Garth Jones April 18, 2016 / 10:23 am

    This is one of the reasons why I recommend that you preview your reports prior to publishing them. This allows you to work out 99% of all issues prior to the reports going live. I know this doesn’t solve the problem, but at least it lets you know about it sooner.

    By the way, I also recommend that you edit your reports using SQL Server Data Tools (SSDT-BI) or SQL Server Business Intelligence Development Studio (BIDS). SSDT-BI and BIDS have features that are helpful if you write a lot of reports. http://www.enhansoft.com/blog/business-intelligence-development-studio-bids-or-report-builder-rb

    Garth http://www.enhansoft.com

    • FoxDeploy April 18, 2016 / 10:32 am

      Thanks for the info, and for dropping a comment here, Garth. Previewing is the way to go, but in my case, the customer has me with a limited access account. Strangely, I can write new reports but not directly run the Preview from Report Builder.

Have a code issue? Share your code by going to Gist.github.com and pasting your code there, then post the link here!

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s