July 20, 200421 yr I have a sales report in preview mode. I have a summary field showing sub-totals, I would like the report sorted by this field so that the higher sales figures sit at the top of the report. When I look at my report in preview mode it is sorted by product, I have to click 'sort' then the checkbox to include summary fields, then move the summary sub total field into the right hand field list, then click 'descending order', then click 'sort'. Question is - How can I automate this? Surely it must be possible Thanks for any help
July 20, 200421 yr Preform the sort, then write a script using the sort command. The script will remember the sort.
Create an account or sign in to comment