Plaza 365
Plaza 365

No results found for your search

RegisterLog in

5

Dynamics 365 Business Central: Can we change the default sorting/line ordering of standard reports

Visit article

#change

#default

#reports

Dynamics 365 Business Central

Category

Oct 29, 2024

Published date

Text

Article Type

AI Summary

  • The article discusses changing the default line sorting/ordering of standard reports in Dynamics 365 Business Central.
  • The DataItemTableView property of the report determines the sorting order for lines in reports like "Standard Sales
  • Order Conf."
  • The DataItemTableView property cannot be customized, so alternative methods like using the OnAfterPreDataItem trigger in a report extension are suggested.
  • Two examples provided in the article demonstrate how to customize sorting by "No." in descending order or by quantity in ascending order.
  • The default sorting method for reports like "Inventory
  • List" is by the primary key, such as Item No.
  • To modify sorting in reports without predefined methods, developers may need to explore the standard code or recreate the report.
  • A codeunit example is given for subscribing to events like OnAfterLineOnPreDataItem to customize sorting for reports like "Standard Sales
  • Pro Forma Inv."
  • Additional resources and test suggestions are provided for further customization in Dynamics 365 Business Central reports.

Registered users can view the full text for FREE!

Sign In Now!