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?
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 “)
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 )