Microsoft
70-768 · Question #41
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 D. Set the SortExpression property to =Fields!Price.Value for the Price text box. E. In the Interactive Sorting page of the Price text box properties, select the Enable interactive. 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 group for the Price field.
- BAdd a custom action to the Price text box.
- CSet the SortExpression property to =Fields!Price.Name for the Price text box.
- DSet the SortExpression property to =Fields!Price.Value for the Price text box.
- EIn the Interactive Sorting page of the Price text box properties, select the Enable interactive
How the community answered
(30 responses)- A17% (5)
- B10% (3)
- C3% (1)
- D70% (21)
Community Discussion
No community discussion yet for this question.