Mauli, a core reporting team member, has compiled a great reference list of articles, reference documentation, tutorials and blogs for report developers.
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.
Video for creating custom reports: http://teamsystemrocks.com/files/10/team_foundation_server/entry164.aspx
MSDN article on creating SSRS reports: http://msdn.microsoft.com/msdnmag/issues/06/06/DataPoints/default.aspx
Webcasts about SSRS: http://www.microsoft.com/events/series/sqlserverbi.mspx#SQLServerReportingServices
SSRS tutorials: http://msdn2.microsoft.com/en-us/library/ms170246.aspx
SSRS report samples for TFS: http://blogs.msdn.com/tompatton/archive/2006/05/07/591713.aspx
TFS Warehouse documentation: http://msdn2.microsoft.com/en-us/library/ms244696(VS.80).aspx
TFS General documentation: http://msdn2.microsoft.com/en-us/library/ms181232(vs.80).aspx
How to write a warehouse adapter: http://msdn2.microsoft.com/en-us/library/bb130342(VS.80).aspx
How to make a work item field reportable: http://msdn2.microsoft.com/en-us/library/ms194942(VS.80).aspx
SSRS Report Design: Best Practices and Guidelines: http://www.microsoft.com/technet/prodtechnol/sql/2005/rsdesign.mspx
Article for MDX newbies: http://www.mosha.com/msolap/articles/MDXForEveryone.htm
Tutorials for AS, RS, MDX: http://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.
Lots of trial and error with Report Designer.
Mosha’s blog is great for OLAP/MDX: http://www.mosha.com/msolap
Chris Hays has a bunch of “hacks” for SSRS: http://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!): http://blogs.msdn.com/ameyab/
TFS Reporting forum: http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=480&SiteID=1
TFS General forum: http://forums.microsoft.com/msdn/showforum.aspx?forumid=22&siteid=1
Analysis Services forum: http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=83&SiteID=1
Reporting Services forum: http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1
Excel Discussion Group: http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.excel.misc