You are developing a new SQL Server Reporting Services (SSRS) report in SQL Server
Data Tools (SSDT).
The report must define a report parameter to prompt the user for the business unit. Each
business unit has a unique font scheme combination of font and size properties.
You need to ensure that all of the text boxes in the table headers use the correct business
unit font properties.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)
A.
Add one report variable for FontFamily Assign it with an expression to return the
appropriate colors. For each header text box, set the Color and FontSize properties by using
the variables.
B.
For each header text box, assign expressions to the FontFamily and FontSize properties.
C.
Add two report variables named FontFamily and FontSize. Assign them with expressions
to return the appropriate colors. For each header text box, use expressions to set the
FontFamily and FontSize properties by using the variables.
D.
Add two Microsoft Visual C# functions to the code block of the report to implement
FontFamily and FontSize functions. For each header text box, use expressions to set the
FontFamily and FontSize properties by using the functions.