SQL Server Reporting Services
Works with TestTrack 2009 and later Works with Surround SCM 2010 and later
Will not work with TestTrack 2008 and earlier Will not work with Surround SCM 2009 and earlierThe reporting plug-in architecture in TestTrack and Surround SCM enables some pretty exciting reporting and dashboard integration possibilities. You'll find a complete SQL Server Reporting Services (SSRS) plug-in on this page, which allows you to view reports created in SSRS from the TestTrack and Surround SCM clients.
Installing the Plug-inDownload the SSRS plug-in zip file.
- SSRSPluginCore.dll — C# library that supports the SSRS web service.
- serverreportsSSRSPlugin.dll — C++ library used to wrap SSRSPluginCore.dll.
- serverreportsttplugin.conf — Configuration file used by SSRSPluginCore.dll, which stores the computer name SSRS is running on and the web service virtual directory name.
- clientreportsSSRSClientPlugin.dll — C# library that communicates with SSRS to open Report Builder.
Server Plug-inNote: Microsoft .Net Framework must be installed on your server for this plug-in to function properly.
- Copy the following files to the <appdir>serverrports directory on the server:
- Update the following parameters in ttplugin.conf.
- Change the serverlocation parameter to the computer that SSRS is installed on. For example, if SSRS is installed on a computer named WYSICORPDEV, use serverlocation=WYSICORPDEV.
- Change the reportserver_virtualdir parameter to the report server virtual directory name. For example if the virtual directory is named SQLReportServer, use reportserver_virtualdir=SQLReportServer.
- Tip If you do not know the virtual directory name, look it up in the SSRS Configuration Manager. On SQL Server 2005, the virtual directory is displayed in the Report Server Virtual Directory Category. On SQL Server 2008, the virtual directory is displayed in the Web Service URL category.
- Copy SSRSPluginCore.dll to the <appdir> directory on the server.
- Run regasm SSRSPluginCore.dll at a command prompt to register the C# library to use .NET classes. If the regasm command line utility is not available, install the .NET Framework and try registering the library again.
- For example: regasm "C:Program FilesSeapineTestTrackSSRSPluginCore.dll
Client Plug-inNote: This is optional, and will allow you to create and edit SSRS reports directly from your TestTrack or Surround SCM client. Additionally, there are sample SQL Server data models for TestTrack, to make report creation easier.
- Copy SSRSClientPlugin.dll to the <appdir>clientreports directory on the client computer.
- Restart the TestTrack or Surround SCM client.
Using the Plug-inThe following instructions work similarly in both TestTrack and Surround SCM. TestTrack screenshots have been used, but the functionality is the same across both applications.
Application SecurityTo add external reports to TestTrack or Surround SCM, the following security commands must be enabled for the security group:
- Add Reports and Add External Reports in TestTrack.
- Add/Edit Private Reports and Add External Reports in Surround SCM.
SSRS SecurityYou must configure the following SSRS security to provide external report access in TestTrack:
- Add Windows users or groups who will access SSRS reports. If the TestTrack Server is installed as a service, add the server computer as a user or group.
- Assign the Browser role to users or groups who need access to reports in the TestTrack report models.
- You can also assign other roles as needed.
- Note: SSRS security overrides TestTrack security settings.
TestTrack Native SamplesIf you have a small installation of TestTrack, it might be possible to run Reporting Services against that project without converting to a RDBMS.
TestTrack MySQL SamplesIt's recommended that you move to a RDBMS database if you're going to use 3rd party reporting solutions against the TestTrack data. Here we've created sample reports against a TestTrack project hosted from a SQL Server database.
TestTrack SQL Server SamplesIt's recommended that you move to a RDBMS database if you're going to use 3rd party reporting solutions against the TestTrack data. Here we've created sample reports against a TestTrack project hosted from a SQL Server database. SQL Server Reporting Samples.zip - contains SQL Server Reporting Services 2008 rdl files for the samples shown below.
User List by Project & Role
Project Automation Rules
This report lists all of the automation rules setup in your project broken down by type. The query and more details can be found here.