Solved

SQL Server Reporting services - just learning question two

Posted on 2014-04-24
8
352 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 66

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 66

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
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

 

Author Comment

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

Author Closing Comment

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

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 66

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

Create CentOS 7 Newton Packstack Running Keystone

A bug was filed against RDO for the installation of Keystone v3. This guide is designed to walk you through the configuration for using Keystone v3 with Packstack. You will accomplish this using various repos and the Answers file.

Question has a verified solution.

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

Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

636 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