how to include 2 tables in 1 page and page break down by 1 column for both the tables in ssrs report

Question

I have 2 tablix pointing 2 different dataset in a report. Each tablix pointing to different dataset.

Monthly Sales

CountrySalesAmountUS100UK200YTD Sales

CountrySalesAmountUS150UK250When applied page break on Country column in both tablixes, it should display data as per below.

Page 1

Monthly Sales

CountrySalesAmountUS100YTD Sales

CountrySalesAmountUS150Page 2

Monthly Sales

CountrySalesAmountUK200YTD Sales

CountrySalesAmountUK250Any suggestions how to implement this?

Answer 1

Hi @Mysari Gnaneshwar,

Please try with below steps.

Add a Parent Group in each Tablix based on Country:

Right-click on the row in the Tablix → Add Group → Parent Group.

Select Country as the grouping field.

Right click on Country Group-Group properties→ Choose the Page break between each instance of a group option.

Apply sorting on Country in the two Tablix to ensure alignment.

A sample for your check below.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

Thanks @Zoe for the response

It's showing for me when 2 tablix are placed side by side. When 2 tablix are placed one below the other, it's not showing 2 tables in 1 page.

Answer 3

Hi @Mysari Gnaneshwar,

What about using List and lookup function?

See the workaround mentioned here.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.