Microsoft
70-448 · Question #288
You design a report by using SQL Server 2008 Reporting Services (SSRS). The report uses a Table data region and contains a dataset. The dataset has a column named LastName. You need to ensure that…
The correct answer is D. =Fields!LastName.Value.Substring(0,1). See the full explanation below for the reasoning.
Question
You design a report by using SQL Server 2008 Reporting Services (SSRS). The report uses a Table data region and contains a dataset. The dataset has a column named LastName. You need to ensure that the report items are grouped by the first character in the LastName column. Which expression in the Group properties dialog box should you use?
Options
- A=First(Fields!LastName)
- B=Fields!LastName.Value
- C=First(Fields!LastName.Value)
- D=Fields!LastName.Value.Substring(0,1)
How the community answered
(47 responses)- A15% (7)
- B11% (5)
- C4% (2)
- D70% (33)
Community Discussion
No community discussion yet for this question.