.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Articles >> DataBase >> Post New Resource Bookmark and Share   

 Subscribe to Articles

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

Posted By:Karthikeyan Anbarasan       Posted Date: March 31, 2011    Points: 200    Category: DataBase    URL: http://www.dotnetspark.com  

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.
 

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.

You can refer the other articles of this series here.

Basics on how to create a report - SQL Server Reporting Services (SSRS) - Part 1

Deploying a Report - SQL Server Reporting Services (SSRS) - Part 2

Steps


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


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


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


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


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


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


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


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.


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



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




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.


 Subscribe to Articles

     

Further Readings:

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend