Sql – Reporting Services Problem Rendering RTF

Couple of options:

1) Modify SessionTimeout and SessionAccessTimeout system properties.

Here is a sample script for rs.exe which will set these values for you:

Public Sub Main()
    Dim props() as [Property]
    props = new [Property] () { new [Property](), new [Property]() }

    props(0).Name = "SessionTimeout"
    props(0).Value = timeout

    props(1).Name = "SessionAccessTimeout"
    props(1).Value = timeout

    rs.SetSystemProperties(props)
End Sub 

You can run this script with the following command:

rs -i sessionTimeout.rss -s http://localhost/reportserver -v timeout="6000"The timeout is expressed in seconds, so this example sets the SessionTimeout and SessionAccessTimeouts to about an hour and a half.

(via http://blogs.msdn.com/b/jgalla/archive/2006/10/11/session-timeout-during-execution.aspx)

2) Change Report Execution Timeout via Report Manager Open Report Manager At the top of the page, click Site Settings. This opens the General Properties page of the site.

Report Execution Timeout Specify whether report processing times out after a certain number of seconds. (via http://msdn.microsoft.com/en-us/library/ms181194.aspx)

3) Set the HttpRuntime ExecutionTimeout

a. Open the ReportServer’s Web.config file by going to Start -> Administrative Tools -> Internet Information Services.

b. From there, expand Web Sites -> Default Web Site, and click on ReportServer. On the right-hand pane, right-click ‘Web.Config’ and select ‘Open’.

c. Locate the HttpRuntime parameter. If it doesn’t exist, you will have to create it within the section.

d. Set the executionTimeout value to ‘10800’ (3 hours) as shown below:

<system.web>
<httpRuntime executionTimeout = "10800" />
</system.web>

4) Increase the script timeout on the report server

1. Go onto your Reporting Server and open up Internet Information Services; right-click on the ReportServer and select Properties.
2. Go to the Options tab, and set the ASP Script timeout to 300 seconds (this didn't really work for me).

5) Set the report to never time out on the server

1. Open your web browser on the server and go to http://localhost/Reports
2. Navigate to the Report location and click on the problem report(s).
3. On the left-hand pane, click on Properties.
4. In the ‘Report Execution Timeout’ click the ‘Do not timeout report execution’. (via http://geekswithblogs.net/ssrs/archive/2009/10/30/steps-to-resolve-ssrs-timeout-issues.aspx)

I've found the answer. Problem were permissions for viewing report in Visual Studio Preview mode.

First of all, I was putting dll (with localization class) into next location:

C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies.

After that, I needed to change RSPreviewPolicy.config file, that exists in same folder location, to apply some security permissions.

In question, I mentioned that I've added one PermisionSet, but now I am sure there is no need for that.

I've just changed two CodeGroup section, which have Execution permission level, to have FullTrust permission level, like this:

<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. ">
    .
    .
    .
</CodeGroup>
<CodeGroup
    class="FirstMatchCodeGroup"
    version="1"
    PermissionSetName="FullTrust"
    Description="This code group grants MyComputer code Execution permission. ">
    .
    .
    .          
</CodeGroup>

Regarding your version of Visual Studio, you must choose appropriate folder path:

• for VS 2015 --- C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\PrivateAssemblies
• for VS 2013 --- C:\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\IDE\PrivateAssemblies
• for VS 2010 --- C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies