70-448 · Question #156
You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server 2008. Now you are employed in a company which is named…
The correct answer is B. =Fields!FirstPicture.Value.Substring(0,1) in the Group properties dialog box should be used. See the full explanation below for the reasoning.
Question
You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server 2008. 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?
Options
- 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
How the community answered
(47 responses)- A2% (1)
- B85% (40)
- C4% (2)
- D9% (4)
Community Discussion
No community discussion yet for this question.