Reports

[TPAVP]

Does anyone know if you can specify how you want the system to sort your data? I haven't found much help on this nor does it seem that we have much choice.

Specifically, I have a 1000 life case that I need to sort by location. We have imported the locations in under the division thinking we could sort by division. I have been unsuccessful so far. Does anyone have any ideas?? :confused:

[Tom Poje]

are you talking reports or simply scrolling through census?

if its scrolling through census I don't think that is a feature yet.

if it is reports, they exist. we have one soa which uses user field 1 instead of division, but that would achieve the same results.

[TPAVP]

I was talking about the reports. Since I wrote, I have found the ones that sort by division. We have an internal problem because we have converted the reports to automatically print on our letterhead, but none of the reports we converted sort by division. I will have to get our people here to work on it. Thanks for the help though

[Guest RBlaine]

I created another formula field by copying the formula from @sortname and putting the div code at the beginning of the formula so that the new field would print:

001 Smith, John A

This field never gets printed but you can change the sort part to sort on this field rather than @sortname