Solved

Report Builder Chart

Posted on 2014-11-02
8
115 Views
Last Modified: 2015-02-02
Hi,
According my query some time there is no data for certian months.
For example April Total:40, But some time May or June Nor records, becuase of that according my sql query no records going to display on that months.
But i need to show in my Bar graph Aril 2014  to current month(November),

Can some one give me a idea or any comments Highly apriciate.

I found click on Horizontal Axis and goto Options ->Interval type=Number/Months and Interval=1

But its showing only numbers, I try using insert formula to Interval Type Monthname("Month") But no luck
I need to show April,May...until November.

Please check the My attached files With steps
Month(Complain.[Cl Close Date])as Monthname

In the Database this Datetime Filed(Cl Close Date)
Thx
1.png
2.png
3.png
4.png
0
Comment
Question by:ukerandi
  • 4
  • 2
8 Comments
 
LVL 24

Expert Comment

by:Phillip Burton
ID: 40418539
In Horizontal Axis Options - Axis Options - Axis range and interval - Interval type, I notice it says "Days". Does it make a difference if you change that to "Months"?
0
 
LVL 24

Expert Comment

by:Phillip Burton
ID: 40418542
You said "it's only showing numbers" - what numbers was it showing?

I would take off (at least temporarily) the MMM custom format, because that is making what it is reporting.
0
 
LVL 10

Author Comment

by:ukerandi
ID: 40418580
Thanks for Quick response.

You said "it's only showing numbers" - what numbers was it showing?
1,2,3,4,5,6,7,8,9,10,11,
I need to show Jan,Feb,March,April...etc

I would take off (at least temporarily) the MMM custom format, because that is making what it is reporting.

I alreday removed , but still no different
0
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
LVL 24

Expert Comment

by:Phillip Burton
ID: 40418975
Without knowing the results of the underlying query, it is hard to advise.

Try changing Horizontal Axis Options - Axis Options - Axis Type from Scalar to Category, and see what happens.
0
 
LVL 10

Author Comment

by:ukerandi
ID: 40448428
ok i will try and let you know.thx
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 40584981
I've requested that this question be deleted for the following reason:

Not enough information to confirm an answer.
0
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 500 total points
ID: 40583853
I think my answer was right.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
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…

809 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