Hi @Anonymous ,
Yes, you are on the right track - the best option for providing a "printable" report is to make it paginated. That is actually the main purpose of a paginated report. They are design specifically to be printed or shared.
Any other way is going to be hit and miss and up to the user to manipulate the result set in such a way as to make it printable.
Did I answer your question? Mark my post as a solution!
Proud to be a Datanaut!
Private message me for consulting or training needs.