Repeat footer field on new page

Question

The question is simple, I couldn't find any solution though.

If it is possible, how do I repeat a field that's in the Footer on a new page if it doesn't fit the container?

For example: I have a column that can store up to 5000 characters, and I must display it in the Footer. So if it reachs a certain number of characters, I'd like it to be repeated on a new page, even if it's the only field repeated.

Could someone point me to the right direction? Or just tell me if it's not possible?

Oh and it may be put in the Body instead of being in the Footer, if that makes it easier or if it solves the problem.

Thanks in advance.

Answer 1

Since you are unable to display columns in the Page Footer, what I do is create A @MyParam and set it as Internal. Under Default Values Select "From Query" then select the dataset and set the Value Field to the column one you want to display.

Drag out a TextBox and place it in the page footer, edit the Expression for the TextBox and have it display the @MyParam rather than the column.

This will repeat the entire column, not the "overflow" from the original column.