Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

The Voice of the DBA

Steve Jones is the editor of SQLServerCentral.com and visits a wide variety of data related topics in his daily editorial. Steve has spent years working as a DBA and general purpose Windows administrator, primarily working with SQL Server since it was ported from Sybase in 1990. You can follow Steve on Twitter at twitter.com/way0utwest

Reporting Services – Building the first report

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.

Comments

No comments.

Leave a Comment

Please register or log in to leave a comment.