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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Modify Reports Data So...
Small and medium business | Business Central, N...
Answered

Modify Reports Data Sorting

(0) ShareShare
ReportReport
Posted on by AntonisK 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

Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Verified answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    Teddy Herryanto (Th... 14,284 Super User 2025 Season 2 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
    AntonisK 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
    AntonisK 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
    Daniel Mitrea 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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,664

#2
YUN ZHU Profile Picture

YUN ZHU 960 Super User 2025 Season 2

#3
Jainam M. Kothari Profile Picture

Jainam M. Kothari 773 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans