Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 177

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
  • Daniel Mitrea Profile Picture
    Daniel Mitrea 34 on at
    RE: Modify Reports Data Sorting

    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.

  • AntonisK Profile Picture
    AntonisK 177 on at
    RE: Modify Reports Data Sorting

    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.

  • AntonisK Profile Picture
    AntonisK 177 on at
    RE: Modify Reports Data Sorting

    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

  • Verified answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    Teddy Herryanto (Th... 12,925 Super User 2024 Season 1 on at
    RE: Modify Reports Data Sorting

    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.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,234 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,994 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans