Microsoft
70-466 · Question #15
70-466 Question #15: Real Exam Question with Answer & Explanation
Sign in or unlock 70-466 to reveal the answer and full explanation for question #15. The question stem and answer options stay visible for context.
Build reports
Question
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.)
Options
- AAdd 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.
- BAdd 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.
- CFor each header text box, assign expressions to the Color and BackgroundColor properties. Add two Microsoft Visual C# functions to the code block of the report to implement Color and BackgroundColor functions.
- DAdd 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.
Unlock 70-466 to see the answer
You've previewed enough free 70-466 questions. Unlock 70-466 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#report variables#dynamic color formatting#BackgroundColor property#code functions