Microsoft
70-448 · Question #131
You are developing a SQL Server 2008 Reporting Services (SSRS) report which utilizes a Table data region and includes a dataset which owns a column called TestName for Company.com. You should make…
The correct answer is D. You should utilize =Fields!LastName.Value.Substring(0,1). Group by the first letter of the last name. =Fields!LastName.Value.Substring(0,1)
Implement a Reporting Services Solution
Question
You are developing a SQL Server 2008 Reporting Services (SSRS) report which utilizes a Table data region and includes a dataset which owns a column called TestName for Company.com. You should make sure that the report items are grouped through the first character in the TestName column. Which is the correct answer?
Options
- AYou should utilize =First(Fields.FirstName)
- BYou should utilize =Fields!FirstName.Value
- CYou should utilize =Fields! FirstName.Value.Substring(1,2)
- DYou should utilize =Fields!LastName.Value.Substring(0,1)
How the community answered
(22 responses)- A5% (1)
- C14% (3)
- D82% (18)
Explanation
Group by the first letter of the last name. =Fields!LastName.Value.Substring(0,1)
Topics
#SSRS expressions#string functions#grouping#Table data region
Community Discussion
No community discussion yet for this question.