Reports with Viewers

Lori Leighton
Lori Leighton ✭✭
edited 12/09/19 in Smartsheet Basics

I would like to know if there is a way that viewers of the main sheet are able to work with the Reports.   I know I can share the report but it seems they are not able to change the "What" choices.

If this is not an option, would it work if I lock the columns and share the worksheet?  Then would a collaborator be able to run different options of the report?