Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

This tutorial will help you to get started with SQL Server Reporting Services (SSRS)

Getting Started with SSRS (SQL Server Reporting Services)

Getting Started with SSRS - Part 3 - Designing a report using Report Designer

Nov 12 2011 12:00AM by Karthikeyan Anbarasan   

Introduction

This article would cover how to design a report using the Report Designer. In our previous article, we saw the option on designing a report using the Report Wizard with just the configurations used to design and develop the report with some simple steps. However, in this article we will design every component on our own with the help of the Report Designer available with the SQL Server Business Intelligence Studio templates. Let us see the step-by-step process on how to design the report with the Report Designer.

Steps

The first step towards our task is to open Business Intelligence Studio. To open it, we would need to navigate through Programs >> Microsoft SQL Server Denali / Microsoft SQL Server 2008 as per the installed version and select Business Intelligence Development Studio as shown in the screen below.

Launching SQL Server Business Intelligence Studio

This will open Visual Studio. It is the Business Intelligence Development Studio for SQL Server as shown in the screen below.

SQL Server Business Intelligence Studio

Now select File >> New >> Project to create a new project. We can directly use the shortcut Control + Shift + N to open a new project as shown in the screen below.

Creating a New Project

Once we have selected the New Project, a list of templates will be available as shown in the screen below.

List of Business Intelligence Templates

Select Report Server Project template from the list of templates available and provide a valid name for the project as shown in the screen below.

Selecting the new Report Server Project

Clicking on OK will create a project and open the project in the SQL Server Business Intelligence Studio as shown in the screen below.

Solution Explorer view of Report project

Initially, there are no files created and only two folders are available. The next step is manually adding a report to the project. To add the report, click on the Reports folder in the solution explorer and select ADD >> New Item as shown in the screen below. Selecting Add New Report will go directly to the Report Wizard that we have already covered in the previous article.

Selecting a new Report Item

Now, a window will be displayed with a list of available items that can be added to the project as shown in the screen below. Select Report from the list, provide a valid name and click on Add button to add a report to the project.

Specifying Report Name

This will add the report to the project and open the Report Designer to allow designing the report as per the requirement as shown in the screen below.

Report added to the project solution

Next step is to go to the Tool Box. Then drag and drop a table to design the report as shown in the screen below. Now we need to configure the data set first in order to design our report table.

Selecting the Table designer

To do the configuration we would first need to create a data source. This can be achieved by clicking on the New button. It will open a window where we would need to supply the details of the connection string as shown in the screen below. Configure it based on the database from which the data for the report needs to be collected.

Selecting the Data source

Clicking on OK will go back to the old window with the data source available for pulling the data for the report. Now click on the Query Designer button to build the query required to pull the data as shown in the screen below.

Selecting Query Designer

Clicking on Query Designer will open a new window as shown in screen below. Write the query required to fetch the data. In this example, we are going to use the Authors table from the Pubs database. Once we write our query, click on the Execute button to get the complete details of the data for our reference to finalize the query. We can perform as many executes as required to get a final data as per the business requirement as shown in the screen below. Once we are done, click on OK to close this window and navigate back to the wizard.

Selecting the Query to fetch data

Clicking on OK button will go back to the previous window and we can see the selected query available in the list as shown in the screen below.

Customized Query to fetch data

Click on the OK button to complete the process. With this, we can see the table created in the designer view as shown in the screen below. We can customize the table as per our requirement.

Draft table design window

Now we need to customize the report by dragging the outline of the table to the required length and width as shown in the screen below.

Customizing the design of the table

Next, we need to go to the data source we have created and select which columns should appear in which part of the report. To do this, first select the cell and click at the right side corner of the cell to get the list of columns as shown in the screen below:

Selecting the required table columns

Select the columns based on the requirement and edit the headers to the required customized format as shown in the screen below.

Final design of the report

Click on the Preview tab to view the report’s preview as shown in the screen below.

Preview window of the report

Now we can see the report output in the preview mode. We can build and execute the project if we are satisfied with the report output. Else, we can go ahead and change the report design based on the business requirement. Since we have not used any inbuilt wizard, we need to manually do all the customization (Selecting Styles formats etc.). Now we have made some customization as shown in the screen below.

Customized report design

Press F5 or hit the Play button from the tool bar to build and execute the project to get the report output. However, we will get an error message that the start-up report project is not specified as shown in the screen below.

Report Designer Error

Go to the properties of the project and select the report as shown in the screen below. Since we have not used any wizard to build the report generation, these steps needs to be performed manually.

Report properties

Once again, press F5 or Play button from the tool bar to build and execute the project. This will present the result as shown in the screen below.

Final Report Output

Summary

Thus, in this article we have seen how to design and generate report from scratch without using the Report Wizard with the help of SQL Server Business Intelligence Studio.


Karthikeyan Anbarasan
52 · 4% · 1176
9 Readers Liked this
Dinesh Sodani Liked this on 11/28/2011 11:34:00 PM
Profile · Blog · Facebook · Twitter
Khyati Patel Liked this on 11/29/2011 2:08:00 AM
Profile · Facebook · Twitter
Jacob Sebastian Liked this on 11/29/2011 8:00:00 PM
Profile · Blog · Facebook · Twitter
Nirav Liked this on 11/29/2011 11:21:00 PM
Profile · Blog · Facebook · Twitter
Neha Mewara Liked this on 2/9/2012 12:35:00 AM
Profile
Guru Samy Liked this on 3/23/2012 3:32:00 AM
Profile · Blog
urvij Liked this on 12/19/2012 7:12:00 AM
Profile
skganguly Liked this on 2/7/2013 8:27:00 AM
Profile · Blog · Twitter
Bala Krishna Liked this on 2/8/2013 10:12:00 AM
Profile
9
Liked



Submit

7  Comments  

  • good posting

    commented on Nov 22 2011 2:00AM
    Deepak kelath
    210 · 1% · 222
  • Thanks Deepak...

    commented on Nov 30 2011 9:48PM
    Karthikeyan Anbarasan
    52 · 4% · 1176
  • how to add user interacting fields in the report? For instance search keywords???

    commented on Nov 30 2011 10:31PM
    savanthakkar
    2754 · 0% · 4
  • I'm trying to do it in 2005. But when I ran the project, got the following error message.

    "The project cannot be deployed because no target server is specified. Provide a value for the TargetServerURL property in the property pages for this project."

    commented on Dec 1 2011 12:45AM
    moniks
    3057 · 0% · 2
  • Thanks for such a nice post. But culd you also post for how to create chart reports ?

    commented on Dec 1 2011 8:00AM
    Sana ali
    165 · 1% · 297
  • Hi Karthikeyan,

    Am really happy to find such kind of tutorials with neat explanations.

    Thanks for your original post.

    commented on Feb 8 2013 10:23AM
    Bala Krishna
    83 · 2% · 676
  • HI Moniks,

    Hope doing well now , when you deplaying the you need to set some properties in Project level.

    GOTO-->PROJECT-->RIGHT CLICK-->PROPERTIES---> TargetServerURL= http://localhost/ReportServer. Then only deploy will get success.

    Thanks.

    commented on Feb 8 2013 10:28AM
    Bala Krishna
    83 · 2% · 676

Your Comment


Sign Up or Login to post a comment.

"Getting Started with SSRS - Part 3 - Designing a report using Report Designer" rated 5 out of 5 by 9 readers
Getting Started with SSRS - Part 3 - Designing a report using Report Designer , 5.0 out of 5 based on 9 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]