How to join two diffrent charts in SSRS
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
March 23rd, 2011 5:00pm

Hi Raju9789, Since there are two different datasets, I think you might not lay all these datafields into one data region control directly. However Reporting Services 2008 R2 has a lookup function to retrieve the value from the specified dataset for a name/value pair where there is a 1-to-1 relationship. For example, for an ID field in a table, you can use Lookup to retrieve the corresponding Name field from a dataset that is not bound to the data region. For more information, please see, Lookup Function (Report Builder 3.0 and SSRS): http://msdn.microsoft.com/en-us/library/ee210531.aspx If you have any question, please feel free to ask. Thanks, Challen Fu Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
March 23rd, 2011 10:23pm

Hi Raju9789, Since there are two different datasets, I think you might not lay all these datafields into one data region control directly. However Reporting Services 2008 R2 has a lookup function to retrieve the value from the specified dataset for a name/value pair where there is a 1-to-1 relationship. For example, for an ID field in a table, you can use Lookup to retrieve the corresponding Name field from a dataset that is not bound to the data region. For more information, please see, Lookup Function (Report Builder 3.0 and SSRS): http://msdn.microsoft.com/en-us/library/ee210531.aspx If you have any question, please feel free to ask. Thanks, Challen Fu Please remember to mark the replies as answers if they help and unmark them if they provide no can we do the merging in report level is it possible to do that or should i need to do it on server side
March 24th, 2011 9:35am

Hi Raju9789, Since there are two different datasets, I think you might not lay all these datafields into one data region control directly. However Reporting Services 2008 R2 has a lookup function to retrieve the value from the specified dataset for a name/value pair where there is a 1-to-1 relationship. For example, for an ID field in a table, you can use Lookup to retrieve the corresponding Name field from a dataset that is not bound to the data region. For more information, please see, Lookup Function (Report Builder 3.0 and SSRS): http://msdn.microsoft.com/en-us/library/ee210531.aspx If you have any question, please feel free to ask. Thanks, Challen Fu Please remember to mark the replies as answers if they help and unmark them if they provide no can we do the merging in report level is it possible to do that or should i need to do it on server side i did a union and now its fine
Free Windows Admin Tool Kit Click here and download it now
March 24th, 2011 10:21am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics