question

Virayanna29 avatar image
0 Votes"
Virayanna29 asked Joyzhao-MSFT commented

SSRS dataset many to many relationship

I have a report that pulls data from two different datasets. These cannot be combined a query as they are coming from different data sources.
it is a many to many relationship table/recordsets. Since you can have one detail in a tablix, how do you display the other details?
I would like to display the first dataset records then the related records from the other dataset. These two datasets are realated using one key id field.
Suggestions? Any alternative to subreports?

sql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered Joyzhao-MSFT commented

Hi @Virayanna29 ,
You could display data from multiple data sources in a single report, merge datasets from different sources, and use Lookup Function/LookupSet Function to obtain matching values of different datasets.
Or you could consider combining data from different data sources into one dataset in the SSRS report. For more information, please refer to:
SSRS: Join data from different SSRS data sources into dataset.
SSRS: Merge data from different datasources into one dataset inside SSRS report.
Hope this helps.
Best Regards,
Joy


If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread


· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

The problem with the documentation you shared is it doesnt work or have i seen any example using it. i would like to see a tutorial explaining in details the steps taken how to merge from different data sources into one dataset. All i see is using a lookup which is not what i am not looking for. if it was as simple as accessing the external data in SQL server we could easily do a union.

0 Votes 0 ·

SSRS: Merge data from different datasources into one dataset inside SSRS report.
Does the solution described in this link not apply to you?

0 Votes 0 ·