Tuesday, February 14, 2012

SSRS Chart Anatomy 101

I did a presentation today on SSRS Charts through Pragmatic Works free training program called Training on the T's. It was a great experience and I appreciate everyone that checked it out. If you aren't already watching these webinars, then you should. I've learned a lot from past webinars and they've got some great webinars coming up in the near future.

Big THANK YOU to Devin Knight (Twitter | Blog) for inviting me to show my stuff.  The presentation slide deck is down below as well as a link with the SSRS Project Files from my demo. You will need to download and install the Contoso BI Demo Dataset in order to get these demo's working. The video for the webinar will always be available on the Pragmatic Works website after its done being uploaded (I'm told by the end of this week).

SSRS Chart Anatomy 101

View more presentations from aabundez

For some of you that asked the question about how to order months in their natural order, the SSRS Expression I used in the Sorting property of the Category Group properties was:
=MONTH(Fields!Calendar_Month.Value & " 1") 
As discussed, without this expression, SSRS will order the months alphabetically which won't make sense on your chart.

Here is a link to a Google Docs folder that has the Zip file for my presentation.

Thanks again! Look forward to more webinars in the future! :)


  1. thank you for the awesome presentation Angel, I learned few new tricks

  2. Thanks Paras. I enjoyed it as well. Glad it helped.

  3. Hi Angel, This is very good. Even I saw your demo in SQL saturday event. Do you have any document with steps for this , specifically for 1-click highlight and filter.


  4. Hi Ravi,

    Just finished Part 2 of improving data visualization in SSRS charts. It's this month's first post. Took my long enough! ;)

    Thanks for giving me that extra push to get it done.