Step By Step SSRS in 11 Hours: Hour 9

Contents

• Hour 1: What is SSRS & Determine 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
  

 Report with Chart

• Step 1: To add the report, right-click on "Reports", select "Add" and click on "New Item".
  
  
  
  
• Step 2: Select "Report" and provide the report name.
  
  
  
  
• Step 3: Add a data source to the report data, right-click on "Data Sources" and click on "Add Data Source".
  
  
  
  
• Step 4: Provide a data source name and select shared data source reference.
  
  
  
  
• Step 5: Add a dataset in the report data, right-click on "Datasets" and click on "Add Dataset".
  
  
  
  
• Step 6: Provide a dataset name and select shared dataset.
  
  
  
  
• Step 7: Right-click on the design surface, select "Insert" and click on "Chart".
  
  
  
  
• Step 8: Select any one chart type from the list, for example column, Line, Shape, Bar and so on.
  
  
  
  
• Step 9: Select and click on the chart area and we will have a chart data. Go to Category Groups and click on the "+" symbol, it shows all the fields and Select "CountryName" as the group category.
  
  
  
  
• Step 10: In the preceding the Category Groups have Values, in that click on the "+" symbol and again we will have all the fields and Select "StateName" as values.
  
  
  
  
• Step 11: Click on the Black down arrow attached with StateName and select "Show Data Labels".
  
  
  
  
• Step 12: Now our report design is ready.
  
  
  
  
• Step 13: Click on the "Preview" tab and the chart is displayed with the country and the number of states.