Skip to main content
Answer

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

  • December 10, 2020
  • 4 replies
  • 1144 views

Forum|alt.badge.img+6

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
  • 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
  • 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
  • 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
  • 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