Wednesday, February 27, 2013

SSRS - Setting up your development environment

I needed to start working on a few SSRS reports for a current project.  My new development is currently being done using VS2012.  I am still getting use to the interface, for normal web development I find 2012 to be an improvement over VS2010.  The only exception to this is I find the TFS integration to be more difficult to use in VS2012 than in VS2010.  So if I am editing work item templates or working with queries a lot I still  have 2010 running on my laptop most of the time.

I quickly learned that 2012 just like 2010 does not support BIDS.  If you want to build SSRS reports you must step back to VS2008.  So I cracked open VS2008, the oldest version I keep installed on my laptop, and started a new report. I went to check in my report to my TFS 2010 server and found that I do not even have a team menu.  I forgot that VS2008 does not come installed with TFS has a Team Viewer download that must be installed separately so I downloaded it from MSDN.  So I downloaded it and installed it from

Team Viewer Download
http://www.microsoft.com/en-us/download/details.aspx?id=16338

The next step was to connect to TFS.  I opened up the Team Menu and figured out my VS2008 did not have SP1 instaled so I downloaded that also.

VS2008 SP1
http://www.microsoft.com/en-us/download/details.aspx?id=20955

Finally because I was running TFS2010 I needed a compatibility pack downloaded from

TFS 2010 VS2008 Compatability Pack
http://www.microsoft.com/en-us/download/details.aspx?id=10834

I thought I was well on my way.  But I opened up the team menu and tried to connect to my TFS and it would not connect.  After some playing around I figured out you must type in the whole address to your TFS server to make it work.  The UI does not tell you this, but it will not work without doing the whole address

For Example http://tfsserver:8080/tfs

Happy Report Building with VS2008 and TFS2010





No comments:

Post a Comment