Small and medium business | Business Central, N...

How to print report with descending order?

(1) Share

Report

Posted on by Manuel Lozada

373

Hi Community,

Do you know how I can print a report in descending order, in this case, opportunities no.?

this is my report extension:

If you know how, i will appreciate.

Thanks

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Gerardo Rentería Ga... 26,790 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi

I hope this can help you.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/properties/devenv-dataitemtableview-property

BR

GR

Was this reply helpful? Yes No
Suggested answer

Touil Yahya 220 on at

Like (2)

Report
Copy link

Link copied!
Hi,

Give this a shot:

reportextension 50101 OpportunitiesRSMReport extends "Salesperson - Opportunities" { dataset { add(Opportunity) { // add a new field to the dataset column(DateClosed; Opportunity."Date Closed") { } } } trigger OnPreReport() begin /* This will run after the original report's equivalent trigger */ Opportunity.SetCurrentKey(Opportunity."No."); Opportunity.SetAscending("No.", false); end; }

Hope this will help.

Best regards,
Touil Yahya

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 101,018 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, try the following?

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Saurav.Dhyani 14,419 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Hi,

You should get an idea from this video - https://youtu.be/y6ZTfDVM78A?si=LaBYJKgTkin6MBsv.

This video explains how you can dynamically group your data in a report based on user choice.

With business central, now you can also add additional layout to a report where you can make changes and using report extension you can just add a field and option in Request page for user to choose.

If you still have question, please let me know.

Regards,

Saurav Dhyani

https://bit.ly/SubscribeSauravYouTube

Was this reply helpful? Yes No
Manuel Lozada 373 on at

Like (0)

Report
Copy link

Link copied!

Hi Community,

Thank you for reply my question, I tried with your suggested code, but still I cannot print my report in descending order, If you have another idea I would appreciate it.

Thank you

Was this reply helpful? Yes No