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?
A.
Add a group for the Price field.
B.
Add a custom action to the Price text box.
C.
Set the SortExpression property to =Fields!Price.Name for the Price text box.
D.
Set the SortExpression property to =Fields!Price.Value for the Price text box.
E.
Set the SortExpression value to =Fields!Price.Description for the Price text box.
F.
In the Expression dialog box for the Price text box, enter the =SortBy Fields!Price.Value expression.
G.
On the Row Visibility dialog box, select the Display can be toggled by this report item check box. Then
select the Price text box.
H.
In the Interactive Sorting page of the Price textbox properties, select the Enable interactive sorting on this
text box check box, and then select the Price fieldfor the Sort by property.
H is the only correct ans.
No, D is also a valid option from within a table. Make sure to select the cell itself though, when selecting the text only the SortExpression property is not available.