sql server reporting services: It has been mentioned that a custom assembly dll can be deployed under
either /Report Designer folder, or under /ReportServer/bin folder. I am
wondering if the first location is simply for preview to work.

Also, if the custom assembly needs to access some configuration data, what
config file shoudl those data be contanined?

Thanks.

Place the Assembly in the application folders of the Report Designer and
Report Server
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\bin
C:\Program Files\Microsoft SQL Server\80\Tools\Report Designer

Edit the configuration file rssvpolicy.config for the report server
Edit the configuration file rspreviewpolicy.config for the Report Designer
preview window
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer
C:\Program Files\Microsoft SQL Server\80\Tools\Report Designer
By Default custom assemblies are granted Execution permission in Reporting
Services
You DO NOT have to worry about Code Access Security when developing on your
local box when using the preview window it is set to FULLTRUST by default.
Note that the debug pop-up preview simulates the report server and DOES
require code access security to be in place.



The reportser

[quoted text, click to view]