web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Modify Reports Data Sorting

(0) ShareShare
ReportReport
Posted on by 260

Greetings to all of you.

A customer of mine , asked me if its possible to modify the report 321 ( Vendor - Balance-To-Date )  sorting , fro based on Entry No to based on Posting Date.

I created a new report of mine and copied the code of the standard report.

I did this to the rdlc layout as well ( basically i exported the report 321 layout and import back to my report 50010 ). 

After that i went on the code, i searched for the word " Sorting " and changed the values from Entry No to Posting Date. However it doesn't seems to work. 

pastedimage1647430084089v1.png

pastedimage1647430101710v2.png

Anyone knows why? Did i have to do something different? 

Does the rdlc makes any difference on the report sorting ? Because if it does, i guess that copying the layout of the base report ( id 321 ) is a mistake from my side.

Thank you in advance for your time.

With respect,

Antonis

I have the same question (0)
  • Verified answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    14,306 Super User 2026 Season 1 on at

    It's probably safer and easier to do this is on the rdlc side.

    Use Custom Report Layouts to export the rdlc layout. Open the rdlc report, click on the table, and change the sorting. Reimport.

    No need to do new report.

  • AntonisK Profile Picture
    260 on at

    TeddyH

    Thanks for your reply.

    I got the report 321 layout exported, setup the sorting as below , and still it doesnt work. What am i doing wrong?

    PrintScreen --> https://prnt.sc/pIPn5QcgUW7w

  • AntonisK Profile Picture
    260 on at

    Ok i found what it was. I needed to set the Filter on the Details Properties , not the Tablix Properties.

    The filter i used was : CDate(Fields!PostDt_VendLedgEntry3.Value).ToString("yyyy-MMM-dd").

    TeddyH Props to you for letting me know that i can sort the reports on the rdlc itself.

  • Daniel Mitrea Profile Picture
    34 on at

    AntonisK I have used the same filter on details but is doing a wrong sorting. Do you know why ?

    pastedimage1670842163111v1.png

    pastedimage1670842217450v2.pngit seems that is sorting only the year.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 580 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 480 Super User 2026 Season 1

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 261 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans