Home  >  Blog  >   SSRS  > 

Adding Charts to a SSRS Report (Report Builder)

In SSRS, charts are the best option for summarising data in a visual way in a paginated report. It's important to select the right chart type for the information you're presenting. This blog will walk you through the steps involved in adding the charts to SSRS Report Builder.

Rating: 4
  
 
4080

Adding charts to a report

Charts add visual appeal to a report and can quickly elevate a report from looking just like a spreadsheet of data to powerful tools for monitoring performance over time, or for highlighting areas of concern in business.

If you would like to become SSRS (SQL Server Reporting Service) certified professional, then visit Mindmajix - A Global online training platform: "SSRS Training and Certification Course".. This course will help you to achieve excellence in this domain.

In this Try it, you will return to the Summary Sales report and add a column chart to show sales over the selected year.

Chart Data
THE CHART DATA PANEL, OPENED WITH A SINGLE CLICK ON THE CHART

Try it

1. Open the Summary Sales report

2. Move the table over to the left side of the design surface, so that there is plenty of room for the chart on the right.

3. From the toolbox, drag a chart onto the design surface and position it to the right of the table.

4. When you finish dragging the chart, the Select Chart Type window opens. Select the first type of column chart and click OK.

5. Click onto any part of the chart to open the Chart Data panel.

 MindMajix YouTube Channel

6. Click the first + button to add a value and select AdventureWorks > Sales Summary > Total.

7. In the same way, use the next + button to select Month as the category. This time, you will be able to go directly to Month, as the SalesSummary dataset was selected in the last step.

8. Select the Month category in the Chart Data / Categories panel and edit the label property. Do this by either clicking on the small down arrow to the right of the Month category, or just find the label property in the Properties window on the right of the screen.

9. Add the MonthName function to the label property so that it becomes an expression that displays the name of the month instead of the number. (Use the Expression editor for this)

10. The expression should be: =MonthName(Fields!Month.Value)

11. Edit the chart and axis titles by clicking on them and typing something descriptive. If you’re feeling adventurous, see if you can work out how to get the selected year into the chart title (hint: use an expression and select a parameter)

Sales for

12. Preview the report and select a year to see the chart.

Frequently Asked SSRS Interview Questions & Answers

 

List of Related Microsoft Certification Courses:

 SSIS  Power BI
 SSAS  SQL Server
 SCCM  SQL Server DBA
 SharePoint  BizTalk Server
 Team Foundation Server  BizTalk Server Administrator

 

 

Join our newsletter
inbox

Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!

Course Schedule
NameDates
SSRS TrainingApr 01 to Apr 16
SSRS TrainingApr 04 to Apr 19
SSRS TrainingApr 08 to Apr 23
SSRS TrainingApr 11 to Apr 26
Last updated: 30 March 2023
About Author
Remy Sharp
Ravindra Savaram

Ravindra Savaram is a Content Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.

Recommended Courses

1 /15