Problem with showing Bar in Chart Report RRS feed

  • Question


    Hi All,

    I am using SQL Server 2008 Reporting Services Charts. I am using Chart Type as Column (3-D Cluster Cylinder). I am using X axis of graph as Time/Date field. I have two questions while displaying report in desired format:


    1. Currently I have grouped Category field on Date field fetched from database. It groups values per day. Now whenever there is no data for a particular date, it skips that date in chart. How can I show each and every date on report graph in user given date range?


    2. If there is no data for a legend of a chart, how can I display a Bar in Chart with value 0. This means, I have to show Bar with Zero value.

    Currently if I Show data labels of Chart, it just shows data for 0 value but does not show Bar with 0 value which could be residing as flat on X axis for a particular legend.


    Please help me resolving this issues for Chart graphs.


    Please let me know if you need any more details.


    Thanks in Advance.



    Ashwin B

    Tuesday, April 29, 2008 8:18 PM