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.
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)
Uploading your Reports (.rdl Files) in SQL Report Server.
And writing code in your application to invoke these Reports from the SQL Report Server
Understanding How the Reports works
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).
You can create reports as shown below:-
1. Select Business Intelligence Project - Report Project and give a name
2. In the Solution Add a New Item
3. Select a New Report and give a name.
4. You can see three options Data, Layout and Preview. In the Data option define the Dataset
5. Select the Sever and the Data Base and Test Connection.
6. Insert the Query or Stored Procedure and Select the Command Type from the Drop Down.
7. Execute the Query / Stored Procedure.
8. Select the Layout Option and you can see the different Field which is been returned by the Query / Stored Procedure.
9. Select the Tool box.
10. Drag and Drop a Table on the Report and select 2 - 3 Columns and right click. Select Merge Cells.
11. Insert Text in the Merged Cells.
12. Drag and Drop the Field on the Table in the report.
13. Go to the Preview Option and can see the reports preview ( how the report will look when called from the application.
14. You can save you reports in different formats. Select the format by clicking Save Icon.
15. For Example if you select PDF format the report, will be save in .pdf as shown.
16. For Example if you select EXCEL format, the report will be save in .xls as shown.
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.