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
449 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

770 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