Solved

Sql Report Builder - Chart

Posted on 2015-01-29
1
124 Views
Last Modified: 2015-02-07
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
Comment
Question by:ukerandi
1 Comment
 
LVL 9

Accepted Solution

by:
rajeevnandanmishra earned 500 total points
ID: 40579354
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question