Customizing Reports
Hi, Allen Clark, Team Foundation program manager back to talk about reporting again. I want to follow up a bit on customizing your reports. The reports shipped with Team System are SQL Server Reporting Services reports. You can alter these reports or create your own reports using Business Intelligence Development Studio, the SQL Server 2005 Reporting Services designer. It’s delivered with the SQL Server client tools.
The first thing you need to do to create custom reports is to set up a Report Project. In Business Intelligence Development Studio, create a new project and select Report Project.
Next, create a couple of data sources, one to access the relational database and one to access the OLAP database. If you intend on using the reports in a process template, then call them TfsReportDS and TfsOLAPReportDS, respectively.
Now create a report. For more information on creating a report with SQL Server Reporting Services, check out http://msdn.microsoft.com/SQL/sqlwarehouse/ReportingServices/default.aspx.
You can also extract reports that are shipped with the MSF Agile process template, add that to your project, and modify it. To extract the reports, you can do one of two things.
Get a single report
- Browse to the Reporting Services site (http://[data tier]/reporting)
- Select a project
- Select the report.
- Select Properties
- Select Edit
- Save the .xml file as [report name].rdl
Get the entire set of reports from a process template
- Export the process template
- Get the .rdl files from the exported .zip file
After you’ve created your new reports, you can load them directly in an existing Team Project, or you can use them in a custom process template. If you use them in a custom process template, the reports will be included each time that process template is used to create a new Team Project.
Next time, I’ll go over the warehouse schema.
Allen Clark, Program Manager, Visual Studio Team System
