Step By Step SSRS in 11 Hours: Hour 2

Introduction

• Hour 1: What is SSRS and determine whether it is installed
• Hour 2: Report using wizard
• Hour 3: First SSRS report
• Hour 4: Report with parameter
• Hour 5: Custom template
• Hour 6: Drill down report
• Hour 7: Sub report
• Hour 8: Report with style
• Hour 9: Report with chart
• Hour 10: Report deployment
• Hour 11: RDL file to ASP.Net

• Create a database called "SSRSDemo".
• Execute the attached .sql file in the preceding database

Create SSRS Report using Wizard

• Click on the "Start" button.
• Go to "All Programs".
• Expand "Microsoft Visual Studio 2012".
• Click on "Visual Studio 2012".
  
  

• And you will have a "Start Page" of Visual Studio 2012.
  
  

• Click on the "File" Menu.
• Expand "New".
• Click on "Project…" to create a new project.
  
  

• Expand "Business Intelligence" under the Installed Templates from the left panel.
  
  
• Click on "Reporting Services".
  
  
• Select "Report Server Project Wizard" from the center panel.
  
  
• Provide your desired name for the project.
  
  
• Select an appropriate location for where you want to save this project.
  
  
• Check the "Create directory for solution" checkbox to create a separate directory for this solution.
  
  
• Click on the "OK" button.
  
  

• Check the "Don"t show this page again" checkbox if you do not want this wizard to show this page.
• Click on the "Next" button.
  
  

• Select the "New data source" radio button.
• Give the desired name of the data source.
• Select "Microsoft SQL Server" from the "Type" drop down list.
• Click on "Credentials…" for the connection string.
  
  

• Select the Server name of your local machine.
• Select the "Use SQL Server Authentication" radio button.
• Provide a SQL Server Authentication User name.
• Enter the password in the password text box.
• Check the "Save my password" checkbox if you want to save your credentials.
• Select the "Select or enter a database name:" radio button.
• Select the database to which you want to set the connection.
• Click on the "Test Connection" button to ensure the connection can be established.
  
  

• Once it has succeeded, click on the "OK" button.
  
  

• Verify the connection string in the connection string text box.
• Check the "Make this a shared data source" check box to make this data source a shared data source.
• Click on the "Next" button.
  
  

• Click on the "Query Builder…" button to design a query.
  
  

• Right-click on the query designer.
  
  

• Click on the "Add Table…" menu item to add table/s.
  
  

• Select the table from which you want to retrieve data.
• Click on the "Add" button.
  
  

• Select the column/s you want to show in the report.
  
  

• Verify the query string.
• Click on the "Next" button.
  
  

• Select the "Tabular" radio button.
• Click on the "Next" button.
  
  

• If you select the "Matrix" radio button, the report pattern looks as in this.
  
  

• Select the field/s from the "Available fields:" list.
• Click on the "Details>" button.
  
  

• This will add the field/s into the "Displayed fields:" list.
  
  

• Select the table style.
  
  

• The following styles are available to select for your report.
  
  

• Click on the "Next" button.
  
  

• Provide an appropriate name for your report.
• Verify "Report Summary".
• Click on the "Finish" button.
  
  

• In "Design" mode your report looks as in this.
  
  

• Click on the "Preview" tab to preview your report.