Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 150
  • Last Modified:

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
0
ukerandi
Asked:
ukerandi
1 Solution
 
rajeevnandanmishraCommented:
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now