PrepAway - Latest Free Exam Questions & Answers

Which is the correct answer to make sure that the report items are grouped through the first character in the

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?

PrepAway - Latest Free Exam Questions & Answers

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)

 


Leave a Reply