Solved

SQL Server Reporting services - just learning question two

Posted on 2014-04-24
8
345 Views
Last Modified: 2016-02-18
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.
0
Comment
Question by:vbnetcoder
  • 4
  • 4
8 Comments
 
LVL 65

Accepted Solution

by:
Jim Horn earned 500 total points
ID: 40019948
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
 

Author Comment

by:vbnetcoder
ID: 40019972
I don't have Visual studio 2012.  Can it be downloaded? I do have Visual Studio 2008 Pro.
0
 
LVL 65

Expert Comment

by:Jim Horn
ID: 40020016
If you downloaded SQL Server Data Tools, afaik that means you have Visual Studio 2012.
Let me know if that's not correct.
0
 

Author Comment

by:vbnetcoder
ID: 40020034
I don't see it.  Would it have been downloaded as part of SQL Server Data Tools?
0
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 

Author Closing Comment

by:vbnetcoder
ID: 40020127
I found it now.  Thanks!
0
 
LVL 65

Expert Comment

by:Jim Horn
ID: 40020142
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
 

Author Comment

by:vbnetcoder
ID: 40020163
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
 
LVL 65

Expert Comment

by:Jim Horn
ID: 40020210
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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

867 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now