SCCM Reporting is a great way to see insight of your inventory and data. There’s many custom reports out there on the internet. If you download a custom report, you’ll have a RDL file. This RDL then need to be uploaded on your report server. You can do it manually using the web portal or use a script. This post will show all the ways you can upload an RDL file on an SCCM Reporting Point.

An RDL file is simply an XML application and a standard proposed by Microsoft for defining reports.

SCCM Upload RDL file Requirements

SCCM Upload Rdl file

Upload the RDL file manually

We suggest uploading your file into a Test folder before releasing the report in production. If you have multiple report to upload (Ex : if you are a subscription member and want all reports on your reporting point), see the next section to upload using a script.

  • Open a web browser and browse to your reporting point
  • Usually this will be http://yourreportingpoint/reports
  • You can also double check your reporting point URL in the SCCM console in Monitoring / Reporting
  • The Report manager URL will be listed there
SCCM Upload Rdl file
  • Browse to the respective folder where you want to upload your file and click Upload File.
SCCM Upload Rdl file
  • Find your file location, and select the file. If you already have a report to that name a dialog box will ask if you want to overide the report.
  • If the upload is successful, the report will appear else you will have an error message explaining the failure. Any unhealthy RDL file will fail at this process.
SCCM Upload Rdl file

Change the Data Source

Once your RDL file is uploaded, there are still a few things to change to make it work perfectly.

  • Click the 3 little dot, an options menu will appear. Click on Manage.
  • In the Properties tab, change the description if needed. This description will be displayed to describe the report to your users, click Apply
SCCM Upload Rdl file
  • In the Data Sources tab, select your data source or the report will not process. To select your data source, click on Browse and select an existing data source in the appropriate folder. It will be at the bottom of the folder structure.
  • The SCCM default datasource is always {5C6358F2-4BB6-4a1b-A16E-8D96795D8602}
SCCM Upload Rdl file
  • Click Apply
  • (Optional)In the Security tab, add security groups or users who want to run your report. The security settings will be enforced by the new parent folder security settings. Don’t be surprised if the access change after moving the report into production.
Upload RDL file to Report Server

Automaticaly Upload RDL File using a script

If you have multiple RDL files and data sources to change, you can use our SCCM Reports Manager Tool freely available on my Github account.

The tool allows to :

  • Upload multiple reports from a specific folder — Useful if you have multiple RDL files to upload at once
  • Download all report from a specific SSRS folder — Useful if you have multiple custom reports and are doing a migration to a new reporting point
  • Change data source of all reports from a specific SSRS folder — Useful if you upload multiple new reports and need to change their data sources

The script needs PowerShell 2.0 and has been tested on SQL 2012, 2016 and 2019 Reporting Point.

Summary

Adding a report with the web portal isn’t the fastest way but it requires the least prerequisites. It’s pretty straightforward. Make sure your SCCM RDL file is not corrupted and the data source is well configured. Lastly, verify security settings before sending the link to users.

Comments (63)

knatour

11.02.2017 AT 08:38 AM
Hello - I uploaded "Deployment - Overview" in a test folder on SSRS, modified the Data Sources based on the instructions and it seems to work fine however, when I want to drill down to the links like "Errors" I get the "The Item /xxxxxxx/test/Deployment - Applications' cannot be found. (rsItemNotFound) Any insight on how to fix this?

Jerry Krasnesky

10.02.2017 AT 06:31 PM
For SSRS version 2014, the pie charts aren't working but do work on my SSRS 2012 version.

Jonathan Lefebvre

10.03.2017 AT 10:17 AM
Hi Jerry, Can you tell us which report as this issue? We'll do our best to fix this. thanks Jonathan

Barry Dutchak

07.18.2017 AT 12:03 PM
Works like a charm and it's a very nice report. Thanks for providing it.

Manzoor Murshed

06.02.2017 AT 01:10 AM
Hi While I ma tying trying to test the uploaded file we got this message The operation you are attempting on item '/ConfigMgr_HQO/Hardware - General' is not allowed for this item type. (rsWrongItemType) " is there any way to resolve it Thanks Manzoor

