Microsoft
70-460 · Question #20
You are developing a SQL Server Reporting Services (SSRS) report that renders in HTML. The report includes a dataset with fields named Description, Price, and Color. The report layout includes a…
The correct answer is B. Set the SortExpression property to =Fields!Price.Value for the Price text box. See the full explanation below for the reasoning.
Question
You are developing a SQL Server Reporting Services (SSRS) report that renders in HTML. The report includes a dataset with fields named Description, Price, and Color. The report layout includes a table that displays product details and also includes columns named Description, Price, and Color. You need to modify the report so that users can sort products by the Price column. What should you do?
Options
- AAdd a custom action to the Price text box.
- BSet the SortExpression property to =Fields!Price.Value for the Price text box.
- CIn the Expression dialog box for the Price text box, enter the =SortBy FieldslPrice.Value expression.
- DSet the SortExpression value to =Fields!Price.Description for the Price text box.
How the community answered
(34 responses)- A3% (1)
- B74% (25)
- C18% (6)
- D6% (2)
Community Discussion
No community discussion yet for this question.