Go Premium for a chance to win a PS4. Enter to Win


Visual Studio 2008 book recommendation

Posted on 2016-10-25
Medium Priority
Last Modified: 2016-11-03
Can someone recommend a book I could get or read online to learn more about expressions, formulas, and all things Visual Studios 2008 with regards to report writing? I see several books out there for everything that has to do with Visual Studios but only a very small chapter on reports. (Oh and BTW, I like books with pictures :-) )
Question by:Lisa Randle
  • 2
  • 2
  • 2
LVL 16

Assisted Solution

by:Megan Brooks
Megan Brooks earned 1000 total points
ID: 41859719
I see that your post is categorized as SSRS. Are you looking for books that describe how to use the Report Designer in SQL Server 2008 BIDS (Business Intelligence Development Studio)?

BIDS is built on an older version of Visual Studio (it's been a long time -- I don't remember which BIDS uses which Visual Studio version), but adds project templates for SSRS and other SQL Server BI components. If you search for BIDS and reporting services, rather than for Visual Studio per se, you may still find what you are looking for. Books written for more recent versions may work as well, since most of the core features have been the same since 2008.

I learned SSRS the hard way, from Books Online, before there were good 3rd party books available, so it is harder for me to make recommendations. I DO recommend that you learn some other way than Books Online! One 2008 book that I read and liked was Microsoft SQL Server 2008 Reporting Services Step by Step by Stacia Misner. Books by Stacia are likely to be good, as are books by Paul Turley. I'm sure there are other good authors as well, but I have met and talked with these two people at conferences, and I was impressed with their ability to explain things.

Another option is to move to SSDT and Visual Studio 2015. You should be able to find books and online articles describing these tools without too much trouble, as they are the current versions.

VS 2015 Community is a free download, as is SSDT. When combined, they give you the latest Report Designer, which is compatible with schema versions back to SSRS 2008. Visual Studio 2015 does not itself contain the SSRS project template -- that is part of SSDT for VS 2015. VS 2015 Community with SSDT is what I use for answering Experts Exchange SSRS questions, when I need to try things.

One thing to be aware of when using VS 2015 & SSDT with SSRS 2008 is that Report Designer always works with the latest (SSRS 2016) schema, and that is the version of the RDL file that you see in your report project. You can, however, set the target deployment version for the project to any version back to SSRS 2008. When you deploy or build the project, a copy of the RDL file is created in the output directory (bin/debug by default) that uses the correct schema for the specified target version.
LVL 35

Accepted Solution

Pawan Kumar earned 1000 total points
ID: 41860054

Author Comment

by:Lisa Randle
ID: 41860217
Thank you so much for the responses.  I think I'm going to go with both of your suggestions - the free download and Stacia Misner's book.  
I was trained and have used SSRS (mostly for creating databases), MySQL, Access and Excel for creating databases and simple to medium complexity reports.  I now am in a job that I really like that uses SQL Server Business Intelligence Development Studio (2008R2) and a stand alone version of Crystal Reports XI (reports are usually written in Crystal and the SQL code put in a BIDS project and tweaked to run correctly then deployed to our SharePoint site).  I somehow had BIDS already downloaded on my home laptop, probably sometime during the classes I took years ago but I don't remember using it for anything.  I'm not very sure about why I need to use it in the first place.  But this is what my new employer uses, so now I do.  I actually have Visual Studios 2013 installed on my computer at work also but because those who already do what I do here weren't familiar with it, they installed 2008 so they could show me how to use it with the system and databases here.  
Needless to say I feel "stupid" not knowing some things so I'm back in my own personal school trying to learn/refresh whatever or wherever I can - complex expressions, interactive parameters and the toolbox features...  I think these 2 suggestions will be extremely helpful as I've spent hours looking for solutions to issues I run into.
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

LVL 16

Expert Comment

by:Megan Brooks
ID: 41860571
One caution about using BIDS: I have found it to be very buggy at times, and not well supported by Microsoft. Of course with 2008/R2 there isn't any support for the older tools that are in extended support. VS 2016 with SSDT, on the other hand, is updated regularly. I haven't used it enough yet to say if it is less buggy, but I am optimistic because of the frequent updates. The same goes for SSMS 2016; I haven't used anything else since the RTM came out. It was a bit rocky at first, but worth the minor frustrations.

If you are on SSRS 2008 R2 then you pretty much have the full feature set that was available up until SQL Server 2016, and any of the tool versions should work with the 2008 R2 RDL schema (though they may not be backward compatible with each other if you try to switch around!), and any of the pre-2016 books should apply. I don't remember if SSRS 2014 made any schema changes; I skipped that version.

If you are on SSRS 2008 (no R2) then you are working with a subset, and you will have to avoid using the R2 features if you use anything other than the 2008 version of BIDS.
LVL 35

Expert Comment

by:Pawan Kumar
ID: 41871744
Hi Lisa,
Any feedback for us on this ?


Author Comment

by:Lisa Randle
ID: 41872132
Well, I've gone over almost half of the free download SQL Server 2012 Tutorials.  It was extremely helpful in explaining some of the things I may have done "by accident" which were actually correct or not correct.  I haven't had a chance to do the lessons yet (I'm a Nana again, yay (10/28/16) - so that's taken quite a bit of my time lately).
But I think that once I do some of the lessons, I may go ahead and order the SQL Server 2008 Step by Step book by Stacia Misner to fill in the gaps.  I find that many times I have "holes" in my thinking or do things without fully understanding why (ex: I know I have to Build before I Deploy, but why) .  Once it all gels together, the mastery can begin.
So I'm going to close the thread and make the Best Solution the free download even though I would like to make both answers the Best Solution.  My only reason is that its a very good resource and I will always love anything that's Useful and Free.
Thank you both!

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset.  This makes it troublesome when you need to display data from more than one dataset in the same data region.  SQL Serve…
Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
Integration Management Part 2
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

824 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question