Sharing segments of a Form's responses

I am looking to share only select results of a Form using a Report, but, in order to do so, it appears that I would need to provide access to the initial Form results. Is there a way to avoid doing that so that the person cannot see all of the form's results (i.e. departments other than her own)? The Report doesn't populate for the person unless they have access to the parent Smartsheet. I tried the Automation settings from the main responses document, but this gets blocked because the user doesn't have view access to the main responses sheet.