Skip to main content
Solved

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

  • December 10, 2020
  • 4 replies
  • 1127 views

Forum|alt.badge.img+6
  • Captain II
  • 447 replies

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.

 

Best answer by BKasimov38

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

 

4 replies

BKasimov38
Jr Varsity II
  • 9 replies
  • Answer
  • December 10, 2020

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

 


Forum|alt.badge.img+6
  • Author
  • Captain II
  • 447 replies
  • December 11, 2020

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.

 


TimRodman
Pro I
Forum|alt.badge.img+1
  • Pro I
  • 154 replies
  • December 12, 2020

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


Forum|alt.badge.img+1
  • Semi-Pro II
  • 195 replies
  • January 30, 2024

I know this has been a old thread, but shouldn’t the Sorting definition happen within the Group?
Setting up a Group to sort by to accomplish Sorting within a Group is most of the time not feasible as detail gets lost and formatting sometimes gets thrown off. 

Any ideas?
This just seems like not the correct solution