I am trying to access HttpContext.Current in my report code section (report properties) since I have to look at a cookie. However, HttpContext.Current is always null. Has anyone managed to access HttpContex.Current from a report?
Thanks in advance.
Ok, it was security permission problem with the code section. After deploying the report I got the #Error when trying to access HttpContext.Current. I modified the rssrvpolicy.config (location c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\) to FullTrust for the Code section and then it started working.
<CodeGroup class="UnionCodeGroup" version="1" PermissionSetName="FullTrust"
Name="Report_Expressions_Default_Permissions" Description="This code group grants default permissions for code in report
expressions and Code element. ">
instead of
<CodeGroup class="UnionCodeGroup" version="1" PermissionSetName="Execution"
Name="Report_Expressions_Default_Permissions" Description="This code group grants default permissions for code in report
expressions and Code element. ">
Probably not recommended but for now I am just testing. Will move the code to an assembly later and give that assembly FullTrust instead.
No comments:
Post a Comment