Sql Report Builder - Chart

Hi All,

I have created using microsoft report builder report , its number of stocks sold in the financial year.
(1/4/2014- 31/3/2015)
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.
Many Thanks
LVL 10
ukerandiAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
rajeevnandanmishraConnect With a Mentor Commented:
Hi,

In my opinion you can create a month table with below structure:
Id        Month    MonthName
1         4              April
2         5              May
....
12       3            March

Now make a left outer join of your data with this table. This makes sure that you always get 12 months data (will be zero for which month there is no data).

If still there is problem, then please pass on  your current query.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.