Menu
I am trying to sort the following table:
hYear hSale
------------------------------------
[year] =Count(Fields!sale.Value)
The table only has one row group (year) and no column group. I'd like to:
-initially sort the table based on the calculated value; is it possible?
-add interactive sort to calculated column based on the value. I assume I should sort 'Detail rows', but what will be the sort expression?
976
In a table or matrix in report design view, right-click the text box in the column header for the group to which you want to add an interactive sort button, and then click Text Box Properties. Click Interactive Sorting. Select Enable interactive sorting on this text box. In Choose what to sort, click Groups.
Interactive sorting can be used to enable a user to toggle between ascending and descending order for rows in a table or for rows and columns in a matrix. In Bold Report Designer, you can configure interactive sorting for cells of a table or matrix using the User Sort property listed in tablix cell properties.
Yes on both:
Click on the table or grid to make little gray boxes appear. Click in the upper left corner and select properties. Select Sorting. Hit the 'Fx' button. Put in your expression you have above.
For dynamic sorting select the cell in a table (not the header) and click 'Text Box Properties. Select 'Interactive Sorting' and select 'Enable interactive sorting on this text box'. Put in your dataset column or else a custom expression like what you did above.
55
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
