Skip to content

How To: Report Authoring in SSRS 2005 – Part II (The Wizard)

January 25, 2009

Most people who are into SSRS must have started learning the system by creating their first report with the wizard. That is how I have learned SSRS myself. The wizard can help you build and design a basic report that might just be enough to fulfill your report requirements.

Our sample requirement can be built using the wizard. Warning: “This is a Graphic Intensive post” 🙂

The first step in this part is to open the SQL Server Business Intelligence Development Studio and create a new Report Server Project Wizard. We name this project as “SSRS2005Wiz”:

ssrs2k5wiz2

We click “Next” on the “Welcome to the Report Wizard” dialog:

ssrs2k5wiz3

The nextstep is to create the datasource. You can ask the help of your DBA or IT personnel if you do not know how to set it up:

ssrs2k5wiz4

The next step is to Design the Query. There are at least 2 ways to design your query. One is to create query using the Query Builder UI, or second, write your TSQL. Since we already have the TSQL we need for this demo, we can just write our TSQL:

ssrs2k5wiz51

For the purpose of this demo, we are creating a Tabular report:

ssrs2k5wiz6

Then we add a grouping on “Department Name”. You might have more columns and you might want a different design:

ssrs2k5wiz7

Choose a layout:

ssrs2k5wiz8

Then choose how report will look like:

ssrs2k5wiz9

Choose where you want your report deployed:

ssrs2k5wiz10

The last portion of the Wizard is to give the report a name, “SSRS2005Wiz”; the click “Finish” to complete the report:

ssrs2k5wiz11

Our report in action:

ssrs2k5wiz12

NEXT >> Designing the Report Manually

Creative Commons License
How To: Report Authoring in SSRS 2005 by Marlon Ribunal is licensed under a Creative Commons Attribution-Noncommercial-No Derivative Works 3.0 United States License.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

  • Archives


  • RSS SQLServerPedia

  • RSS SQL Crunch – Hot SQL Links

  • My Bookmarks

  • Business Career DBA Tool Events free ebook Humor IT News Members Only Microsoft MySQL Operating System Oracle Personal Reporting Services SQL Server SQLServerPedia Syndication SSC SSIS TSQL Tutorial Uncategorized Video

  • Software Blogs - BlogCatalog Blog Directory
  • %d bloggers like this: