????? ??????? ????????? ????? ?? ????????? ???????? ??????? ?? "????? ????????"

?????? ????????? ?????? ?????????
???? ???????: 920769 - ??? ???????? ???? ????? ????? ??? ???????.
???? ????? ??? ???? SQL

????? ??????? ????????? ????? ?? ????????? ???????? ??????? ?? "????? ????????"

?????? ??? ?????? ??? ?????????? ??? ???? ???? ?????? ??????? ??? ???????? ???? ???? ? ??????? ???????? ???? ???? ???? ?????? ????? ??????? ?? ???????? ???????? ????? ?????. ????? ????? ???????? ????? Ask For It ??????? ??????????. ???? ????? ?????? ??? ??????? ?? ???? ??? ??????.
????? ???? | ?? ????

?? ??? ??????

?????? ?? ??? ????! ??? Sandy Yakob ?? ?????? Microsoft SQL Server ???????. ??? hostess ??????? ????? ??? ???? SQL. ?????? ????? ??? ??: ?? ?? Microsoft ??????? 14. ??????? ??????? ????? ???? ?? ?????? SQL Server ???????.

???? ??? ????? John Sirmon ????? ??????? ???????? ??????? ??????? ?? ????????? ???????? ??????? ?? ????? SQL Server 2000 ???????? ? SQL Server 2005 ??????? Services. ?? ????? ??? ?????? ????? "??????? ???????? ??????" ? "??????? ?? ????? ????? ??" ????? ???????? ". ???? ??????? ????? ????? ?? ?????? SQL ?????? ????? ?? Microsoft ???? ????? ?? Microsoft ??? ??? ????. ??? ????? ?? SQL Server ???? ?? 10 ????? ????? ????? ??????? ???? ??????? ?? Microsoft Visual Studio. ????? John ???? S. B. ?? ????? ??????? ?? Citadel. ????? ???? ????? ???? ?????? ????????? ?? Microsoft (MCSD) ? ???? ????? ?? ????? ?????? Microsoft (MCDBA). ???? ????????? ?????? ? ??? ?? ??????.

????? ????? ????

