Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS Column Chart with NULL dates Expand / Collapse
Author
Message
Posted Tuesday, June 25, 2013 6:14 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 15, 2013 7:24 AM
Points: 3, Visits: 22
Hi All,

I have a column chart which should show the totals of complaints over the last 6 months. My dataset returns the following:-

YYYYMM Type Count
2013-02 A 1
2013-04 A 1
2013-05 A 1

Is it possible to show a chart with all 6 months labels but with a zero data point ?

I've tried various combinations but nothing appears to work.

Many thanks for your help.
Gary
Post #1467093
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse