Solved

Why sorting in report designer does not work? Is it only effect for detail sections?

  • 10 December 2020
  • 3 replies
  • 71 views

Userlevel 4
Badge

Hello, I made a simple rpx like below.

I would like to sort the lines by inventoryCD.

I don’t know why. is it caused by the relationships below?

Or is it that the sorting did not work for group sections?

 

The result is not as expected. It is not sorted by inventoryCD.

 

icon

Best answer by BKasimov38 10 December 2020, 22:52

Hi Ray,

I’ve noticed in some cases that the grouping controls the sort and no matter what you going to specify in the sort section the group’s  sortorder will control the result

 

View original

3 replies

Hi Ray,

I’ve noticed in some cases that the grouping controls the sort and no matter what you going to specify in the sort section the group’s  sortorder will control the result

 

Userlevel 4
Badge

Hi Ray,

I’ve noticed in some cases that the grouping controls the sort and no matter what you going to specify in the sort section the group’s  sortorder will control the result

 

@BKasimov38 

    Thank you, so for my case own, if I‘d like to “Sort” by inventoryCD, then I set the group is by “InventoryCD”

       This indeed works. Thank you.

 

Userlevel 3
Badge

As far as I know, the Group sorting always takes place before the Detail sorting.

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2020  Acumatica, Inc. All rights reserved