Ihave a chart built in SSRS 2008.
it is a bar chart. the data set used in this chart is dataset1.
now i need to add one more data field to this chart. but this data will come from a different data set.
so, my chart should have data comming from two data sets... is this achiveable??
these two data sets are from two different data sources... Please help as this is urgent for us.
|azharullah m Wednesday, June 24, 2009 12:57 PM|
Not possible. Chart can only bind to single dataset. My advice to use Linked Server to combine data from two servers into single dataset.
|qxg Wednesday, June 24, 2009 1:03 PM|
thanks for reponding...
can you please explain how to use linked server?
|azharullah m Wednesday, June 24, 2009 1:14 PM|
Is it possible to combine the two data sources? If the data is going to be on the same set of axises (SP?), you should be able to somehow combine the data sources. It is possible that you do not have access to the data sources, and this will not be an option. Just trying to throw some ideas out there.
You will get the following error though if you try to add data from a different Data Set:
Microsoft Report Designer
Cannot add a field from the dataset [DATASET] to a dataregion which uses the dataset [DATASET].
|Cardi DeMonaco Jr Wednesday, June 24, 2009 1:30 PM|
You can refer http://msdn.microsoft.com/en-us/library/ms188279.aspx
for linked server.
For example, you need to retrieve data from Server1 and Server2. You canadd Server2 aslinked serveron Server1. Then create a stored procedure on Server1 which retrieve data from Server2 and Server1. In your report, this stored procedure can return data from two servers in single dataset. Linked Server is not easy to config. You might encounter double-hop issue. Don't be afraid of that. I use linked server a lot in my project.
|qxg Wednesday, June 24, 2009 1:35 PM|
thanks for responding...
let me expalain you my scenario...
Ineed to built a chart.I need to add two data fields to this chart...these two data fields are from two data sets
these two data sets are from two different data sources... one is SQL DB which is on mymachine and another one isOLAP source which is on other machine...
|azharullah m Wednesday, June 24, 2009 2:30 PM|
Yes, this makes things more complicated. Not sure if linked server can connect to AS server. Maybe you have to display two charts side by side.
|qxg Wednesday, June 24, 2009 2:35 PM|
any work around?
|azharullah m Wednesday, June 24, 2009 2:41 PM|
as per my requirement mentioned above,i tried to create a linked server so that i can connect to olap source from my sqldb..
Ihave added a newlinked server from my sqldb.. in the provider drop down i selected "Microsoft OLEDB Provider for alalysis services 10.0"
for product name it asked me the oledb data source to add as a linked server and i gave my olap data base name. then in the data source i gave my olap data source name... now what should i provide in 'provider string', 'catalog' and location dropdown???
|azharullah m Thursday, June 25, 2009 10:18 AM|
I am not good at Linked Server. Another option, unsupported integration service data provider might help you. Integration services data provider is disabled by default. Modify config file to enable it.
In integration services, definitely you could fetch data from two servers and join them into table.
|qxg Friday, June 26, 2009 8:50 AM|
i have linked the other server with my server..
so now, other server ie;OLAP DB is linked with my SQL DB..
ie., under linked server's, this OLAP is existing...but what should i do next?? can you tell me how should i query my data(sorry but i am not so good at query's)...
Iam suppose to have three values from this OLAP and one value from from my SQLDB as data fields in my chart..
|azharullah m Friday, June 26, 2009 12:21 PM|
|azharullah m Monday, June 29, 2009 5:07 AM|