Step By Step SSRS in 11 Hours: Hour 9

Loading

Step By Step SSRS in 11 Hours: Hour 9

Contents

Hour 1: What is SSRS and determine whether it is installed

SSRS 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.

Next >> Hour 10: Report deployment