Does anybody know where the results of queries are stored in SSRS? I am referring to the actual data that is stored in a snapshot. Is it stored in some tables in the ReportServer or ReportServerTempDB database?
Origin of the question: The database we are reporting on contains PHI (Protected Health Information). I want to know if ReportServer or ReportServerTempDB can contain PHI. And if so what tables would they be in? I know that when you create a snapshot in SSRS the results of the query are saved so you do not need to run that long-running query again. But where exactly are the results of that query saved.