You need to modify the report so that users can sort pr…

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?

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 text box properties, select the Enable interactive sorting on this
text box check box, and then select the Price field for the Sort by property.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Marchello

Marchello

D.
Set the SortExpression property to =Fields!Price.Value for the Price text box.