sql server reporting services: 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


[quoted text, click to view]