Hi – we have datasets from two different servers in our report and in the design, we have table and would like to add another matrix inside the table. Since the main table is using a Dataset A, it’s not allowing me to add the columns that are available in Dataset B which has different data source than Dataset A.
After done some reading on Blogs, it can be achieved using Linked Servers but in our case – due to some access issues, couldn’t go with Linked servers.
Can you please suggest some other best way to achieve the same?