If you have the table added to the data environment of the report, set the "order" property to the index you created.
If you are just opening the table prior to running the report, set order programmatically:
USE MyTable
SET ORDER TO Xyz
REPORT FORM MyReport ...
>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