InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 17:57:47 GMT20http://www.sqlservercentral.com/Forums/Topic1365953-150-1.aspxGoogle it, I am unsure if it can be done.Tue, 02 Oct 2012 01:46:35 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1365953-150-1.aspxThis not working for some reason.Instead, do you know a way to link different datasets from 2 different datasources in a tablix cell expression?Dataset1 from Datasource1Dataset2 from Datasource2ThanksRegardsMon, 01 Oct 2012 09:56:40 GMTdavdam8http://www.sqlservercentral.com/Forums/Topic1365953-150-1.aspxSomething like the below[code="sql"]SELECTDB1.ProjectName,DB2.ProjectStageFROMDatabase1.dbo.Table1 DB1INNER JOINDatabase2.dbo.Table2 DB2ONDB1.ProjectStageID = DB2.ProjectStageID[/code]Without knowing your data schemas it is hard to say.Mon, 01 Oct 2012 08:09:49 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1365953-150-1.aspxOK! In the mean time how do I create a Stored Procedure where I want data from 2 Databases.I want ProjectName from DB1 & ProjectStage from DB2.ThanksBest RegardsMon, 01 Oct 2012 08:07:43 GMTdavdam8http://www.sqlservercentral.com/Forums/Topic1365953-150-1.aspxagain unsure, never had to do it, would be worth a google and if it is possible let us know how.Mon, 01 Oct 2012 07:56:27 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1365953-150-1.aspxOK thanks anyway!What about linkin 2 tablix? Possible? Crazy stuff right?Regards.Mon, 01 Oct 2012 03:49:44 GMTdavdam8http://www.sqlservercentral.com/Forums/Topic1365953-150-1.aspxNot sure on that, you will need to build some sort of linking in 1 of the servers.Something like using linked servers, or building a merged database of both DB's using SSIS or something along them lines.Mon, 01 Oct 2012 03:37:14 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1365953-150-1.aspxOK. Thanks!It is possible to relate 2 tables from different datasources?For example: I have Dataset1 from Datasource1 and Dataset2 from Datasource2.I want from Dataset1 : ProjectName;and from Dataset2 : ProjectStage. Which is in another DB.How do I do this and add these fields into the same tablix?Sorry if it sounds stupid, but I'm learning, this is all new for me.Thanks in advance.RegardsMon, 01 Oct 2012 03:34:37 GMTdavdam8http://www.sqlservercentral.com/Forums/Topic1365953-150-1.aspxWhat it looks like you need is a UNION clause, either in a stored proc on direct in the data set.SELECT1,2,3FROMDB1.dbo.Table2UNION / UNION ALLSELECT1,2,3FROMDB2.dbo.Table1Mon, 01 Oct 2012 01:59:01 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1365953-150-1.aspxHi geniuses!I need to merge 2 databases to colect information for my reports. Have really no clue about how to set things up.The query must be written into the query 'box' of the Dataset Properties, RIGHT?Thanks in advance.Regards!Fri, 28 Sep 2012 09:20:09 GMTdavdam8