Reporting Services (SSRS) Part 18 - Charts

By Andrew Gould

You can download the script to create the Movies database used in this video at the following link:

[krismaly]

I enjoyed watching this video and recommend others to watch.

Host is a nice teacher with good capacity in explaining the feature of CHART report.

Thanks for educating the community and appreciate your volunteership.

Thanks a lot

[alxvseti]

00:36 Adding a Chart to a Report
01:56 Assigning Fields to a Chart
03:30 Formatting Chart Axes and Labels
15:14 Adding a Series Group to a Chart
17:21 Changing the Chart Type
18:46 Formatting Series Groups

[Slarti]

Thanks - as usual your tutorials are at just the right level and it's all free - amazing!

[maksympt]

Thank you so much! Interval=1 is exactly what I was looking for!

[littlexeven]

All of your tutorials are excellent and incredibly useful. Thanks so much for making these.

[rosehuang]

this tutorial is awesome! it's very clear and easy to follow. Thanks!

[GreenLion]

thanks for this nice examples and explanations with SSRS !

[lucylee]

You are the best.  Your videos are the best.  Thank you!!

[sthembisogumede]

Keep up the good work...damn good and simple

[omhung]

Thanks! Awesome tutorials, very helpful!

[andyyan]

Thank you very much for your tutorial! Clear presentation and nice soft voice! May I ask a question, if my X-axis of a bar chart if 0, 1, 2, 3, I tried to use =IIF(Fields!XX.Value=0, "Not Rated", Fields!XX.value) in the "set number and date formatting options". The 0 does not change to "Not rated". Even tried =IIF(Fields!XX.Value="0", "Not Rated", Fields!XX.value). Same result. Do you have any idea? Thank you very much!

[rosehuang]

hi there, I have a question about the legend. Is there anyway we can change the shape of the legend? For example if the legend is for a bar chart, it will display as rectangle by default. Now I have to make it a square according to requirement from client. Can I do this? I couldn't find anyway to change the shape in legend properties...

[foxybark]

Do you have a video on creating a bubble chart in SSRS? Showing specifically how to get values on X and Y axis and how to change all the markers to bubbles?

[krismaly]

I enjoyed watching this video and recommend others.

Can you make a video to draw 4th Polynomial Trend Line curve on Column Chart in SSRS 2012?

Appreciate your help?

Thanks for educating the community and appreciate all your efforts.

[gwynhwfar]

I notice that when you set the colours using SWITCH() that the legend colour for U is the default colour not the one set for U. i.e. lime green is showing in the column chart, but Black (or fuchsia, it depends on your default colour scheme) is showing in the legend for U.

[lanhuang]

Thanks for sharing.
When I create a bar chart in my report, I also need a line chart on this .But the bar chart has a series group, and I do not want the line chart use this series group. The category group are the same. After I have dragged the line chart field into the value
the legend doubled, this is what I do not want to see.
Know how to do this ?
Thank you

[lotusrhythms]

Thanks for the tutorial. With SSRS chart, the text always seems to be blurry. Have you come across similar issue, and any suggestions? Thanks

[johntwalkerv]

Love this playlist of tutorials. Much appreciated!!!

Question in regards to the first portion of this film. I don't know if you filtered your dataset or what, but I seem to get a large number of columns, rather than 20 you get during the second preview @ 3:28. I assume I am getting a chart that includes every film. How did you end up with only 20? Thanks in advance!!

[venkatavempati]

Excellent explanation..can you please make a video on cascading parameters with stored procedures?. i want to give the scenario like this.

stored proc : if this stored procedure has two parameters director name, film name how do we get multiple values of director name and when end user select one director name he has to get ability to select movies in the film name parameter..

[akrilicwarlock]

At 17:10, your bars are very thin. I am having this issue with my chart. I have given the chart enough width but still thins the bars depending on the count of categories (X-Axis). Is there a way to set the width of the bars to a static?