More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...)
Using Report Builder, which of the following is the best statement about the formatting options for boolean columns?
Answer
Booleans are formatted as True/False and there are no other built in options, but you could build an expression using IIF that would let you do other formatting
Explanation
From the format dialog there are no extra formatting options for booleans, Report Builder renders them as True/False. Writing an expression that you add to the model view is the easiest way to work around this limitation.
(Continued on next question...)
