http://www.sqlservercentral.com/blogs/steve_jones/2010/05/26/reporting-services-_1320_-building-the-first-report/

Printed 2014/04/20 07:55AM

Reporting Services – Building the first report

By Steve Jones, 2010/05/26

One of my goals this year was to spend some time learning Reporting Services. Not necessarily do the 10,000 hours to become an expert, but perhaps the 100 hours or so Andy Warren mentioned in his Professional Development presentation.

I’ve done a little getting SSRS installed and running on a few machines, and decided to document a basic report with the BIDS SSRS wizard. It’s basic, but it shows the easiest way to build a basic report.

First start up BIDS and create a new project.

SSRS_001

The wizard starts with an opening screen, which is a waste. So be sure you check the “Don’t show this page again” box.

SSRS_002

The first thing you get is a data source box, which is needed for any report.

SSRS_003 

I also checked the “Shared data source” box so that this source can be shared on other reports.

SSRS_004

You have to enter credentials, and I picked a new login/user that I set up with minimal SELECT rights to a couple databases.

SSRS_005

Next is the query

SSRS_006

I picked the Query Builder, though you can just enter the query. The first screen shows the basic designer.

SSRS_007

If you right click in the top pane, you can select the “Add table”

SSRS_008

and you’ll get a list of tables.

SSRS_009

You can double click a table to add it, or select it and click “Add”. Click close when you are done.

SSRS_010

You get your table(s) in the top pane, and as you select columns, they get added in the bottom pane as part of the query. If you close the Query Builder, you see your query back in the wizard.

SSRS_011

The next step in the wizard is to pick a type of report; I left mine as a tabular report.

SSRS_012

The next screen shows some grouping option. For basic reports, you add things to the details. If you want to group up by data that is repeated, like by Customer, add those in other boxes.

SSRS_013

Choose a style.

SSRS_014

And then pick a report name. 

SSRS_015

I checked Preview Report,

SSRS_017

and then I’d see the report in BIDS. 

SSRS_018

Next, need to deploy this to the Report Server and make it work.


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.