Linking Seperate Datasets

I am wondering if it is possible to have 2 datasets in the rdl report that
are linked together by some key.
Or do I just have to combine the information in the two datasets using a
query into one dataset. If at all possible i would like to use two datasets
that are linked.You can have as many datasets as you like in one rdl report. However,
generally you can only use one dataset in a given table, matrix, list, etc.
If you require to present things in different ways you may be best to use
one dataset with different sorting, filtering and grouping.
HTH,
--
Magendo_man
Freelance SQL Reporting Services developer
Stirling, Scotland
"Arlyn" wrote:
> I am wondering if it is possible to have 2 datasets in the rdl report that
> are linked together by some key.
> Or do I just have to combine the information in the two datasets using a
> query into one dataset. If at all possible i would like to use two datasets
> that are linked.
>
>

Linking reports

Does anyone know if it is possible to link two reports together?
For example, if you have a report showing customers with the number of
orders they have placed, can you then link to another report showing
details of the actual orders.
Hope this makes sense.
ChrisYes possible using drill through reports.
Amarnath
"chris.j.stubbs@.gmail.com" wrote:
> Does anyone know if it is possible to link two reports together?
> For example, if you have a report showing customers with the number of
> orders they have placed, can you then link to another report showing
> details of the actual orders.
> Hope this makes sense.
> Chris
>

linking 2 or more cubes

hi,

im new in analysis services 2005. is it possible to link 2 or more cubes together?

thanks,

cherriesh

Are you trying to associate two or more fact tables? If so, you handle that inside a single cube using multiple measure groups.

B.

|||It is also possible to link in measure groups and dimensions from other cubes using the Linked Object wizard.

servers

Dear All,
I am trying to link 2 servers together and get the following message:
Server: Msg 18452, Level 14, State 1, Line 1
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
If I query MyServer and OtherServer independantly I can see the expected
results but when I run the following query I get:
select
Ref
from
MyServer.MyDB.dbo.MyTable inner join
OtherServer.OtherDB.dbo.OtherTable T on T.Ref = Ref
I have tried sp_addlinkedserver 'OtherServer'. This generated no error. Can
someone suggest what I am doing incorrectly.
Thanks again...
Alastair MacFarlaneAlastair MacFarlane,
You will have to elaborate a little bit more about your configuration.
- OS version in each server?
- SQL Server version in each server?
- What kind of authentication is being used in each sql server?
AMB
"Alastair MacFarlane" wrote:

> Dear All,
> I am trying to link 2 servers together and get the following message:
> Server: Msg 18452, Level 14, State 1, Line 1
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
> If I query MyServer and OtherServer independantly I can see the expected
> results but when I run the following query I get:
> select
> Ref
> from
> MyServer.MyDB.dbo.MyTable inner join
> OtherServer.OtherDB.dbo.OtherTable T on T.Ref = Ref
> I have tried sp_addlinkedserver 'OtherServer'. This generated no error. Ca
n
> someone suggest what I am doing incorrectly.
> Thanks again...
> Alastair MacFarlane