You are designing a strategy for an enterprise reporting solution that uses SQL Server Reporting Services (SSRS). Many of the SSRS reports will use common utilities and functions, including the following:

Report utility functions and business logic in code

Standardized report formatting properties such as fonts and colors

for report branding Formatting may change and new functions may be added as the reporting solution evolves. You need to create a strategy for deploying the formatting and code across the entire enterprise reporting solution. You must also ensure that reports can be easily updated to reflect formatting and function changes. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

Question

You are designing a strategy for an enterprise reporting solution that uses SQL Server Reporting Services (SSRS). Many of the SSRS reports will use common utilities and functions, including the following:

Report utility functions and business logic in code
Standardized report formatting properties such as fonts and colors

for report branding Formatting may change and new functions may be added as the reporting solution evolves. You need to create a strategy for deploying the formatting and code across the entire enterprise reporting solution. You must also ensure that reports can be easily updated to reflect formatting and function changes. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

Accepted Answer

D. Create an assembly that contains formatting properties and code. A custom assembly deployed to the SSRS report server can be referenced by all reports via report properties, making utility functions and formatting constants available solution-wide from one compiled artifact. When formatting or business logic changes, only the assembly needs to be updated and redeployed - no individual report modifications are required - directly satisfying the easy-update requirement. This is the standard SSRS mechanism for sharing code across reports in an enterprise deployment.

Answer

A. Create a report as a template. Apply standardized formatting to the template. A report template applies standardized formatting only at report creation time; changes to the template after reports have been created do not propagate to existing reports, requiring manual updates across the entire report catalog.

Answer

B. Build a web service that retrieves formatting properties and runs code. A web service introduces network latency on every report render, creates an external dependency that becomes a single point of failure, and requires significantly more development and infrastructure effort than a compiled assembly.

Answer

C. Store the formatting properties and code in database objects. Storing formatting properties and code in database objects forces reports to query the database at render time for styling values, adds query overhead, and mixes presentation logic with data storage in a way that is harder to maintain than a versioned assembly.

You are designing a strategy for an enterprise reporting solution that uses SQL Server Reporting Services (SSRS). Many of the SSRS reports will use common utilities and functions, including the…

Question

Options

How the community answered

Why each option

Topics

Community Discussion