Warning	2	[rsRuntimeErrorInExpression] The Value expression for the textrun ‘Textbox4.Paragraphs[0].TextRuns[0]’ contains an error: Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.	C:\Documents and Settings\...	0	0	

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Collections;

namespace RSStyleLibrary
{
    public class RSStyleSheet
    {
        public static string ReportStyleGet(string StyleType, string StyleFamily, string StyleCategory)
        {
            //StyleType = "Color";
            //StyleFamily = "Accounting";
            //StyleCategory = "Header";
            string RetVal;

            SqlConnection conn = new
            SqlConnection("server;database;User ID;Password);

            SqlCommand USP_ReportStyleGet = new SqlCommand("USP_ReportStyleGet", conn);
            USP_ReportStyleGet.CommandType = CommandType.StoredProcedure;

            USP_ReportStyleGet.Parameters.AddWithValue("@StyleType", StyleType);
            USP_ReportStyleGet.Parameters.AddWithValue("@StyleFamily", StyleFamily);
            USP_ReportStyleGet.Parameters.AddWithValue("@StyleCategory", StyleCategory);

            conn.Open();
            RetVal = USP_ReportStyleGet.ExecuteScalar().ToString();
            conn.Close();

            return (string)RetVal;

        }

    }
}

Imports System.Security.Permissions

Public Class DataDrivenStyleLibrary
    Public Shared Function dbStyle(ByVal inputStyle As String, ByVal InputStyleType As String) As String
        Dim permission As SqlClientPermission = New SqlClientPermission(PermissionState.Unrestricted)
        permission.Assert()
        sStyle = ""

<CodeGroup class="UnionCodeGroup"
	   version="1"
	   PermissionSetName="FullTrust"
	   Name="DynamicStyleLibrary"
	   Description="Dynamic Reports">
		<IMembershipCondition
		class="UrlMembershipCondition"
		version="1"
		Url="C:\Program Files\Microsoft SQL Server\MSSQL.X\Reporting Services\ReportServer\bin\DynamicStyleLibrary.dll"/>
</CodeGroup>