Sql Report Builder - Chart
Posted on 2015-01-29
I have created using microsoft report builder report , its number of stocks sold in the financial year.
My questions is
Some months there is no sold its zero. after creating bar graph,Bar graph is ignoring 0
for example May there are no item sold -0
Then Bar graph is not showing May and starting from June.
What i need to show is if there is zero(0) in any month i,i need to show in the bar graph.
furthermore i have to show 1/4/2014 to 31/3/2015 if any sold is blank
Can some one show me how to that, any advice is highly appriciated.