StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>I had a lot of pain with this so I hope this helps someone. You can get it from the MSDN article but there are a few points below that I think can help speed someone through this a little faster.</p> <p>Don't forget to add this to your rssrvpolicy.config file:</p> <pre><code><CodeGroup class="UnionCodeGroup" version="1" PermissionSetName="FullTrust" Name="MyCodeGroup" Description="Code group for my data processing extension"> <IMembershipCondition class="UrlMembershipCondition" version="1" Url="C:\pathtocustomassembly\customassembly.dll" /> </CodeGroup> </code></pre> <p>I forgot to do this and I was hating it for awhile. </p> <p>Plus don't forget to hit both of the following folders for 2005 with your new dll: </p> <pre><code>Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin </code></pre> <p>Plus don't use log4net with your assembly. I couldn't make it work. Maybe someone can but not me.</p> <p>Plus if you mess up like I did you won't be able to delete the files until you close Visual Studio.</p> <p>Plus make your methods shared or static. It's easier.</p> <p>Create a deployment batch file. Something like:</p> <pre><code>@ECHO OFF REM Name: SRSDeploy_Local.bat REM REM This batch files copies my custom assembly to my Reporting Services folders. REM REM This is the SQL Server 2005 version: copy "C:\Projects\Common\lib\SCI.Common.SSRSUtils.dll" "C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies" copy "C:\Projects\Common\lib\SCI.Common.SSRSUtils.dll" "C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\bin" </code></pre> <p>Finally, build your report before previewing. </p> <p>If it builds you're likely on your way. </p> <p>Except...</p> <p>You can't deploy it to your production report server because you'll always get the following error:</p> <p>Error while loading code module</p> <p>Which is what I'm working on right now.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload