TFS Report developer resources

  • Article

Mauli, a core reporting team member, has compiled a great reference list of articles, reference documentation, tutorials and blogs for report developers.

From: Mauli Shah

Hi all,

There have been a lot of questions about references for making reports. I’ve been keeping a running list of references that I’ll share with you here. I encourage you all to reply with references that you have found helpful, and material that you’d like to see.

Mauli

 

Videos/Samples:

Video for creating custom reports: https://teamsystemrocks.com/files/10/team_foundation_server/entry164.aspx

MSDN article on creating SSRS reports: https://msdn.microsoft.com/msdnmag/issues/06/06/DataPoints/default.aspx

Webcasts about SSRS: https://www.microsoft.com/events/series/sqlserverbi.mspx#SQLServerReportingServices

SSRS tutorials: https://msdn2.microsoft.com/en-us/library/ms170246.aspx

SSRS report samples for TFS: https://blogs.msdn.com/tompatton/archive/2006/05/07/591713.aspx

 

Documentation:

TFS Warehouse documentation: https://msdn2.microsoft.com/en-us/library/ms244696(VS.80).aspx

TFS General documentation: https://msdn2.microsoft.com/en-us/library/ms181232(vs.80).aspx

How to write a warehouse adapter: https://msdn2.microsoft.com/en-us/library/bb130342(VS.80).aspx

How to make a work item field reportable: https://msdn2.microsoft.com/en-us/library/ms194942(VS.80).aspx

 

SSRS Report Design: Best Practices and Guidelines: https://www.microsoft.com/technet/prodtechnol/sql/2005/rsdesign.mspx

 

Article for MDX newbies: https://www.mosha.com/msolap/articles/MDXForEveryone.htm

Tutorials for AS, RS, MDX: https://www.databasejournal.com/features/article.php/3593466

 

Here are some resources that our dev team uses:

This book is good for getting up to speed on MDX basics: Fast Track to MDX

Caveat: The cube they use is very different from the TFS cube.

MSDN on MDX: https://msdn2.microsoft.com/en-us/library/ms145506.aspx

Lots of trial and error with Report Designer.

Blogs:

Mosha’s blog is great for OLAP/MDX: https://www.mosha.com/msolap

Brian Welcker has a lot of stuff on SSRS: https://blogs.msdn.com/bwelcker/default.aspx

Chris Hays has a bunch of “hacks” for SSRS: https://blogs.msdn.com/ChrisHays/

Ameya’s blog has some good resources and some videos on different report authoring tools (you don’t have to just use Report Designer!): https://blogs.msdn.com/ameyab/

Forums:

TFS Reporting forum: https://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=480&SiteID=1

TFS General forum: https://forums.microsoft.com/msdn/showforum.aspx?forumid=22&siteid=1

Analysis Services forum: https://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=83&SiteID=1
Reporting Services forum: https://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1

Excel Discussion Group: https://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.excel.misc

Visio Discussion Group: https://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.visio.general&lang=en&cr=US