Normal Topic Sorting a total only report (Read 383 times)
CapitalG
Full Member
Members
***
Offline



Posts: 143
Location: Phoenix, Arizona
Joined: Mar 4th, 2003
Sorting a total only report
Nov 5th, 2010 at 3:01am
Print Post Print Post  
I have a "totals only" report created following direction from other posts in this forum.  It works great.  How do I go about taking the resulting report totals and sort them by one or more of the values?  Do I need to add another view?  I am at a loss to see where I can "capture" the data to work with it in programming.
Thank you for any guidance or samples you can provide.
  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Sorting a total only report
Reply #1 - Nov 5th, 2010 at 12:04pm
Print Post Print Post  
The only way to sort by summary values is to capture them in code in the first place, sort in code, then emit the entire report yourself.

A lower impact way is to run your totals only report in an HTML mode, then open the resulting file in a spreadsheet program like Excel. At that point, it becomes a set of live figures that you can sort and work with interactively.
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged
 
CapitalG
Full Member
Members
***
Offline



Posts: 143
Location: Phoenix, Arizona
Joined: Mar 4th, 2003
Re: Sorting a total only report
Reply #2 - Nov 5th, 2010 at 2:25pm
Print Post Print Post  
Thank you.  You just saved me from spending hours trying to figure it out.
  
Back to top
 
IP Logged