Problem with summarised values in cross tabs
I am using crystal reports 2008 and I have created a cross-tab with change of year forming the columns and change of month forming the rows. The problem I am having is the cross tab is filling in rows for the later months of 2009 with 0 where they should be blank as data doesn't exist for these months yet. When I graph this with months on the x-axis and a line for each year, the line for 2009 dives to 0 where I would like it to only draw the line for the values that exist.
I hope this make sense.