Solved

Can you create a stacked chart with two data values in same field e.g. Feild1 =5,6

Posted on 2013-01-29
2
453 Views
Last Modified: 2013-01-30
Can you create a stacked chart with two data values in same field e.g. Feild1 =5,6
So I want to create a stacked chart with each field as the catagory name and the two stacked values being e.g. 5 and 6?
Can it be done?
0
Comment
Question by:bruskhickory
2 Comments
 
LVL 22

Expert Comment

by:Nico Bontenbal
ID: 38834102
I think the answer liija gives you to this question is the best option to solve your problem:
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_28013323.html
0
 
LVL 6

Accepted Solution

by:
liija earned 500 total points
ID: 38834207
In your case, if you have fixed two digits in your column, a simple query might be enough:

SELECT
SUBSTRING(Field1, 1,CHARINDEX(',', Field1)-1) AS Decimal1,
SUBSTRING(Field1, CHARINDEX(',', Field1)+1, LEN(Field1)) AS  Decimal2
FROM YourTable

If you have more complexity, like varying quantity of digits in your column, you'll need some more logic.
0

Featured Post

MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MS Reporting Services Date Issue 2 47
SSRS Status field from text to number 2 37
How can I setup ssrs report  as UTF-8 . 7 27
sql 2012 cluster  SSRS cluster aware 2 29
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

808 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