You are a database developer and you have about two years experience in creating
business intelligence (BI) solutions by using SQL Server2008.
Now you are employed in a company which is named NaproStar and work as a developer of
a SQL Server 2008 Reporting Services (SSRS) for the company.
You use SSRS to create a report with a table contained.
Besides, the table contains alternate columns.
Now you get an order from your company CIO, according to his requirement, you have to
make sure the alternate columns have a light blue background.
So of the following code segments, which one would be used for each text box?
A.
=iif(CountColumns() / 2, ” lightblue “, “White”) would be used for each text box.
B.
=iif(CountColumns() Mod 2, ” lightblue “, “White”) would be used for each text box
C.
=iif(ColumnNumber(Nothing) / 2, ” lightblue “, “White”) would be used for each text box
D.
=iif(ColumnNumber(Nothing) Mod 2, ” lightblue “, “White”) would be used for each text
box.
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 )