Is it possible to hyperlink one field in a SQL report (e.g. UserID) which when clicked calls another report using the hyperlinked value as a parameter (or "filter" in RP terminology)?
Yes, this is possible using HTML injection method. In the view mode, right click on a SQL report with filters and select “Hyperlink”. This will give you something like this: