Month with no data missing in Line chart or Sparkline RRS feed

  • Question

  • Hi,

    Developed a SSRS report where we need to show the monthy Trend.

    There are orgs which do not carry data for all months, hence to capture such month and show 0 against them, used CTE to generate a date table and then joined the table with soure to get the desired output. However, in terms of table, this works well but in chart, it seems to be a bit different. Please provide your inputs on acheiving the same behavior (display missing month) in a line chart. Below is the image of the current chart, displaying correct trend as tabuler report but missing months in the line sparkline/chart.

    sample trend chart 

    Thanks !

    Wednesday, October 17, 2012 10:57 PM


  • Hello Niraj,

    The Chart control can't guess which values may are missing and even if, which value to displa for.

    You have to ensure to select all values you like to show in the Chart. You e.g. have to create a table with all month and then outer join to you data table, to get for all month a value, even if its null.

    Olaf Helper

    Blog Xing

    • Proposed as answer by Syed Qazafi Anjum Saturday, October 20, 2012 9:46 AM
    • Marked as answer by Mike Yin Thursday, October 25, 2012 6:28 PM
    Saturday, October 20, 2012 6:54 AM