Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 368
  • Last Modified:

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.
0
vbnetcoder
Asked:
vbnetcoder
  • 4
  • 4
1 Solution
 
Jim HornMicrosoft 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
Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

 
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

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now