Hi @Anna ,
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.
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