Report Builder Paginated report w/ 2 datasets sharing common Parameters issue

Hi Karolina411 ,

To display the results of two datasets in a paged report, you can use this function lookup to retrieve values from the second dataset based on matching key columns in the first dataset. This is a common method when you need to merge data from two separate datasets that cannot be directly joined in SQL.

Regarding Excel formulas, the CUBEMEMBER and CUBEVALUE functions are specific to Excel and are used to retrieve data from OLAP multidimensional datasets. In the Report Builder, it is common to use the function Lookup (as described above) or a DAX expression (if working in a table model). Getting the DAX equivalent for the current month is similar to TODAY(), but you need to format it to match the format in the dataset.

Below is the link will help you:

ssrs 2008 - Joining two datasets to create a single tablix in report builder 3 - Stack Overflow

sql server - SSRS two datasets in one report - Stack Overflow

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.