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

Suggested Solutions

Title # Comments Views Activity
DTC in SQL Cluster 5 39
SQL Upgrade 3 52
SSRS Highlight Specific Column 3 55
Chrome SSRS print Functionality 1 20
Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
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…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

920 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now