Reporting

If you haven’t discovered the list window enhancements added in TestTrack 2010.1, you definitely should check them out. There are a lot of time-saving improvements, including the ability to customize list window text appearance, shortcuts for working with subsets of items, and more available data.

Continue reading…

Share on Technorati . del.icio.us . Digg . Reddit . Slashdot . Facebook . StumbleUpon

No Comments

Tags: , , , ,

With the release of Surround SCM 2010 & TestTrack 2010.1, the Seapine License Server now supports logging license usage events. This presents an opportunity to better understand how licenses are being used across your Surround SCM and TestTrack installation.

We’ve had the TT License Monitor tool for quite a while, but it provides a very limited set of data on floating licenses and nothing on named license usage. I’ve been excited about the new logging functionality ever since I saw the first design document, and when it was code complete I immediately put “take it for a spin” on my schedule.
Continue reading…

Share on Technorati . del.icio.us . Digg . Reddit . Slashdot . Facebook . StumbleUpon

2 Comments

Tags: , ,

Server plug-ins query external reporting services, communicate information about reporting services to client plug-ins, and run requested reports.

The Surround SCM and TestTrack Servers scan for plug-ins in the serverreports directory in the product application directory every 10 minutes. If a new plug-in is found, it is added to the list of available server plug-ins, which is sent to Surround SCM or TestTrack when users request to add external reports.

All server plug-ins must define the following ReportStatus enumeration, which provides return values for several functions in the server plug-in API.
Continue reading…

Share on Technorati . del.icio.us . Digg . Reddit . Slashdot . Facebook . StumbleUpon

1 Comment

Tags: , ,

Server and client external reporting plug-in APIs allow Surround SCM and TestTrack to retrieve and display reports from external reporting services. Server plug-ins query external reporting services, provide information to client plug-ins, and run requested reports.

Continue reading…

Share on Technorati . del.icio.us . Digg . Reddit . Slashdot . Facebook . StumbleUpon

No Comments

Tags: ,

The list report grouping stylesheets, introduced in TestTrack 2009, have been tremendously helpful to customers looking to slice data by various attributes, such as hours worked by product/component.

Continue reading…

Share on Technorati . del.icio.us . Digg . Reddit . Slashdot . Facebook . StumbleUpon

No Comments

Tags: , ,

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 earlier

The reporting plug-in architecture in TestTrack and Surround SCM enables some pretty exciting reporting and dashboard integration possibilities.

You’ll find a basic Crystal Reports plug-in on this page, which allows you to view reports created in Crystal Reports from the TestTrack and Surround SCM clients.
Continue reading…

Share on Technorati . del.icio.us . Digg . Reddit . Slashdot . Facebook . StumbleUpon

No Comments

Tags: ,

Works with TestTrack 2009 and later
Works with Surround SCM 2010 and later

Report models organize database tables and views in a way that allows users to create reports without understanding queries or the physical database structure. Report models can also control the available data for reporting.
Continue reading…

Share on Technorati . del.icio.us . Digg . Reddit . Slashdot . Facebook . StumbleUpon

1 Comment

Tags: , ,

One of the biggest changes in the 2009 release of Surround SCM was the move to an RDBMS system for its database. There are many benefits to using industry-standard RDBMS systems, but for this post we are going to focus on the ability to generate third party or custom reports.

Surround SCM ships with PostgreSQL, which can present a challenge it comes to generating custom reports. The main hurdle has been finding a low cost or free reporting tool. You are getting PostgreSQL with Surround SCM, and who has budget to purchase another tool? If you are not in a “Windows shop”, you will probably stay on PostgreSQL and may not have a reporting tool that works with PostgreSQL.

So what to do?
Continue reading…

Share on Technorati . del.icio.us . Digg . Reddit . Slashdot . Facebook . StumbleUpon

4 Comments

Tags: , , , ,

With the release of TestTrack 2009, we added a really great plug-in architecture to allow for integrating 3rd party reporting tools into your TestTrack installation. With this users can create and run reports directly from their desktop client, just like a native report. Today I want to highlight the SQL Server Reporting Services integration we have, to show you how easy and seamless it is to provide users with customized reports.
Continue reading…

Share on Technorati . del.icio.us . Digg . Reddit . Slashdot . Facebook . StumbleUpon

No Comments

Tags: , , , , ,

Pentaho offers an open source reporting server that you can use to create reports.

They have an Enterprise edition and a Community Edition. The Enterprise edition has several benefits, like extra features, more documentation and customer support.

Please visit their web site for details on how licensing works for each edition.

For my reports I used the community edition.

The reports suite includes many components. I used the Report Designer to create the reports, and then used the Business Inteligence Server to share them with other users.

Please note that this should not be considered a review of the Pentaho toolset as I only looked at a limited portion of them with a limited goal in mind.

Report Designer

The Report Designer is a java based GUI interface that you can use to create and design your reports. If you have worked with any other reporting tools, it is pretty easy to figure out how to use it.

Bussiness Intelligence Server

Allows web access to report creation and viewing. Reports created with the Report Designer can be published to the Server to share it with other users.

Share on Technorati . del.icio.us . Digg . Reddit . Slashdot . Facebook . StumbleUpon

No Comments

Tags: ,