Which option below would be chosen?

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?

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



Leave a Reply 1

Your email address will not be published. Required fields are marked *


pj

pj

=Fields!FirstPicture.Value.Substring(0,1)
groups by first letter, not second as required in a question:

“you need to make sure that the second character in the FirstPicture column makes group for the report items”

Question or answer is wrong