How to Preview SSRS Reports on Local PC

 How to solve error during preview of  SSRS reports on local PC

 Scenario

you have an SSRS report that raises a security error when you try to preview.

 Error Message:

Cause

when your PC acts as host for the report, the security configuration does not allow you to use the referred library.

 

Solution:

Change the policy configuration on your machine, to elevate your privileges;  e.g.  to Full Trust.

 

The policy is in the file
[ C:\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\IDE\PrivateAssemblies\RSPreviewPolicy.config ]

 

Edit and find the XML node:
Configuration > mscorlib > security > policy > PolicyLevel  > CodeGroup.
(in my case, line# 55), which looks like this (before):

Consider keeping a backup of this file before modifying,  just in case.

 

Replace the “Nothing” by “FullTrust”  (case sensitive). 

Like this (after):
Save the file.
The change takes effects immediately.
Hit [Preview] and the above error should have disappeared.

 

 

 

 

Further Reading

 Partial Trust

·         How to grant permissions to a custom assembly that is referenced in a report in Reporting Services
https://support.microsoft.com/en-us/help/842419/how-to-grant-permissions-to-a-custom-assembly-that-is-referenced-in-a

·         Reporting Services Configuration Files
https://docs.microsoft.com/en-us/sql/reporting-services/report-server/reporting-services-configuration-files?view=sql-server-2017

·          Setting Security Policy for Custom Assembly in SSRS 2014 SharePoint Integrated Mode
https://joyfulcraftsmen.wordpress.com/2015/04/27/setting-security-policy-for-custom-assembly-in-ssrs-2014-sharepoint-integrated-mode/