SQL Reporting Services - Absolute Beginner Questions

Posted on 2007-10-18
Last Modified: 2013-11-26
I need to learn to build reports using SQL Reporting Services.  I learn best by jumping in with both feet.

My initial searches for online tutorials show some great informaiton, but they already assume I know some stuff I haven't learned yet.  I'm hoping there is an expert here who can answer a few absolute beginner questions, to get me past the "zero knowledge" hump.

1. I'll be using Visual Studio 2005 (VB.NET) but when I go to File -> New Project, I don't see anything about Reporting Services.  Do I need to install something first?  How do I begin my first project?

2. I currently have some power users who develop some of their own Crystal Reports.  Are there other "report creation" or "report design" tools, they can use to create reports in SQL Reporting Services... without me having to purchase the entire Visual Studio .NET suite for each of my power users?
Question by:AptDev
    LVL 1

    Expert Comment

    What version of SQL Server is being used - 2000 or 2005?
    LVL 1

    Accepted Solution

    Further to that:

    1) In Visual Studio 2005 the project should be displayed under File - New - Project - Business Intelligence Projects - Report Server Project. If using SQL Server 2000 then reporting services is a separate install (I had to call Microsoft to obtain the CD). If using SQL Server 2005 then it should show up already providing reporting services was chosen as a component to install during the initial SQL Server 2005 install

    2) - Under the Report Design heading - "Do I need Visual Studio 2005 to design reports?" - answer is no for SQL Server 2005 as it comes with Business Intelligence Development Studio. Again, it may or may not show depending on if it was chosen as a component to install during the initial SQL Server 2005 install.


    LVL 18

    Assisted Solution

    Reporting Services also has the Report Builder. This is a web application that your power users can use to create reports. This isn't as powerful as BIDS or Crystal, but would be worth a look.
    LVL 8

    Assisted Solution

    by:davecorun has many guided tours, webcasts, demos, etc.

    You need to install the product to have access to the report templates, as mentioned above.

    // Dave

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
    JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    759 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

    10 Experts available now in Live!

    Get 1:1 Help Now