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.
ssrs code block only admits Visual Basic Code.
https://msdn.microsoft.com/en-us/library/ms156028.aspx
¿¿??
As Raul wrote c# is not allowed, so the answer D is not correct. I would recommend the C, as this would make the least effort. Once defined variable that will be used in all the others control properties of the report.
1 variable should be enough to adjust font size and font scheme ?
no?
so A
Surely you need one variable for each property?
http://blog.blumshapiro.com/blog/2013/06/26/dynamic-cell-formatting-in-ssrs-2/
Per the question, we are only querying the business unit. So you should only need one parameter. The report can later pull the two properties using that one parameter
Each business unit has a unique font scheme combination of font and size properties.
so A seems to be better.
The text mentions FONT(font Family) and SIZE properties. Nothing about COLOR (??).
Moreover, two parameters seems legit for me. One combination per Business units and you obtain your “font” (including size) properties.
So C for me. 🙂
The question doesn’t mention color, but all the answers are related to color. So here are three things:
– FontFamily
– FontSize
– Color
B and D are out of consideration obviously.
A doesn’t mention how to define FontSize, so I would vote for C.
A is better bet, you need to control the font scheme depending on the business unit selected.. you don’t need two variables to do this.
C is the best option