SQL Server Reporting services - just learning question two

I downloaded  SQL Server Data Tools 2012 - BI in order to start making reports.

Where do i go to start making reports in SQL server?  How can i open up and create reports in BIDS? Thanks

I have visual studio 2008 pro and the free version of sql server 2012.
vbnetcoderAsked:
Who is Participating?
 
Jim HornConnect With a Mentor Microsoft SQL Server Developer, Architect, and AuthorCommented:
Open Visual Studio 2012, which is essentially SQL Server Data Tools.
Then start a new project, and the New Project dialog should give you (in addition to a wompload of other stuff you won't use)

Installed >> Templates >> Business Intelligence >> Reporting Services
(as well as IS and AS)
0
 
vbnetcoderAuthor Commented:
I don't have Visual studio 2012.  Can it be downloaded? I do have Visual Studio 2008 Pro.
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
If you downloaded SQL Server Data Tools, afaik that means you have Visual Studio 2012.
Let me know if that's not correct.
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
vbnetcoderAuthor Commented:
I don't see it.  Would it have been downloaded as part of SQL Server Data Tools?
0
 
vbnetcoderAuthor Commented:
I found it now.  Thanks!
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Good deal.  Thanks for the grade.

>Where do i go to start making reports in SQL server?
btw I thought SSRS was very intuitive to learn based on my previous experience with Access and Crystal Reports.  It may look a little daunting at first, but once you get the hang of being able to use multiple data sets, and not just one, it's actually very liberating.
0
 
vbnetcoderAuthor Commented:
I have worked with Crystal reports.  I also did some work in SSRS 2008 V2 so hopefully this won't be to hard.  I have to do some real work for a client soon so i have to learn this fast.

Thanks for your help.
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
That's what happended to me, had to learn SSRS on the fly because that's want the client wanted.  A year and a half later, they were actually suprised when I told them I had no previous SSRS experience.

SSIS much different story, as the learning curve is pretty steep.
SSAS so far is proving somewhere in between.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.