locked
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.

     

    Regards,

    Ashwin B

    Tuesday, April 29, 2008 8:18 PM

Answers