I've encountered a problem that's driving me insane! Probably because the answer is something rather simple and overlooked on my behalf. Anyway, I'd like to 'group' in my report. The data isn't in the necessary order, however I've an index which does this.

My question is, 'how do I use the index (established order) for this to work?' Or is there some other way (I thought about using a cursor, but the report created inaccurate results)?

Any help would be greatly appreciated.

TIA,

Vernon