Hi Igor,

From your description, you want to convert RTF to TXT in SQL Server Reporting Services.

In SQL Server Reporting Services, we can use the custom code function to convert the RTF to TXT. In the custom code function, use the window RichTextBox control to read the RTF, and then return the TXT.

Here are the detailed steps to convert RTF to TXT in SQL Server Reporting Services:

1. Use the following custom code in the Report. The custom code includes a function named ConvertRtfToText. This function require a parameter that is the RTF.

Public Shared Function ConvertRtfToText(ByVal input As String) As String
 
Dim returnValue As String = String.Empty
 
Using converter As New System.Windows.Forms.RichTextBox()
 
converter.Rtf = input.Trim
 
returnValue = converter.Text
 
End Using
 
Return returnValue
 
End Function

2. To use the above custom code function, we need to add a reference that refers to the instance System.Windows.Forms.

Please add the reference System.Windows.Forms in the Reference tab of Report properties dialog.

3. Setup a domain account for Execution Account using the Reporting Services Configuration Manager.

Executing the above custom code is an unattended report processing.

Unattended report processing refers to any report execution process that is triggered by an event (either a schedule-driven event or data refresh event) rather than a user request. The report server uses the unattended report processing account to log on to the computer that hosts the external data source. This account is necessary because the credentials of the Report Server service account are never used to connect to other computers.

Reporting Services provides a special account named Execution Account that is used for unattended report processing and for sending connection requests across the network. To solve the issue, you could setup a domain account for Execution Account.

4. For security reasons, the default permission of report expressions is Execution which is defined in the SQL Server Reporting Service CONFIG file rssrvpolicy.config. If we use a custom function in the expression, and the custom function uses code like this Using converter As New System.Windows.Forms.RichTextBox() , the expression will require more permissions in addition to Execution.

To provide proper execution permission, we can change the permission set of the following code groups to be FullTrust:

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

Jin,

Now this doesn't work on my desktop either.

I get #Error when I try to display this same report from VS.

What local settings could be causing this issue?

Am adding references correctly?

http://img.photobucket.com/albums/v296/igorblackbelt/SSRS-AddReferencetoClass.png

Hello,

I did all of the above coding and have this working with SSRS 2008, Win 2003 Server, and IIS 6.0. 

We've created a new server running SSRS 2008R2, Win 2008, and IIS 7.  It does not work on this new environment and I do not get any error, but instead the SSRS Service reboots itself.

Can you give me an idea of what I may need to do or test to get this working?  I've checked the log files and the Event Viewer, but not seeing any errors.  It does call my assembly and works if I just output some text to the report.  It fails when I try to reference System.Windows.Forms.RichTextBox.  I also installed to the GAC with no luck.

My code:

using System;
using System.Windows.Forms;
using System.Diagnostics;

namespace ConversionUtility
{
    public class ConversionUtility
    {
        [System.Security.Permissions.PermissionSet(System.Security.Permissions.SecurityAction.Assert, Unrestricted = true)]
        public static string ConvertRTFToText(string richText)
        {
            string sText = "";

            try
            {

                'if I comment out these lines, this will work
                RichTextBox richTextBox = new System.Windows.Forms.RichTextBox();
                richTextBox.Rtf = richText;
                sText = richTextBox.Text;
                //throw new Exception("Log this error");
            }
            catch (Exception e)
            {
                  sText = "Error Caught: " + e.Message;
            }
          
            return sText;
           
        }
    }
}

If I don't have these permissions, it will error.  I add the group and it works if I don't reference the RichTextBox.

<CodeGroup
	class="UnionCodeGroup"
	version="1"
	Name="SecurityExtensionCodeGroup"
	Description="Code group Conversion Utility"
	PermissionSetName="FullTrust">
	<IMembershipCondition
		class="UrlMembershipCondition"
		version="1"
		Url="C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\bin		\ConversionUtility.dll"
	/>
</CodeGroup>

I'm thinking it's having an issue with permissions to System.Windows.Forms, but haven't been able to figure out what I need to do.

Also, I do have the Execution Account Setup. 

Thanks,

Randy

I ended up contacting Microsoft because this should have worked. When I gave them a sample application in worked in their environment. It turned out that they had a hotfix installed for Reporting Services that I did not. After I installed the hotfix, everything worked.

build 10.50.1720 - applied CU2 for SSRS 2008 R2 RTM (http://support.microsoft.com/kb/2072493).

• Proposed as answer by Iceman_Bauer Tuesday, December 14, 2010 3:09 PM

I also cannot get this to work in Visual Studio. It throws the permission error. Do I need to change anything on my development machine to get this working in VS in debug mode?

Did you complete this step at the properties of your report?

2.       To use the above custom code function, we need to add a reference that refers to the instance “System.Windows.Forms”. 

Please add the reference “System.Windows.Forms” in the “Reference” tab of Report properties dialog.

Yes, I did, but it still does not work in VS.

Can I get more detailed info for step 2 please?

Using Report Builder 3.0, these options exist in the 'Referenes' tab:

* Add or remove assemblies:   dll name

* Add or remove classes:  Class Name    &    Instance Name

what exactly do I fill in for these 3 options p