Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

Values not sorting in tablix SSRS report

(0) ShareShare
ReportReport
Posted on by 89

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?

pastedimage1654079208560v1.png

  • unicorn_tech Profile Picture
    unicorn_tech 89 on at
    RE: Values not sorting in tablix SSRS report

    Fetch XML, to make SSRS reports in visual studio.

  • Nya Profile Picture
    Nya 29,058 on at
    RE: Values not sorting in tablix SSRS report

    Hi,

    Would you please specify which application you are using in Dynamics?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,684 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,414 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans