In the last post of this series we completed our report so that it contains all the graphical annotations we wanted. It is now time to publish it to the server and make it available to our users.
Publishing the Report to the Server
Once we have a report running on the local machine, publishing it is the easy part!
1. Open the report that we worked on throughout the previous parts of the series
2. From the main ribbon button, choose the Save As menu option. The Save As Report file dialog will appear.
3. Now comes the easy part: In the Name textbox, enter the URL for your TFS installation of Reporting Services. This will typically be of the form http://<TFS SERVER>/ReportServer.
4. You should now see a folder named simply TfsReports.
5. Open the TfsReports folder. You will now see a list of folders matching the names of the Team Project Collections on the server that are available to you. Choose the appropriate TPC.
6. You will now see the list of Team Projects in the TPC that are available to you. Choose the appropriate project and inside the TP, the appropriate folder in which to save the report. It is worthwhile to note that the names of folders inside each TP are not hard-coded into TFS – rather, they depend on the process template that was selected for each project (for example, MSF for Agile Software Development or MSF for CMMI Process Improvement).
7. Click Save. The report has now been uploaded to the server.
8. Open Visual Studio (or Visual Studio Team Explorer) and navigate to the relevant project and folder. Your report should now be visible. If VS was already open before you saved the report, you need to right-click the Reports node in the Team Explorer window and choose Refresh.
And there it is! The report is now available to our users. Of course, permissions are available in SSRS to make sure that not everyone can see everything…
In this series of posts we saw how to build a basic TFS report step by step:
- Choose the appropriate TFS data source and create a query
- Prepare a report and integrate the query into it, including any parameters that need to be entered by the user
- Add any additional features to the report, such as graphical annotations
- Publish the report to the server
From here on, the way is open for you to explore the capabilities of both the TFS databases (which contain A LOT of useful information on pretty much anything that happens inside of TFS) and the SSRS infrastructures. Good Luck!