Hello. In two different reports, I have values that will not sort.
First value is a calculated field =year(date.value) . The field shows correctly in reports, but when I try to add it to sorting in the row grouping, it won't. It's fixed at ascending (2008, 2009, etc.)
Second report is ab_new_areaValue, which is an integer. It won't sort in the tablix at all.
It seems like row grouping doesn't work on numbers, just letters? Is there a way to sort a tablix by number?
What can I check to understand where this problem is?