You need to create a strategy for deploying the formatting and code across the entire enterprise reporting solution

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.)

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.)

A.
Create a report as a template. Apply standardizedformatting to the template. Store code in the Code
section of the template.

B.
Build a web service that retrieves formatting properties and runs code. Call the web service througha report
dataset.

C.
Store the formatting properties and code in database objects. Use stored procedures to populate a default
value for report parameters and map each parameter to a corresponding formatting property.

D.
Create an assembly that contains formatting properties and code. Deploy the assembly on the Reporting
Server and reference the assembly from each report.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Mahmoud Ibrahim

Mahmoud Ibrahim

D is Correct