List reports with sub-summaries must always be sorted by the break field so that, if you want the records first by Department and then by Month/Year and those are your leading parts (in that order), they must always be sorted by Department and Month/Year (in that order). Could this be what is happening? :smileyhappy:
As I am beginner I would assume that when I set up a new Layout with the assistant and followed all the steps, the List Report would always be sorted that way.
You are probably right. I will try it and let you know how I do.
Although Im still confused why it works fine in form view but not in list view. I have a lot of studying to do!
I'm getting close. I sorted by department and it almost worked. How do I get all the departments to show up?
Perform a find for the records you want to show in the report. Sort it by your leading part(s). Enter Preview Mode. If vs. 10 you can view it in Browse.
Last question. How could I have the report always view by Department and show all Departments? Would that be done by a script?
Yes, by script. It would look something like:
Go To Layout [ this list layout ]
Show All Records
Sort [ by department ]
Then when you want this report, fire this script.
You made my day!