Floating FB popout byF5debug

SQL Server Reporting Services (SSRS) – Part 3 – Create Report without Wizard

 

This is part 3 of series of article on SSRS.

 

Introduction

In this article we are going to see on how to create a report without using the wizard which we used in our first article. The idea behind this article is we will have full control over the creation of report and we can customize it at any level as per our requirement.

[more]

Steps

Let’s open BIDS and create a project under Report Server Project as shown in the below image

clip_image002

Now right click on the Report on the right hand side and select Add New item à Report as shown in the below screen

clip_image003

Now you will see the report designer window as shown in the below screen.

clip_image004

Here we have 3 tabs as Data, Layout and Preview. Data tab is used to select which data should we need to show in the report. Clicking on the Datasetà New Dataset as shown in the below screen will help us to select the data source

clip_image005

Now we can write out own query in order to fetch the details which we can show in the reports as shown in the below screen

clip_image006

Now we can shift to the next tab which is LAYOUT tab, where we are going to design the report based on our requirement. Drag and drop the table control from the tool box to the layout screen then your screen should look similar to the one below

clip_image007

Now go back to the Dataset tool pane, and select the columns which should appear in which part of the report as shown in the below screen

clip_image008

We can change the properties of the table report structure by pressing F4 will open the properties tab. You can see the below screen for the different options available to format or customize your report.

clip_image009

Now press F5 to run the application. It will ask for the Login credentials as shown below. Once we give the credentials it will fetch the report

clip_image010

clip_image011

Without running the project itself we can check the result by clicking on the 3rd tab in the project which is nothing but the Preview tab as shown in the below screen

clip_image012

Conclusion

In this article we have seen on how to create a report in BIDS without using the Wizard and how to customize the report based on our requirement.

About Author: Karthikeyan Anbarasan, Microsoft MVP (Most Valuable Professional) in ASP.NET/IIS Architecture. He is the Founder and Chief Editor of the www.f5debug.net website and has authored books on Windows Phone and Business Intelligence(SSIS). He is also a Passionate Speaker and a Blogger on Microsoft Technologies.

You can Join Me On: Facebook, Twitter, Google Plus, LinkedIn

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

Recent Posts

Random Posts

Most Viewed

URL Shortner

Create your own short urls!!!

Site Counter

free counters

Disclaimer

This is a personal weblog. The opinions expressed here represent my own and not those of my employer. For accuracy and official reference refer to MSDN/ TechNet. I have documented my personal experience on this blog.

Protected by Copyscape Web Plagiarism Finder

Site Meter