Marc R.

05.08.2017 AT 01:11 AM
Hi, Am getting this error when I try to run the report: An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset 'DataSet1'. (rsErrorExecutingCommand) For more information about this error navigate to the report server on the local server machine, or enable remote errors I changed the data source and tested the connection to be working. Any ideas ? Thanks

Michael Kassenoff

04.07.2017 AT 04:11 PM
I am unable to install your report. I was able to follow this guide to import one report.. the asset-intune users report. the asset-intune devices report i cannot install. error:The definition of this report is not valid or supported by this version of Reporting Services. The report definition may have been created with a later version of Reporting Services, or contain content that is not well-formed or not valid based on Reporting Services schemas. Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2016/01/reportdefinition' which cannot be upgraded. (rsInvalidReportDefinition) Please Help thanks

QWade

03.09.2017 AT 10:27 AM
Hello - I'm receiving the following error. An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset 'Parameter_Collection'. (rsErrorExecutingCommand) The SELECT permission was denied on the object 'v_Collections', database 'ConfigMgr_CHQ', schema 'dbo'. Any input would be greatly appreciated. Thanks!

Joseph Martin

03.08.2017 AT 01:30 PM
The report definition is not valid. Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition' which cannot be upgraded. (rsInvalidReportDefinition) how do i fix this. i'm new to SCCM

Farid Sharif

01.25.2017 AT 11:37 AM
Hi, Joining the party late on this one but any chance you know why I'm receiving this error when trying to save after changing the data source? I'm adding by selecting the option 'add data source' on the 'right click' menu. System.Web.Services.Protocols.SoapException: An unexpected error occurred in Report Processing. ---> System.IndexOutOfRangeException: Index was outside the bounds of the array. at Microsoft.ReportingServices.Library.ReportingService2010Impl.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, ItemType ItemType, CatalogItem& ItemInfo, Warning[]& Warnings) at Microsoft.ReportingServices.Library.ReportingService2010Impl.CreateCatalogItem(String ItemType, String Name, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, CatalogItem& ItemInfo, Warning[]& Warnings) at Microsoft.ReportingServices.WebServer.ReportingService2010.CreateCatalogItem(String ItemType, String Name, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, CatalogItem& ItemInfo, Warning[]& Warnings) Thank you Farid

John

11.29.2016 AT 10:33 AM
Hi Nicolas, I'm also getting the error The SELECT permission was denied on the object 'vSMS_WindowsServicingStates', database 'CM_CCR', schema 'dbo'. I have tried using the same data source as all of my other custom reports but I keep getting this error, any thoughts? Thanks

Cory MacCharles

06.23.2016 AT 12:46 PM
When the report returns it says the software is on 51 computers. If I click the "51" I get the error "The item '/ConfigMgr_XXX/SystemCenterDudes - Asset - Installed Software' cannot be found. (rsItemNotFound) "

Nicolas Pilon

06.27.2016 AT 11:32 PM
Hello Cory, Did you copy both rdl files from the product in the same folder? This is because the link between reports is corrupted. Copy the report in the same SSRS folder or modify the Overall report to redirect to the good report. Thanks

Frija

02.18.2016 AT 11:05 AM
Hi, I cannot save report. i open SQL Report Builder, and i have changed Data Source, i testet connection, and it's working fine but when i tried to safe it i get error: System.Web.Services.Protocols.SoapException: An unexpected error occurred in Report Processing. ---> System.IndexOutOfRangeException: Index was outside the bounds of the array. at Microsoft.ReportingServices.Library.ReportingService2010Impl.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, ItemType ItemType, CatalogItem& ItemInfo, Warning[]& Warnings) at Microsoft.ReportingServices.Library.ReportingService2010Impl.CreateCatalogItem(String ItemType, String Name, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, CatalogItem& ItemInfo, Warning[]& Warnings) at Microsoft.ReportingServices.WebServer.ReportingService2010.CreateCatalogItem(String ItemType, String Name, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, CatalogItem& ItemInfo, Warning[]& Warnings) Any ideas what is going wrong? Thanks, Kasia

