Where am I supposed to put
that .dll? Wait - don't answer that...
While finishing up a neat little blog on c# assemblies for reporting
services. I discovered that, for my local workstation, the default folder for
placing my .dll is:
C:\Program Files\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies
Why I have no idea. I had read that there were two places to store them -
one for the server and one while working locally as follows:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\bin.
C:\Program Files\Microsoft SQL Server\80\Tools\Report Designer.
Apparently this is not the case. I'll have to do some digging on this one,
but for now try the above folder. (I don't even have the latter, anyway).
Update: After hours and hours of intensive and
exhaustive investigation, right there in BOL it states:
To deploy a custom assembly in Reporting Services
-
Copy your custom assembly from your build location to the report server bin
folder or the Report Designer folder. The default location of the bin folder for
the report server is C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportServer\bin. The default location of the Report Designer is
C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies.
If you need to grant your custom assembly code permissions beyond the default
execute permissions:
-
Open the appropriate configuration file. The default location of
rssrvpolicy.config is C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer. The default location of rspreviewpolicy.config is
C:\Program Files\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies.
-
Add a code group for your custom assembly. For more information, see Understanding Code
Access Security in Reporting Services.
It looks like they have changed the location - maybe that was SQL 2000.
Another quick gotcha - I tried pointing to the assembly in my project (either
bin folder), but the IDE still insisted on choosing the one out of this folder.
Anyway, locally it goes in the private assembly folder; on the server in the
ReportServer\bin folder or, optionally, in the GAC.
---------------------------
Wonder if it will work this time?
f012a807-3d81-435e-bf73-e1f37f3b53d5|0|.0