Learn
Home
Jobs
Books
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
C# Corner
«
Back to Home
Learn SSRS In 11 Hours
Topics
Hour 1. What is SSRS
Hour 2: Report using Wizard
Hour 3: First SSRS report
Hour 4: Report with Parameters
Hour 5: Custom Template
Hour 6: Drill Down Report
Hour 7. Sub Reports
Hour 8. Report with Style
Hour 9. Report with Chart
Hour 10. SSRS Report Deployment
Hour 11. RDL file to ASP.NET
Hour 9. Report with Chart
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
Author
Akshay Patel
0
28.6k
7.6m
Previous «
Hour 8. Report with Style
Next »
Hour 10. SSRS Report Deployment