How to repeat a textbox(Header) on each page when a row is growing ? - Tablix inside Tablix

Question

I have one tablix with two rows. One row is containing one tablix and the other one is having another tablix(Tablix inside tablix). Grouped the two rows with one column(Column Name is R_Id).

I done it using this link. It was really helpful for the beginners like me.

Here the issue is, I have one textbox with one expression in page header, the value of this expression is retrieving from the second tablix (i.e.second row from the main tablix). So, when first tablix is displaying(i.e. first row from the main tablix), I'm getting #error on that textbox in output screen.

Consider, I have 50 rows in first tablix, and 20 rows in second tablix. After execution, I got 3 pages. In first page, that textbox in header is showing as #error. The same when it comes to third page(here the place, second tablix is starting), I'm able to see the result.

I can guess that the value is not there in first tablix(first row of main tablix), So error occurred. How to give a relation to first row from second row?. Whether I need to add the respective column in first tablix also ?. Or Is any property from tablix/group will make trick? How can I achieve this?

Answer 1

If you wrap the rectangle inside a table yes.

So you can start with a table with a single row and column. Replace the textbox in that only cell with a rectangle. And define a row group for this outer table.

Then place your two tables inside the rectangle as you want it to look. You can even place textboxes above, below or between the tables.

For each group this will generate the two tables and repeat anything inside the rectangle.