Upload RDL File to Report Server

Nicolas PilonSCCM, SSRS33 Comments

There are many way to upload RDL file to report server (SSRS). This post will show how to do it with the web portal.

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

Requirements

Upload RDL file to Report Server

Upload the file

We suggest uploading your file into a Test folder before releasing the report in production. The report can be tested in pre-prod and be approved by your team.

Browse to the respective folder where you want to upload your file and click Upload File.

Upload RDL file to Report Server

Click Browse, find your file location and select the file. If you want to override an existing report, check the box Overwrite item if it exists. Click OK.

Upload RDL file to Report Server

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

There are few thing to check if you want to deploy the report and make it work perfectly.

Put the mouse over the report name, an options menu will appear. Click on Manage.

Upload RDL file to Report Server

In the Properties tab, change the description if needed. This description will be displayed to describe the report to your users, click Apply

Upload RDL file to Report Server

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.

Click Apply.

In the Security tab, add security groups or users who want to run your report. The security settings will be enforced by 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

Summary

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

 

Upload RDL file to Report Server

Founder of System Center Dudes. Nick has been awarded in 2016 as a Microsoft MVP in Enterprise Mobility category.
Working as a senior SCCM and Intune advisor as well as a specialist Microsoft Cloud solutions specialist.
Upload RDL File to Report Server
5 - 2 votes

33 Comments on “Upload RDL File to Report Server”

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

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

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

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

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

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

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

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

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

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

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

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

  13. Hi

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

    1. This issue was resolved by email. Default data source is normally a long guid number. Thanks James!

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

  15. 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.
        I cant for the life of me figure out how to create that shared datasource.

        And I assume without it this rdl is useless?

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

          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]

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

Your email address will not be published. Required fields are marked *