You are a database developer and you have about two years experience in creating
business intelligence (BI) solutions by using SQL Server2008. Now you are employed in a
company which is named NaproStar and work as a developer of a SQL Server 2008
Reporting Services (SSRS) for the company. You use SSRS to design a report with a
dataset contained and a Table data region used. Besides, a column named FirstPicture is
contained in the dataset. Now you get an order from your company CIO, according to his
requirement, you need to make sure that the second character in the FirstPicture column
makes group for the report items. Which option below would be chosen?
A.
=Second(Fields!FirstPicture.Value) in the Group properties dialog box should be used
B.
=Fields!FirstPicture.Value.Substring(0,1) in the Group properties dialog box should be
used
C.
=Second(Fields!FirstPicture) in the Group properties dialog box should be used.
D.
=Fields!FirstPicture.Value in the Group properties dialog box should be used