Setting up SQL Server Data Tools

IMIS supports reports created using SQL Server Data tools for any version of Visual Studio or in Report Builder.

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.

Note: For versions of Visual Studio newer than VS 2013, ensure that the TargetServerVersion of your Reporting Services project is SQL Server 2008 R2, 2012, or 2014.

ASI recommends that you visit the Microsoft support site for more information about SQL, reporting tools, and which tools are right for you.

Preparing your environment

Do the following to prepare your environment to use SQL Server Data Tools:

  1. Uninstall any beta or Community Technology Preview (CTP) versions of SQL Server Management Studio.
  2. Verify you have administrative rights and ample free space on the machine where you will be working with reports.
  3. Download and install SQL Server Data Tools.

    4. Note: Review the System requirements.

  4. Open Visual Studio and create a Reporting Services project.
  5. In the Solution Explorer, right-click your Reporting Services project and select Properties.
  6. From the project properties panel set the TargetServerVersion setting to SQL Server 2008 R2, 2012, or 2014.

    7. Setting the TargetServerVersion setting to SQL Server 2008 R2, 2012, or 2014

  7. Click OK or Apply to save.

Updating existing reports to ensure version compatibility with iMIS

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:

  1. Open Visual Studio and create a Reporting Services project.
  2. Set the TargetServerVersion to SQL Server 2008 R2, 2012, or 2014.
  3. Add your report to the project.
  4. Build the project.
  5. In the local system folder for your Reporting Services project, open and view the RDL for your report in the ~/bin/Debug folder.
  6. Verify that the <Report> element at the top of the RDL files specifies the 2010 version of the Microsoft report definition schema:
    7. <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition">
  7. Upload the report file from the ~/bin/Debug folder to iMIS.

Notes:

  • Reports that target the 2008 and 2010 report definition schemas are compatible with an iMIS system using SQL Server 2016.
  • Reports that target the 2016 report definition schema do not work on any version of iMIS.