SCCM Upload RDL File to Report Server

Benoit LecoursSCCM, SSRS62 Comments

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.

62 Comments on “SCCM Upload RDL File to Report Server”

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

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

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

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

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

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

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

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

  8. 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à !

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

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

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

    ——————————-

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

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

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

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

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

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

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

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

  20. Pingback: Windows 10 Version and Compliance Dashboard – In teaching others we teach ourselves

  21. Pingback: Windows 10 Version and Compliance Dashboard – In teaching others we teach ourselves

  22. 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) “

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

  23. Pingback: How To Deploy Rdl File Into Report Server | Khmer Bank

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

  25. Hi

    Just downloaded the • Report | Deployment – Software Updates when I upload to Reporting services in the data source which selection should I be using.

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

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

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

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

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

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

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

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

Leave a Reply