custom dll

Hi
For SQL Reporting Services 2000 the custom dll could be deployed to c:/programfiles/MSSQLServer/80/tools/reportDesigner.
But now I am trying to achieve the same with 2005. Can some one let me know where I can deploy the custom dll for SSRS 2005 to use it with reports.
Thanks in advance.

When you deploy your custom dll in SSRS 2000 it must be copied to [MSSQLServerInstallDir]\MSSQL\Reporting Services\ReportServer\Bin folder.
The folder you mentioned is only for design-time support under VS.NET 2003 and not for deployment.

In SSRS 2005 your dll must be copied to [MSSQLServerInstallDir]\MSSQL.2\Reporting Services\ReportServer\Bin (Warning: the path may vary depending on you've installed the Report Server)
For SSRS 2005 design-time support the folder is located at [VS2005InstallDir]\Common7\IDE\PrivateAssemblies\

HTH

Gabriel Fogante
http://neodynamic.blogspot.com/

Custom configuration settings?

We are an ISV and our OLAP solution will be deployed to many customers. Needless to say, various values needs to be customized to meet the client needs, e.g. KPI goal values. What will the recommended way to implement custom configuration settings in the cube that are accessable to MDX calculations?An example would be helpful. I have vague understanding of what you are asking, perhaps more explanation will make it more clear.

Custom Code in Web Report Builder

Hi, I created and deployed a simple custom 'toy' method to test custom code in a Report Server implementation I'm doing. It works just fine in the VS.NET 2005 Report Designer, but it does not seem possible to call it from the Web Report Builder. This would make ad-hoc reporting so much easier in non-trivial cases for our users - is it possible to use custom code in the Web Report Builder? If so, what's the syntax? I tried MyNamespace.MyClass.MyStaticMethod(), which works in the VS.NET designer, but was rejected in the Report Builder. Thanks much, Richard

Right now it is not possible to call custom assemblies from reports built in Report Builder... unless you save report and then edit in in Report Designer.

Custom Assembly Problems: System.Drawing

Hi,
I built a Custom Assembly to allow me to use external image files in
my report. I deployed the DLL and configured the security policy
config files.
Everything worked great, i got the image coming through to my report
in both Designer Preview mode and when deployed.
I decided to extend the custom assembly to return the dimensions of
the image as well by adding some code that utilizes System.Drawing.DLL
//ok now, lets get the width and height
//FileIOPermission permission = new FileIOPermission
Image myImage = Image.FromFile(pPath);
g_lastHeight = myImage.Height;
g_lastWidth = myImage.Width;
myImage.Dispose();
myImage=null;
After rebuilding and deploying the DLL, my report no longer has any
images when deployed.
However, the images do show up in Designer preview mode, and the DLL
performs correctly returning the image dimensions upon request,
implying a security policy issue'
So my question is what security policy type things do i need to do in
order to utilize System.Drawing.dll in my DLL.
Any help would be greatly appreciated.
Thanks
DerekI believe the correct permission is UIPermission. Please see the following for why it only works in
preview and how to configure the server:
http://msdn.microsoft.com/library/?url=/library/en-us/dnsql2k/html/dngrfCodeAccessSecurityInSQLServer2000ReportingServices.asp?frame=true
Thanks.
Donovan R. Smith
Software Test Lead
This posting is provided "AS IS" with no warranties, and confers no rights.
"Derek W" <derek@.brokerbuilders.com> wrote in message
news:a5df538d.0408161409.6d219516@.posting.google.com...
> Hi,
> I built a Custom Assembly to allow me to use external image files in
> my report. I deployed the DLL and configured the security policy
> config files.
> Everything worked great, i got the image coming through to my report
> in both Designer Preview mode and when deployed.
> I decided to extend the custom assembly to return the dimensions of
> the image as well by adding some code that utilizes System.Drawing.DLL
> //ok now, lets get the width and height
> //FileIOPermission permission = new FileIOPermission
> Image myImage = Image.FromFile(pPath);
> g_lastHeight = myImage.Height;
> g_lastWidth = myImage.Width;
> myImage.Dispose();
> myImage=null;
> After rebuilding and deploying the DLL, my report no longer has any
> images when deployed.
> However, the images do show up in Designer preview mode, and the DLL
> performs correctly returning the image dimensions upon request,
> implying a security policy issue'
> So my question is what security policy type things do i need to do in
> order to utilize System.Drawing.dll in my DLL.
> Any help would be greatly appreciated.
> Thanks
> Derek