Skip to main content
Solved

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

  • 10 December 2020
  • 4 replies
  • 988 views

Forum|alt.badge.img+5
  • Captain II
  • 398 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

 

View original
Did this topic help you find an answer to your question?

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+5
  • Author
  • Captain II
  • 398 replies
  • December 11, 2020
BKasimov38 wrote:

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
  • 144 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 I
  • 177 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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings