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
- SSRS installed and all running components. If you don’t have a reporting server, you can refer to our post on how to install SCCM 2012 Reporting Services Point.
- A healthy RDL file.
- A user account with enough access to upload a report. Please read predefined roles on MSDN for more detailed information.

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

- Browse to the respective folder where you want to upload your file and click Upload 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.

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

- 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}

- 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.

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.
62 Comments on “SCCM Upload RDL File to Report Server”
I get the following error message.
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) Get Online Help
What’s the easiest way to earn $30000 a month: http://cort.as/-PQJY?jq3hUL1qA
10 besten USA-Dating-Sites 2019: http://gmy.su/:R7nR?tx0GYS6GS
Die besten Casual Dating Apps: http://cort.as/-PnZ7?xcQCYeufp
Beste Casual Online-Dating-Sites: http://cort.as/-PpbF?78YRLSZEZb
Hi,
When using the “Maintenance Windows per Device Report” and click on a collection, I get:
The item ‘/ConfigMgr_CMP/Dev/Configuration Manager – Maintenance Windows per Collection’ cannot be found. (rsItemNotFound)
This report is loaded in the same folder, and launches independently without issue.
Thanks for this – one word – awesome !
Hi,
Could you please advise on the error messages below once i run the report “Configuration Manager – Software Updates” :-
An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset ‘Parameter_Collection’. (rsErrorExecutingCommand)
Invalid object name ‘v_Collections’.
When i tried to run the Query in SQL Management Studio, i am getting the error below:-
Msg 137, Level 15, State 2, Line 1
Must declare the scalar variable “@Collection”.
Msg 137, Level 15, State 2, Line 35
Must declare the scalar variable “@Expired”.
Msg 137, Level 15, State 2, Line 45
Must declare the scalar variable “@Collection”.
Msg 137, Level 15, State 2, Line 72
Must declare the scalar variable “@Collection”.
For Deployment-Software Updates, i am getting the same error as per below :-
An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset ‘Parameters_CollectionID’. (rsErrorExecutingCommand)
Invalid object name ‘v_Collections’.
When i tried to run the Query in SQL Management Studio, i am getting the error below:-
Msg 137, Level 15, State 2, Line 7
Must declare the scalar variable “@Collection”.
Msg 137, Level 15, State 2, Line 31
Must declare the scalar variable “@Category”.
Msg 102, Level 15, State 1, Line 34
Incorrect syntax near ‘@Severity’.
Msg 102, Level 15, State 1, Line 36
Incorrect syntax near ‘@Assignment’.
Msg 102, Level 15, State 1, Line 38
Incorrect syntax near ‘@ComplianceStatus’.
Msg 102, Level 15, State 1, Line 40
Incorrect syntax near ‘@Search’.
Appreciate your prompt response on this matter.
I manage to change my DataSource and it’s working fine but when we try to use inside link reports it’s still target the CM_SCD. Is there a way to change all data source from this report to target our DB?
Thanks
The DataSource look to work now… could it be a delay in the DB? Anyway, one more error when I click on any Device Name from the repport: Device’ cannot be found. (rsItemNotFound)
Any clue?
Thanks
I’m getting failed to preview report.
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.CreateReportEditSession(String Report, String Parent, Byte[] Definition, String& EditSessionID, Warning[]& Warnings)
at Microsoft.ReportingServices.WebServer.ReportingService2010.CreateReportEditSession(String Report, String Parent, Byte[] Definition, String& EditSessionID, Warning[]& Warnings)
What do I need to do to fix this?
Hi Eric,
with which report do you get that error?
Please contact us info@systemcenterdudes.com for support on purchased product
thanks
Jonathan
Good day,
I successfully uploaded the report Asset – Office 365 and verified its healthy. When I run the report there was an error:
Microsoft.Reporting.WinForms.ReportServerException
An error has occurred during report processing. (rsProcessingAborted)
Stack Trace:
at Microsoft.Reporting.WinForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
at Microsoft.Reporting.WinForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension)
at Microsoft.Reporting.WinForms.AsyncMainStreamRenderingOperation.RenderServerReport(ServerReport report)
at Microsoft.Reporting.WinForms.AsyncRenderingOperation.PerformOperation()
at Microsoft.Reporting.WinForms.ReportViewer.AsyncReportOperationWrapper.PerformOperation()
at Microsoft.Reporting.WinForms.ProcessingThread.ProcessThreadMain(Object arg)
——————————-
Microsoft.Reporting.WinForms.ReportServerException
Query execution failed for dataset ‘DataSet1’. (rsErrorExecutingCommand)
Stack Trace:
at Microsoft.Reporting.WinForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
at Microsoft.Reporting.WinForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension)
at Microsoft.Reporting.WinForms.AsyncMainStreamRenderingOperation.RenderServerReport(ServerReport report)
at Microsoft.Reporting.WinForms.AsyncRenderingOperation.PerformOperation()
at Microsoft.Reporting.WinForms.ReportViewer.AsyncReportOperationWrapper.PerformOperation()
at Microsoft.Reporting.WinForms.ProcessingThread.ProcessThreadMain(Object arg)
——————————-
Microsoft.Reporting.WinForms.ReportServerException
For more information about this error navigate to the report server on the local server machine, or enable remote errors
Stack Trace:
at Microsoft.Reporting.WinForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
at Microsoft.Reporting.WinForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension)
at Microsoft.Reporting.WinForms.AsyncMainStreamRenderingOperation.RenderServerReport(ServerReport report)
at Microsoft.Reporting.WinForms.AsyncRenderingOperation.PerformOperation()
at Microsoft.Reporting.WinForms.ReportViewer.AsyncReportOperationWrapper.PerformOperation()
at Microsoft.Reporting.WinForms.ProcessingThread.ProcessThreadMain(Object arg)
——————————-
Thank you in advance.
Hi
Uploaded the RDL gile OK, and can see the Dashboard – Endpoint Protection front end of the report fine, however if i click on a link from this screen i get this error
The item ‘/System Health – Endpoint Protection’ cannot be found. (rsItemNotFound)
can you help
thanks
Keith
If you have errors on one of our report, it’s a permission error on one SQL view. Click on more details to find which view gives the error and go to SQL Management Studio :
To give access to a SQL view:
Open Microsoft SQL Server Management Studio
Select your SCCM Database and expand Views
Find ‘TheNameoYourProblematicTable’ and right click on the view
Click Properties
Select Permissions and find your SSRS user
Granted SELECT access to the user
Voilà !
Hi
Just purchased the Windows 10 Asset report but getting the following when running –
An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset ‘Total_Expired’. (rsErrorExecutingCommand)
For more information about this error navigate to the report server on the local server machine, or enable remote errors
Regards
Matt
See my comment
Thanks Guys
This report worked
Hi,
We received a similar error: The SELECT permission was denied on the object ‘vSMS_ClassicDeploymentAssetDetails’, database ‘CM_UNV’, schema ‘dbo’. Would you be able to assist us as well?
Thank you,
Rebecca
See my comment. View : vSMS_ClassicDeploymentAssetDetails
Hi Team
I have added one of your report and I am able to pull the details but when I client on the machines no ,it says rsItemNotFound error ,
the report is for Asset-Installed software
I have followed your steps to add this report in our environment ,have placed this rdl file in a custom report folder under root of reporting folders.
https://systemcenterdudes.com/upload-rdl-file-to-report-server/
See my comment
Hi,
I just buyed seven reports…
All were imported successfully except one which refuse to run : Asset Windows 10.
Can you give me some help to implement this report successfully?
The error is :
Une erreur s’est produite lors du traitement du rapport. (rsProcessingAborted)
Échec de l’exécution de la requête pour le dataset ‘Asset_Win10’. (rsErrorExecutingCommand)
Pour obtenir plus d’informations sur cette erreur, accédez au serveur de rapports sur le serveur local ou activez les erreurs distantes.
Microsoft.Reporting.WinForms.ReportServerException
Une erreur s’est produite lors du traitement du rapport. (rsProcessingAborted)
Stack Trace:
at Microsoft.Reporting.WinForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
at Microsoft.Reporting.WinForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension)
at Microsoft.Reporting.WinForms.AsyncMainStreamRenderingOperation.RenderServerReport(ServerReport report)
at Microsoft.Reporting.WinForms.AsyncRenderingOperation.PerformOperation()
at Microsoft.Reporting.WinForms.ReportViewer.AsyncReportOperationWrapper.PerformOperation()
at Microsoft.Reporting.WinForms.ProcessingThread.ProcessThreadMain(Object arg)
——————————-
Microsoft.Reporting.WinForms.ReportServerException
Échec de l’exécution de la requête pour le dataset ‘Asset_Win10’. (rsErrorExecutingCommand)
Stack Trace:
at Microsoft.Reporting.WinForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
at Microsoft.Reporting.WinForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension)
at Microsoft.Reporting.WinForms.AsyncMainStreamRenderingOperation.RenderServerReport(ServerReport report)
at Microsoft.Reporting.WinForms.AsyncRenderingOperation.PerformOperation()
at Microsoft.Reporting.WinForms.ReportViewer.AsyncReportOperationWrapper.PerformOperation()
at Microsoft.Reporting.WinForms.ProcessingThread.ProcessThreadMain(Object arg)
——————————-
Microsoft.Reporting.WinForms.ReportServerException
The SELECT permission was denied on the object ‘vSMS_WindowsServicingLocalizedNames’, database ‘CM_N02’, schema ‘dbo’.
Stack Trace:
at Microsoft.Reporting.WinForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
at Microsoft.Reporting.WinForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension)
at Microsoft.Reporting.WinForms.AsyncMainStreamRenderingOperation.RenderServerReport(ServerReport report)
at Microsoft.Reporting.WinForms.AsyncRenderingOperation.PerformOperation()
at Microsoft.Reporting.WinForms.ReportViewer.AsyncReportOperationWrapper.PerformOperation()
at Microsoft.Reporting.WinForms.ProcessingThread.ProcessThreadMain(Object arg)
——————————-
Hi,
can you give us your SCCM and SQL version please?
Thanks
Jonathan
See my comment. View : vSMS_WindowsServicingLocalizedNames
Disregard, I fix it.
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?
For SSRS version 2014, the pie charts aren’t working but do work on my SSRS 2012 version.
Hi Jerry,
Can you tell us which report as this issue?
We’ll do our best to fix this.
thanks
Jonathan
Works like a charm and it’s a very nice report. Thanks for providing it.
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
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
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
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!
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
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
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
Pingback: Windows 10 Version and Compliance Dashboard – In teaching others we teach ourselves
Pingback: Windows 10 Version and Compliance Dashboard – In teaching others we teach ourselves
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) “
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
Pingback: How To Deploy Rdl File Into Report Server | Khmer Bank
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
Hi,
I’ve just changed DATA SOURCE via “Click on Manage” and it is working fine 🙂
Thanks
Kasia
Good to know 🙂
Thanks
Nick
Hi
Just downloaded the • Report | Deployment – Software Updates when I upload to Reporting services in the data source which selection should I be using.
This issue was resolved by email. Default data source is normally a long guid number. Thanks James!
AWESOME – your note (datasource is the GUID) fixed it for me. Thanks
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?
Resolved by email!
Thanks Stacey
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
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
How do you create a shared data source? We have no shared data sources currently.
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.
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?
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!
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’.
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.
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]
🙂 There you go!
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
Hi Stefan,
We answered by email. Let us know if everything is ok.
Thanks
Nick