Paginated Reports

What you can do for that is to create 2 sheets, one being an interactive sheet where you define the parameters used for the filters you need. The user will need to go to this sheet to select the relevant parameters. Then go to the report page and hit generate PDF.

image

The PDF generated will include the data filtered based on the parameter selected in the interactive sheet.

Hope this works for you!