1 / 11

Extending SSRS with Custom Code

Extending SSRS with Custom Code. Devin Knight (@knight_devin) Pragmatic Works BI Consultant and Trainer. About Me. BI Consultant and Trainer with Pragmatic Works Author of 3 SQL Server books MCP, MCITP Certified Has spoke at past events like PASS, Code Camps, User Groups and SQL Saturdays.

aletta
Download Presentation

Extending SSRS with Custom Code

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Extending SSRS with Custom Code Devin Knight (@knight_devin) Pragmatic Works BI Consultant and Trainer

  2. About Me BI Consultant and Trainer with Pragmatic Works Author of 3 SQL Server books MCP, MCITP Certified Has spoke at past events like PASS, Code Camps, User Groups and SQL Saturdays

  3. Agenda Why Use Custom Code? Direct Embedding External Assemblies

  4. Why Use Custom Code? Extends the capability of SSRS Expressions Compartmentalize reusable code Consistency among Report Developers Does not work with Report Parts

  5. Agenda Why Use Custom Code? Direct Embedding External Assemblies

  6. Using Embedded Code Pros More than one function can be embedded but not ideal Immediately see the results of code without creating a VS project Cons Must use Visual Basic No intellisense in the code window Code errors are not visible until report preview

  7. Using Embedded Code Only way to debug results is to Preview a report Fields must be represented with expressions using this template: =Code.FunctionName(Parameter)

  8. Agenda Why Use Custom Code? Direct Embedding External Assemblies

  9. Using External Assemblies Pros Can be any .Net language Updates to code can be managed from outside of SSRS Cons Deployment is a bit tedious Assemblies will have restricted access to system resources

  10. Using External Assemblies Cont. Create VS project and “strong name” the assembly <Assembly: AllowPartiallyTrustedCallers()> DLL must be deployed to: C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\bin and install into the Global Assembly Cache (GAC) C:\Windows\assembly Compartmentalize reusable code

More Related