PrepAway - Latest Free Exam Questions & Answers

How should you configure the report?

You work as a SQL Developer at ABC.com. The company uses a Microsoft SQL Server 2012
infrastructure.
A production application stores data in a SQL Server database. Production users want to be able
to view a report of the data stored by the production application.
You plan to create a report using SSRS (SQL Server Reporting Services) to display the production
data. Your report will include a table with three columns. The columns are named Start, Finish
and Duration.
Production users need to be able to view the report table and sort the data in the table by the
Duration column.
How should you configure the report?

PrepAway - Latest Free Exam Questions & Answers

A.
You should configure =Fields!Duration.Value as the SortExpression property for the Duration
text box.

B.
You should configure a custom action for the Duration text box.

C.
You should configure =Fields!Duration.Start as the SortExpression value for the Duration text
box.

D.
You should configure a custom action for the Start, Finish and Duration text boxes.

Explanation:


Leave a Reply