My good friend asked me to write a simple tutorial which may describe the using of SSRS report with the ASP.NET web form together in turn to get the input report parameters from the web form user input, implement the any complex business logic inside the business logic class separated and provide the report output to the ASP.NET web form back as the PDF output.
From the architectural point of view we should implement 3-tier solution with the User Interface, Business Logic and Data Access Layers.
Tutorial Part 1. The MS SQL Database and project structure initialization.
1. Create the MS SQL 2008 databese for the tutorial.
1.1. Create the new empty database named 'ssrstutorial' in the Microsoft SQL Server Management Studio.
1.2. Run the simple SQL script from
here which create the simple table 'User' and stored procedure 'GetUsersByName' in the database created at step 1. Also the new user with login 'user' and password '1234573' and role 'dbowner' will be created.
2. Create new empty ASP.NET Web Application project.
2.1. Create new folder named 'report' at the application
2.2. Add 'New Item->Visual C#->Reporting->Report' named report1.rdlc to the new folder 'report' created at step 2.1.
2.3. Add 'New Item->Visual C#->Data->LINQ to SQL Classes' named ssrstutorial.dbml to the root project folder. Thanks to this database model added to our project we will have the possibility to use the LINQ features in our business logic classes if it will be required.
2.3.1. At the LINQ database model add the new database connection to your SQL server and database 'ssrstutorial' been created at the step 1.
2.3.2. Drag and drop the table 'User' from the Server Explorer window into the middle panel of Data Model and Drag and drop the stored procedure 'GetUsersByName' from the Server Explorer to the right column of Data Model.
2.3.3. Finally, you will have the Table and Stored Procedure stubs in your local LINQ Data Model as it reflected at the image below.
End of part 1.
To be continued.