Step By Step SSRS in 11 Hours: Hour 9

Contents

 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.