Skip to main content
Solved

Reporting Sorting Option

  • February 10, 2022
  • 2 replies
  • 333 views
  • Translate All

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

 

View original

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

 

Translate

Forum|alt.badge.img+3

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. 

Translate