You are developing a SQL Server 2008 Reporting Services (SSRS) report which includes a table for Company. com. You should make sure that different rows in the table own a yellow background. Which is…

The correct answer is B. =iif(RowNumber(Nothing) Mod 2, "Yellow", "White"). IIf(expr, truepart, falsepart) All three parameters are required: expr is the expression that is to be evaluated. truepart defines what the IIf function returns if the evaluation of expr returns true. falsepart defines what the IIf function returns if the evaluation of expr…

Implement a Reporting Services Solution

Question

You are developing a SQL Server 2008 Reporting Services (SSRS) report which includes a table for Company. com. You should make sure that different rows in the table own a yellow background. Which is the correct answer?

Options

A=iif(RowNumber(Nothing) / 2, "Yellow", "Black")
B=iif(RowNumber(Nothing) Mod 2, "Yellow", "White")
C=iif(RowNumber(NULL) Divide 2, "Yellow", "White")
D=iif(CountRows(NULL)/2, "Yellow", " Black ")

How the community answered

(46 responses)

A
7% (3)
B
80% (37)
C
2% (1)
D
11% (5)

Explanation

IIf(expr, truepart, falsepart) All three parameters are required: expr is the expression that is to be evaluated. truepart defines what the IIf function returns if the evaluation of expr returns true. falsepart defines what the IIf function returns if the evaluation of expr returns false. The MOD function can be used to divide numbers in Excel. Unlike regular division, however, the MOD function only gives you the remainder as an answer. The syntax for the MOD function is: = MOD ( Number , Divisor )

Topics

#alternating row color#RowNumber#Mod expression#SSRS table formatting

Community Discussion

No community discussion yet for this question.

Full 70-448 Practice