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?
A.
You should utilize =First(Fields.FirstName)
B.
You should utilize =Fields!FirstName.Value
C.
You should utilize =Fields! FirstName.Value.Substring(1,2)
D.
You should utilize =Fields!LastName.Value.Substring(0,1)
Explanation:
http://msdn.microsoft.com/en-us/library/bb630426.aspx
Group by the first letter of the last name. =Fields!LastName.Value.Substring(0,1)