Default Sort Order for Groups in Report Builder [closed]

Closed. This question is off-topic. It is not currently accepting answers.

---

开发者_如何转开发

Want to improve this question? Update the question so it's on-topic for Stack Overflow.

Closed 11 years ago.

Improve this question

I cannot get the default sort order to work (on a date) in Report Builder when applied to a Group. I can get interactive sorting to work, and I can get Tablix sorting to work on tables without groups.

I tried right-clicking on the table and then selecting "Tablix Properties" and then selecting Sorting and then using the expression CDate(Date). (Date is the name of the group I want to sort by). Interactive sorting works fine using that expression.

---

1. Choose the detail row below the group at the bottom.
2. Right click and choose edit group properties.

   • 

3. Go to the sorting tab and add the date field without CDate

   •