Combining Two charts in reporting services

Question

0.00/5 (No votes)

See more:

HI i have two diffrent column charts in a page with two diffrent datasets, i have to join those two charts or have to show the data from two datasets in the same chart area.

One dataset brings :Country as USA,Price as $100,Fees as $10
second dataset brings :Country as UK,Price as $50,Fees as $10

i have to plot this data like country's as X-Axis and Price and Fess as Series i mean as bars

My data has no way to use a join for both datasets ,so is there any way i can join tow chart areas to one chart area or any function to get two dataset value in to one single chart seperatly

Posted 23-Mar-11 10:46am

makwith9789

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

luisnike19 · Accepted Answer · 2011-03-23T11:03:00

Solution 1

I think you should find the way to merge both DataSets before send it to the report, and then just with one Chart display it. There's always a way, maybe you don't want to do it.

Posted 23-Mar-11 11:03am

luisnike19

Comments

makwith9789 23-Mar-11 17:14pm

can you help me out with merging two dataset's the source for two datasets are stored proc's do i need to do the merging at sql server or can i do it in the report designer side can u give me some reference so i can figure out thanks for the fast reply

luisnike19 23-Mar-11 22:40pm

You need to merge the dataSet in another class, then just pass the DataSet to the Report
http://msdn.microsoft.com/es-es/library/system.data.dataset.merge(v=VS.100).aspx
http://forums.asp.net/t/1537081.aspx/1

makwith9789 24-Mar-11 9:49am

Thanks for giuding me in right direction i did a union and my result is ok now thx fro the help