Friday, February 17, 2012

Custom Assembly

When I execute my report on my web server, I can see the data that requires a
query to the custom assembly. I have got "#Error".
When I execute my report in the Preview window my date is present.
My Assembly is reference to the C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\ReportServer\MyAssembly.dll is defined on My
Reports
I put my custom Assembly in the forlder C:\Program Files\Microsoft SQL
Server\80\Tools\Report Designer and in C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\ReportServer.
I added the <CodeGroup> to C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\ReportServer\rssrvpolicy.config :
<CodeGroup
class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust">
<IMembershipCondition
class="UrlMembershipCondition"
version="1"
Url="C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\bin\MyAssembly.dll"
/>
</CodeGroup>
Can you help me ?You should throw your assembly into C:\Program Files\Microsoft
SQL\Server\MSSQL\Reporting Services\ReportServer\bin as well. Try that.
Also, are you referencing shared or nonshared methods on the assembly?
Carolyn|||My assembly is allready into
C:\Program Files\Microsoft SQL\Server\MSSQL\Reporting
Services\ReportServer\bin
and into C:\Program Files\Microsoft SQL Server\80\Tools\Report Designer\bin
The method on the assembly is shared.
When I execute my report on the preview window, all is good.
When I execute my report on my web site, I have got "#Error"
"Carolyn Vo" wrote:
> You should throw your assembly into C:\Program Files\Microsoft
> SQL\Server\MSSQL\Reporting Services\ReportServer\bin as well. Try that.
> Also, are you referencing shared or nonshared methods on the assembly?
> Carolyn|||http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_rdl_8mue.asp
"Karine" <Karine@.discussions.microsoft.com> wrote in message
news:FFBDC97F-523F-42E7-BA80-C777457F8980@.microsoft.com...
> My assembly is allready into
> C:\Program Files\Microsoft SQL\Server\MSSQL\Reporting
> Services\ReportServer\bin
> and into C:\Program Files\Microsoft SQL Server\80\Tools\Report
> Designer\bin
> The method on the assembly is shared.
> When I execute my report on the preview window, all is good.
> When I execute my report on my web site, I have got "#Error"
>
> "Carolyn Vo" wrote:
>> You should throw your assembly into C:\Program Files\Microsoft
>> SQL\Server\MSSQL\Reporting Services\ReportServer\bin as well. Try that.
>> Also, are you referencing shared or nonshared methods on the assembly?
>> Carolyn|||I read this doc and I try to do what is writen on it ... but i only have
#error.
I hope that i do something bad but i don't know what.
- My assembly is define on y report.
- I copy my dll on my WebServer : C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\ReportServer\bin
- I try to modify my modify the file : rssrvpolicy.config : I add :
<CodeGroup
class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Name="MyCustomAssemblyCodeGroup"
Description="A special code group for my custom assembly.">
<IMembershipCondition
class="UrlMembershipCondition"
version="1"
Url="C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\bin\MyAssembly.dll"
/>
</CodeGroup>
I don't know if i put this code on the right place.
Can you help me more ?
"Yoshi" wrote:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_rdl_8mue.asp
>
>
> "Karine" <Karine@.discussions.microsoft.com> wrote in message
> news:FFBDC97F-523F-42E7-BA80-C777457F8980@.microsoft.com...
> > My assembly is allready into
> > C:\Program Files\Microsoft SQL\Server\MSSQL\Reporting
> > Services\ReportServer\bin
> > and into C:\Program Files\Microsoft SQL Server\80\Tools\Report
> > Designer\bin
> >
> > The method on the assembly is shared.
> > When I execute my report on the preview window, all is good.
> > When I execute my report on my web site, I have got "#Error"
> >
> >
> > "Carolyn Vo" wrote:
> >
> >> You should throw your assembly into C:\Program Files\Microsoft
> >> SQL\Server\MSSQL\Reporting Services\ReportServer\bin as well. Try that.
> >> Also, are you referencing shared or nonshared methods on the assembly?
> >>
> >> Carolyn
>
>

No comments:

Post a Comment