????? ????? ???? ? ???? ??????? ???????:
  1. ????? ????? ??? Visual Studio. ?? ??????? ???? ??? ??? ????? ???? ??? Project ?? ???? ??? ????? ??????.
  2. ??? ????? ?????. ??? ???? ??????? ??????? 2005\projects SimpleClassLibrary ? C:\Documents and Studio Documents\Visual Settings\user1\My.
  3. ??? ??? ??? (?? ?????? ?? ??????? Class1.vb) ?? ?? ?????? ??????? ???? ???? ????????? ?? "????? ????????". ?? ?????? ?????? ?? ??? ????? ???? ???????? ????? ?????.

    ?????? ??? ???? ????? (????? ?? C#) ?? ???? ????? ?????? ???? ???????? ???? ????. ?? ??? ?? ???????? ??? ??? ?? ????? ??? ??? ???? ???? ??????? ?????? ??? ?????? ?? ???????.
    Public Class Class1
    
        Public Shared Function DoSomething() As String
            Return "string data returned from custom assembly"
        End Function
    
    End Class
    
  4. ????? ???????? ?? ????? ???? ????????? ???????? ???? ??? ????? SimpleClassLibrary ??????? ????. ??? ?????? ?????? ??????? ?? .dll ???? ??? ??????? ?? ???? ??? ???????. ?? ?????? ????? ?? ??? ?????? ????? ??????? ?????? ?? SimpleClassLibrary.dll ?? ?????? SimpleClassLibrary\bin\Debug 2005\Projects\ Studio Documents\Visual ????.

??? ??????? ??????? ??? ???????? ????? ???????? SQL

????? ??????? ????? ?? ??? ???? ????? ?? ????? ???????? "?" ????? ?????. ?????? ????? ??? ??? .dll ????? ?? ??? ???? "???? ?????" ?? ??? ???? Server ?????.

?????? ?? ???? ?????? ?????? ??????? ????? ??? ??? ???? ???????.
  • ?????? ??? ????? 2005 ????? ???? .dll ?? ???????? ???????:
    • 8\Common7\IDE\PrivateAssemblies Files\Microsoft Visual Studio ??????
    • ?????? Services\ReportServer\bin Server\MSSQL.3\Reporting SQL Files\Microsoft
  • ?????? ??????? 2000? ??? ?? .dll ??? ???????? ???????:
    • ?????? ???? Server\80\Tools\Report SQL Files\Microsoft
    • ?????? Services\ReportServer\bin Server\MSSQL\Reporting SQL Files\Microsoft
?????? ???? ???? ??? ?? ??? ???? ???? ?????? ???????? ???????? ???? ?? ????? ??????. ???????? ?????? ?? ????? ????? ????? ??????? ??? ??????. ????? ??? ????? ???? ???? ???? use.
@ECHO OFF
REM   Name: SRSDeploy.bat
REM
REM   This batch files copies my custom assembly to my Reporting Services folders.
REM   Run this from the directory where the customer assembly was compiled.
REM   Be sure to close any applications that have your custom assembly open. 
REM
REM   This is the SQL Server 2005 version:
copy SimpleClassLibrary.dll "C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies"  
copy SimpleClassLibrary.dll "C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin" 
REM This is the SQL Server 2000 version:
REM copy SimpleClassLibrary.dll "C:\Program Files\Microsoft SQL Server\80\Tools\Report Designer"
REM copy SimpleClassLibrary.dll "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\bin"
I ?????? ??? ?????? ???? ?? ???? ????? ??? post-build ???? ?? ??????? ????? ??. ?????? ????? ????? ??? ????? ???????. ??? ???? ???? ??? ????? ??????? ????? ?? ???? ??? ????? ?????. ??? ??? ???? ?????? ????? ?????. ???? Post-build ??? ??????? ????? ?? ???? ?? ???:
???? "$ (TargetPath)" "C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\"
??? "$ (TargetPath)" "C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin\"
??? ?????? ????? post-build ????? ???? ??????? ????? ??. ?????? ??? ???? ?? ????????? ??? ????? ????? post-build ?? ?????? ???? ???? ????? Microsoft (MSDN) ?????? ??? ?????:
http://msdn2.microsoft.com/en-us/library/42x5kfw4.aspx

????? ???? ??? ???? ??????? ?? "????? ????????"

?????? ???? ??????? ??????? ???? ??????? "????? ????????" ?? ???? ????? ". ?????? ????? ???? ??????? ???????:
  1. ???? ??????? ???? ????? ?????? ??????? ???????.
  2. ?? ??????? ????? ???? ??? ????? ???????.
  3. ?? ???? ?????? ????? ????? ???? ??? ????? ??????? ?????.
  4. ??? ????? ? ???? ??? ?? ????? ????? (...) ???? ????? ????? ?????? ??? ???????.

    ?????? ?? ?????? ???? ??? ?? ??? ??????? ???????? ??? ????. ?? ??? ?????? ?????. ???? (????? ????? ??? "????????" ?? ??? ????? "????? ???????? ?????? ???) ???? ?? ????? ????? ?? ???? ????? ?????? ?? ???? ??? ???? ???????. ?? ????? ??????? ???? ???????? ?????? ???????? ???????? ?? Microsoft Visual Basic ?????? ????? ?? C#. ???? ?? ???? ?????? ??????. ???? ???? ???, ??? ??? ????? ??????? ??????? ??? ????? ???? ???? ????? ??? ?????? ??? ? ??? ????? ??? ????? ??? ?????? ?? ?????? ????. ???? ?? ????? ??????? ??? ??? ??????? ?? "????? ????????" ?? ???? ???????? ?????? ???????? ???????? ?? Visual Basic ? ??? ??????? ??? "??????? ????? ?? ?????? ????.
  5. ?? ???? ?????? ????? ??????? ? ???? ??? ???????. (?? SQL Server 2005? ???? ??? ????? ??????? "???????".)
  6. ??? ???? ?? ???? ??? ????? ????. ???? ??? ???. (?? SQL Server 2005? ???? ??? ????? ????? ?? ??? ".)
  7. ?? ???? ?????? ????? ????? ? ???? ??? "?????".
  8. ?? ???? ?????? ????? ????? ???? ??? "?????".
??? ????? ???? ????????? ??????? ??????? ?? "????? ????????".
  1. ???? ??????? (??? .rdl) ?? "???? ?????".
  2. ??? ????? ??????? ??????? ??????? ?? ????? ???????? "? ??? ???? ??. ?????? ????? ???? ???? ?? ???? ?? ???? ??????? ??? ???????.
  3. ?? ????? ???? ???? ???? ??? ??????? ???? ? ?? ?? ???????? ???? ???????? ???? ?????? ??????.
    =ClassLibraryName.ClassName.MethodName or Namespace.ClassName.MethodName
    ?? ?????? ????? ?? ??? ??????? ???????.
    =SimpleClassLibrary.Class1.DoSomething()
    ??? ??????? ??????? ???? ???????? ??? ??? ?? "????? ????????". ??? ???? ??????? ?????? ??????? ?????? ???? ??????? ????? ????????? ????????.
    =Code.MethodName()
    ??? ??????? ??? ???? ?? ???? ????? ??????? ? ?????? ????? ?? ??? ????? ????? ???????? ?????? ??? ??????? ??????.
    =Code.InstanceName.Method
    ?????? ????? ?????? ????? ?? ???? ????? ??? ???? ??????? ????? ???????? ??? ????. ?????? ????? ????? ????? ???????? ??? ????? ????? ? ???? ??? ????? ??????? ????? ? ?? ?? ?????? ??? ????? ???? ?????? ?? ?????? ????.

??? ???? ?????? ??? ???? ??????? ??????? ????? ?????? ??????

??? ???? ??????? ??????? ?????? ???? ?? ?????? ????? ????? ?????????? ? ??? ????? ??? ????????? ???? ?????? ??? ????????? ????????. ?? ???? ???? ????? ?????? ???? ?????? ??? ????????? ???????? ??? ?????? ?????? "#Error" ?? ??????? ?????? ????? ?? ????? ?? ??????? ????????. ?????? ??? ????? ????? ????? ???? ????? ??????? ?????? ?? ??? ??? ?? ???? ??? ??????? ?? ?????? ??? ??????? ????? ??? ????? ??? ?????? ?????? ??????? ??????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
842419????? ??? ?????? ??? ????? ???? ?????? ????? ?? ????? ?? "????? ????????"
?????? ????? ??????? ?????? ?????? ???????? ?? ????? ??? ??? ??? ???? ????? ???? ?????? ??? ????????? ????????. ?? ???? ?????? ??????? ??????? ???? ?? ???? ?????? ??? ????? ??????? ???????.

?? ?????? CodeGroup ????? ????? ???? ?? ?? ??? ?????? ??? ?????. ?????? ????? ?? ???? ??? ?????? Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\rssrvpolicy.config ?? ?? ?????? ???????? ???????? ???????.
<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>
???? ?????? ??? ???? ??????? ????? ????? ?? ????? ??? ????? ????? ?????? ????????? ????????. ????? ??? ??????? ??????? ?????? ??? ??????? ?? ????????? ??????? ???? ??? ????? ?????? ?? ????????.

?????? ??? ????? ????????? ??????? ???? ??? ?????? ?? "???? ?????". ??? ???? ?? ??? ??? ????? ???? ???? ?? ???? ????? ??????? ??????? ?? "???? ?????" ????? ????? ???????? ?????????? ??? ?????. ?????? ?? ??? ??? ???? ??????? ? "???? ?????" ????? ????????? ??????? ?? ?????? "FullTrust". ??? ???? ??? ??? ???????? ??? "???? ?????" ?? ????? ????? ????????? ???? ?? ???? ?? "???? ?????" ??? ????? ?????. ?? ???? ???? ??? ???????? ???? ?????? "#Error" ?? ???? ???? ??????? ????? ?? ??????? ???????? ?? ??????? ???????.

????????? ???????? ???????

????????? ???????? ??????? ?? ????????? ???????? ???? ??? ??????? ?? ?????? ??????? ?????? ?? ???? ?????? ????? ???????. ????????? ???????? ??????? ?? ???? ??? ?????? ??? ????????? ???????? ???? ???? ????? ??? ???? ?? ??????? ????? ??. ??? ??? ???? ?? ????? ??????? ????????? ???????? ?? ?????? ?????? ?? ??????? ?? ???? ????? ???? ???? ????. ?????? ???? ????? ???? ??????? ???????:
  1. ?? ??????? ????? ???? ??? ????? ???????.
  2. ?? ???? ?????? ????? ????? ???? ??? ????? ??????? ???
  3. ????? ???? ??????? ?? ???? ??? ?????.
    Public Function EmbeddedFunction() as String
     	Return "this is from embedded code function"
    End Function
    
  4. ?? ???????? ????? ???? ?? ????.
  5. ??? ?????? ??? ??????? ????.
    =code.EmbeddedFunction
???? ????? John ?? ????? ??????? ??? ??? ???????. ??? ????? ?????? ?? SQL Server ? ??? ???? ????? Microsoft ? enjoys ????? ?? ??????? ? ?? ?????? ????. ???? ?? ???? ??????? ??? ?????! ????? ???????! ????? ????? ?? ????? ??????? ??? ???????? ???? ???? ???????? ?? ???????? ????? ?? ?? ??????? ???????? ????? Ask For It.

???????

???? ???????: 920769 - ????? ??? ??????: 07/????/1428 - ??????: 1.0
????? ???
  • Microsoft SQL Server 2005 Reporting Services
  • Microsoft SQL Server 2000 Reporting Services
????? ??????: 
kbmt kbhowto KB920769 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????920769

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com