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)

lai290498

01.05.2024 AT 02:03 AM
Wonderful Article! - tstoto

Dwight Brookland

04.22.2020 AT 12:02 PM
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

CharlesSap

09.18.2019 AT 08:12 PM
What's the easiest way to earn $30000 a month: http://cort.as/-PQJY?jq3hUL1qA

Williamhon

09.16.2019 AT 11:55 PM
10 besten USA-Dating-Sites 2019: http://gmy.su/:R7nR?tx0GYS6GS

ThomasVeimb

09.16.2019 AT 03:34 PM
Die besten Casual Dating Apps: http://cort.as/-PnZ7?xcQCYeufp

ThomasVeimb

09.15.2019 AT 12:50 PM
Beste Casual Online-Dating-Sites: http://cort.as/-PpbF?78YRLSZEZb

Ron

03.19.2019 AT 09:23 PM
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.

Tony Cartwright

03.19.2019 AT 04:05 AM
Thanks for this - one word - awesome !

yusofm

03.06.2019 AT 09:04 AM
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.

Steve Poirier

07.12.2018 AT 10:35 AM
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

Steve Poirier

07.12.2018 AT 02:20 PM
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

Eric Benson

07.10.2018 AT 12:29 PM
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?

Jonathan Lefebvre

07.12.2018 AT 08:21 AM
Hi Eric, with which report do you get that error? Please contact us [email protected] for support on purchased product thanks Jonathan

BrianB

07.03.2018 AT 09:59 PM
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.

KeithDib666

06.06.2018 AT 05:22 AM
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

Benoit Lecours

05.15.2018 AT 09:41 AM
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à !

Matt Le Patourel

05.14.2018 AT 04:24 AM
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

Benoit Lecours

05.15.2018 AT 09:41 AM
See my comment

horatio rooks

04.04.2018 AT 10:55 PM
Thanks Guys This report worked

Rebecca Schaffer

03.05.2018 AT 02:44 PM
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

Benoit Lecours

05.15.2018 AT 09:43 AM
See my comment. View : vSMS_ClassicDeploymentAssetDetails

sumit singh

02.28.2018 AT 04:00 PM
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/

Benoit Lecours

05.15.2018 AT 09:42 AM
See my comment

P06229

12.08.2017 AT 05:28 AM
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) -------------------------------

Benoit Lecours

05.15.2018 AT 09:43 AM
See my comment. View : vSMS_WindowsServicingLocalizedNames

Jonathan Lefebvre

12.08.2017 AT 09:28 AM
Hi, can you give us your SCCM and SQL version please? Thanks Jonathan

knatour

11.03.2017 AT 12:37 PM
Disregard, I fix it.