Starting with SQL Reporting Services in ASP.NET Application: Part I

This Article (PART I and PART II) is mainly to know HOW TO START WITH SQL REPORTING SERVICES.

Part I will brief you on How to Design Reports in VS.NET. And Part II will describe how to upload your reports on the Server and what code to write in the Application to invoke those reports.

 

Implementing the SQL Reporting Services in your ASP.NET Application can be categorized in three main Processes.

  1. Creating your Reports i.e. .rdl Files (These file is used to design the Layout of your reports i.e. Look and Feel of the Report)
  2. Uploading your Reports (.rdl Files) in SQL Report Server.
  3. And writing code in your application to invoke these Reports from the SQL Report Server 

Understanding How the Reports works

 

111.gif

The above Diagram shows a simple architecture of a web scenario in which we have a Database Sever which is communicating to your Application Server. In addition we have a SQL Reports Server which contains the all the layout of the Reports i.e. your .rdl files along with the Database configuration.

The Application Server can communicate to your Database using ADO.NET (which is normally used by .NET Developers)

 

And Your Application Server will invoke your Reports via web service (provided by SQL Reporting Services).

 

Creating Reports


You can create reports as shown below:-

1. Select Business Intelligence Project - Report Project and give a name

222.gif

2. In the Solution Add a New Item

333.gif

3. Select a New Report and give a name.

444.gif

4. You can see three options Data, Layout and Preview. In the Data option define the Dataset

555.gif

5. Select the Sever and the Data Base and Test Connection.

666.gif

6. Insert the Query or Stored Procedure and Select the Command Type from the Drop Down.

777.gif

7. Execute the Query / Stored Procedure.

888.gif

8. Select the Layout Option and you can see the different Field which is been returned by the Query / Stored Procedure.

999.gif

9. Select the Tool box.

1000.gif

10. Drag and Drop a Table on the Report and select 2 - 3 Columns and right click. Select Merge Cells.

1001.gif

11. Insert Text in the Merged Cells.

1002.gif

12. Drag and Drop the Field on the Table in the report.

1003.gif

13. Go to the Preview Option and can see the reports preview ( how the report will look when called from the application.

1004.gif

14. You can save you reports in different formats. Select the format by clicking Save Icon.

1005.gif

15. For Example if you select PDF format the report, will be save in .pdf as shown.

1006.gif

16. For Example if you select EXCEL format, the report will be save in .xls as shown.

1007.gif

Coming Soon:-

Starting with SQL Reporting Services with ASP.NET Application - PART II

Part II will describe how to upload your reports on the Server and what code to write in the Application to invoke those reports.

Next Recommended Readings