Osama Assaf

Adding a .NET library reference to SQL 200X Reports

To reference a .NET library from an SQL report, the library need to be copied to the right location.

Different locations are used for Developer tools and Production servers

SQL 2005 Reporting

Deveoper Machine: C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies

Production Machine: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\bin

SQL 2000 Reporting

Deveoper Machine: C:\Program Files\Microsoft SQL Server\80\Tools\Report Designer

Production Machine: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\bin

Maximum Request Length Exceeded – SQL Reporting Service

When using CreateResource( ) method or directly try to upload a file into the Reporting Server if the file size is greater than 4MB, an exception will be raised: “Maximum Request Length Exceeded”

To fix the problem, the “maxRequestLength” in the web.config should be added and given the desired max file

<httpRuntime

executionTimeout = “9000“

maxRequestLength=“10000“/>