TFS Report developer resources


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: 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


 


Documentation:


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.


MSDN on MDX: http://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: http://www.mosha.com/msolap


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


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/


 


Forums:


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


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


 


 

Comments (6)

  1. paso says:

    I’m happy to see that "Lots of trial and error with Report Designer." is listed in the Documentation chapter. Having stumbled accross most of the links listed above, I still find it very hard and time conusming to create good reports once you have changed the process template. IMO this is one of the weakest points in TFS that needs a lot more attention. Tools and documentation available are weak and/or not very user friendly. E.g.: Report Designer can only handle very simple MDX syntax in Design Mode and the editor of the Query View is very basic; e.g.: it doesn’t show line numbers so you have to count the lines yourself when an error like "Query preparation failed. Query (49, 1) Parser: The syntax for ‘SELECT’ is incorrect. (msmgdsrv)" occurs.

    The Report Builder is even worse: see http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=866279&SiteID=1″>http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=866279&SiteID=1.

    I think you even advised NOT to use Report Builder at all: "We know there are perf and usability problems using Report Builder with TFS, so we don’t recommend using it.(http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=766354&SiteID=1″>http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=766354&SiteID=1

    And other posts: http://forums.microsoft.com/MSDN/ShowPost.aspx?

    PostID=771436&SiteID=1

    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=792150&SiteID=1

  2. Buck Hodges on VSTS Profiler: Installing only the command line tool. The SRLTeam Blog on TFS Migration…

  3. Buck Hodges says:

    I don’t often post about reporting. My last post was about sample reports for TFS from a year ago. If

  4. Welcome! I thought that I would kick this blog off with a list of some good resources for learning about

  5. Хотя я уже довольно много времени занимаюсь TFS, его хранилище данных и создание собственных отчетов

  6. R.K. Chandrashekar says:

    A premier IT co have retained us to source TFS 2008/10 Administrators. Location; Bangalore.

    Interested candidates may please call or mail their resume to<r.k.chandrashekar1952@gmail.com>

    Regards. R.K. Chandrashekar. G.C. Associates. Cell: +91 9986032992

Skip to main content