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 color scheme combination of foreground and background colors.
You need to ensure that all of the text boxes in the table headers use the correct business
unit colors.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)
A.
Add one report variable for Color. Assign it with an expression to return the appropriate
colors. For each header text box, set the Color and BackgroundColor properties by using the
variable.
B.
Add two report variables named Color and BackgroundColor. Assign them with
expressions to return the appropriate colors. For each header text box, use expressions to
set the Color and BackgroundColor properties by using the variables.
C.
For each header text box, assign expressions to the Color and BackgroundColor
properties.
D.
Add two Microsoft Visual C# functions to the code block of the report to implement Color
and BackgroundColor functions. For each header text box, use expressions to set the Color
and BackgroundColor properties by using the functions.
“C” is ok, but would cause a lot of work
“A” is stupid, as color and background color will be the same
“D” requires installation of additional code, what usually is not the best solution. Additionally c# code is not supported here, only Visual Basic
https://msdn.microsoft.com/en-us/library/ms156028(v=sql.120).aspx
so
“B” is correct! 2 variables, two colors, used in expressions in the controls.
I think D is correct.
You could add C# functions to the code block providing custom assemblies.
Depending on the amount of report items you have in the report, this could be a better and easier to maintain solution.
Well, C# code is not supported. Only VB.
I would go with A – with the business unit value you can control color scheme.