Microsoft
70-466 · Question #2
70-466 Question #2: Real Exam Question with Answer & Explanation
The correct answer is B: Set the SortExpression property to =Fields!Price.Value for the Price text box.. Enabling interactive column sorting in an SSRS HTML report requires setting the SortExpression property on the column header text box to the target field value.
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 Fields!Price.Value expression.
- DSet the SortExpression value to =Fields!Price.Description for the Price text box.
Explanation
Enabling interactive column sorting in an SSRS HTML report requires setting the SortExpression property on the column header text box to the target field value.
Common mistakes.
- A. Custom actions configure drillthrough navigation or hyperlink behavior on a text box, not interactive data sorting.
- C. =SortBy is not a valid built-in function in the SSRS expression language; no such function exists for sorting datasets.
- D. Fields!Price.Description is not a valid member reference for a numeric Price field - the correct member for sorting is Value, not Description.
Concept tested. SSRS interactive sort via SortExpression property
Community Discussion
No community discussion yet for this question.