Skip to main content
Answer

Reporting Sorting Option

  • February 10, 2022
  • 2 replies
  • 296 views

Forum|alt.badge.img

Is it possible to create a report where one of the parameters (?) or options is the user can select how they want the report sorted?

Example: I have a Sales Order based report, some of my users want to see the report sorted by Sales Order # and some of my users want to see the report sorted by Ship On date...

Best answer by Ahmed

@sarah this isn’t possible but you can have each user create their own Template after selecting the sorting conditions:

More info on report templates here:

https://help-2021r2.acumatica.com/(W(18))/Help?ScreenId=ShowWiki&pageid=5adbb4bd-4347-4f81-a1ff-4d4d47d1fb1b

 

2 replies

Ahmed
Varsity II
Forum|alt.badge.img+1
  • Varsity II
  • Answer
  • February 10, 2022

@sarah this isn’t possible but you can have each user create their own Template after selecting the sorting conditions:

More info on report templates here:

https://help-2021r2.acumatica.com/(W(18))/Help?ScreenId=ShowWiki&pageid=5adbb4bd-4347-4f81-a1ff-4d4d47d1fb1b

 


Forum|alt.badge.img+3
  • Pro II
  • February 10, 2022

Just noticed in some reports there are existing formulas that could be selected in the sorting conditions. No idea if this actually works but it would be worth a try. You just need to enter a formula for selecting the required sort field based on a parameter.