Sorting By Division

[pmacduff]

I'm doing another one of my stress-inducing modifications to a report...I'm trying to get an existing report to sort by division and then to print the division name at the top of each group. I tried copying a Relius report sorted by division in how it was sorted and defined for divisions, but mine keeps bombing out. Can anyone tell me what tables I need and what variable I should be using to print the entire division name at the top of each page? I didn't think this would be that hard...any help is greatly appreciated........Patti

[Tom Poje]

what type of report? You know in my insanity I might have one already - or one you can modify easily.

[pmacduff]

Hi Tom! It's actually an "Account Activity Report" (detailed) that is similar to the ones I used in FDP. It has the detail alpha by participant by source and fund. I want it to sort by division as well. There is also an "Account Activity" Totals report (also old FDP format) that I got to sort by division and print division names, but each division had the same overall plan totals :confused: I've attached the modified report that I used for my non-division clients...this is the report I want to sort by division with division names at the top of each group. As always, Tom, I appreciate your assistance and input! Patti

[Tom Poje]

Hi back at you Patti!

(Some day I gotta meet this lady who is 'stealing' my reports. Ha! Actually she modifies them a little bit and makes them even better)

I am a bit bogged down with work at the moment.

Enclosed is a Summary of Accounts that sorts by division and the division id (rather than name) appears at the top of each division. I am assuming it should be easy to modify. Or, from what I can tell, you can take a quick look and see how the groups are set up and modify your report to do the same.

[pmacduff]

Many thanks Tom! Are you sure that Corbel isn't in need of a contractor to design reports for them?....you are all down there in Florida together...

[Tom Poje]

you compliments are much too kind.

but thanks anyway!

I have bumbled (an accurate description) my way through producing reports to meet some specific needs, and never have had a problem sharing them, as long as people realize there is the possibility of errors in my reports.

generally, all it takes is a request like you posted, and I can always check and see if I have one that comes close to fitting what is desired.