SSRS Dynamic Chart: trying to show all month on Axis even with a zero Value

• gissah

  SSCommitted

  Points: 1815

  More actions

  September 5, 2014 at 8:03 am

  #311356

  I have a dynamic Chart that displays list of sales log. I will love to be able to display every month on each chart regardless whether I had a sale data in a particular month. It should always show lets say Jan - Sept. Instead of showing Jan - Sept for one sales chart because I have data for it and only show Mar, April, May and August for another chart because the data is only in those month. I will love to show all months and say display Zero for the months that I don't have data for it . I have attached 2 images. Please let me know if I have explained my self well.

• gissah

  SSCommitted

  Points: 1815

  More actions

  September 5, 2014 at 11:13 am

  #1743582

  sorry

• gissah

  SSCommitted

  Points: 1815

  More actions

  September 5, 2014 at 11:14 am

  #1743583

  

  

• gissah

  SSCommitted

  Points: 1815

  More actions

  September 5, 2014 at 11:45 am

  #1743591

  I found an answer from another Microsoft forum.

  http://social.msdn.microsoft.com/Forums/sqlserver/en-US/54f694c9-4d69-4607-8156-e3afd8257d5e/report-builder-30-how-to-display-all-months-in-xasis?forum=sqlreportingservices