Reports that target the 20 report definition schemas are compatible with an iMIS system using SQL Server 2016.Upload the report file from the ~/bin/Debug folder to iMIS.Verify that the element at the top of the RDL files specifies the 2010 version of the Microsoft report definition schema:.In the local system folder for your Reporting Services project, open and view the RDL for your report in the ~/bin/Debug folder.Set the TargetServerVersion to SQL Server 2008 R2, 2012, or 2014.If your report produces an error in iMIS, for example, The definition of this report is not valid or supported by this version of Reporting Services, do the following: Updating existing reports to ensure version compatibility with iMIS From the project properties panel set the TargetServerVersion setting to SQL Server 2008 R2, 2012, or 2014.
Microsoft ODBC Driver 17 for SQL Server SQL Server 2016. Microsoft ODBC Driver 17 for SQL Server SQL Server 2017. Supported SQL Server clients are as follows: SQL Server 2019. In the Solution Explorer, right-click your Reporting Services project and select Properties. When a version of SQL Server is no longer supported by ArcGIS, the corresponding SQL Server client library will no longer be supported either.Open Visual Studio and create a Reporting Services project.SQL Server Management Studio (SSMS) is an add-on to SQL Server that allows users with some database experience to open and view. This is the bare minimum required to run the SQL Server database.
Important! If you cannot create a Reporting Services project in SSDT, you may need to download Microsoft Reporting Services Projects from the Visual Studio Marketplace. IMIS supports reports created using SQL Server Data tools for any version of Visual Studio or in Report Builder.