Frija

02.18.2016 AT 11:12 AM
Hi, I've just changed DATA SOURCE via "Click on Manage" and it is working fine 🙂 Thanks Kasia

Nicolas Pilon

02.18.2016 AT 03:29 PM
Good to know 🙂 Thanks Nick

Jimmy

10.26.2015 AT 12:08 PM
Hi Just downloaded the • Report | Deployment – Software Updates when I upload to Reporting services in the data source which selection should I be using.

Nicolas Pilon

10.27.2015 AT 08:48 AM
This issue was resolved by email. Default data source is normally a long guid number. Thanks James!

STGdb

06.23.2017 AT 07:52 AM
AWESOME - your note (datasource is the GUID) fixed it for me. Thanks

stacey porter

09.21.2015 AT 08:08 AM
I'm having problems setting up the reports. I'm not sure how to configure the Data Source/where to put it/connect. I'm getting this error message "The operation you are attempting on item '/ConfigMgr_MCC/Compliance and Settings Management/Compliance and Settings Management" What do I do to fix it?

Nicolas Pilon

09.21.2015 AT 09:38 AM
Resolved by email! Thanks Stacey

Fred

09.04.2015 AT 10:29 PM
Hi, I receive the same error as the previous post: The SELECT permission was denied on the object ‘vSMS_Folders’, database ‘CM_TST’, schema ‘dbo’. Invalid object name ‘#Collection’. Any ideas? Thanks, Fred

Nicolas Pilon

09.08.2015 AT 10:16 AM
Hi Fred, Simply grant read access to your SSRS user on view vSMS_Folders in your CM_TST SQL database. Hope it helps. 🙂 Let us know. Thanks

madTomVane

07.21.2015 AT 12:33 PM
How do you create a shared data source? We have no shared data sources currently.

Nicolas Pilon

07.22.2015 AT 08:36 AM
To create a new data source, follow this post. There's a video included. From your SSRS website, click on New Data Source in the menu. You have the button on the sixth picture from the post, you can also use the custom data source and configure your SQL database there. At the connection windows, you should enter something like this. Data Source=YourSQLServerName;Initial Catalog=YourDatabaseName Make sure credentials are ok and you should use this data sources after for all your reports. Hope it helps.

Chris

09.30.2015 AT 01:04 AM
Hi. I cant for the life of me figure out how to create that shared datasource. And I assume without it this rdl is useless?

Nicolas Pilon

09.30.2015 AT 02:08 PM
Hello Chris, You can do it directly in the report by following this post. You can also do it from the SSRS website by following this post. I hope it helps!

Chris

10.01.2015 AT 01:55 AM
Hi. Thank you. I think I got somewhat forward. But I know get this error: An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset 'ConfigurationManager_DistributionPoints'. (rsErrorExecutingCommand) Invalid object name 'dbo.v_R_System'.

Nicolas Pilon

10.01.2015 AT 05:34 AM
Hello Chris, dbo.v_R_System his the main default view from SCCM. If you are having this issue is because the query inside the report is not able to find this view. Do you have SCCM installed? If yes, try to configure the datasource with server and database information of your SCCM.

Chris

10.01.2015 AT 05:50 AM
Hi I found the error When i spesefied the correct Connection String in the Shared Data Source it worked Connection String: Data Source=(local); Initial Catalog=[DB name of SCCM DB]

Nicolas Pilon

10.01.2015 AT 06:09 AM
🙂 There you go!

Stefan Schipper

02.27.2015 AT 08:23 AM
Hi, i receive the following error: The SELECT permission was denied on the object 'vSMS_Folders', database 'CM_TST', schema 'dbo'. Invalid object name '#Collection'. Any idea what i need to change? Thanks, Stefan

Nicolas Pilon

03.05.2015 AT 01:04 PM
Hi Stefan, We answered by email. Let us know if everything is ok. Thanks Nick