>I am still having trouble sorting the detail items on a one-to-many report. The only suggestion given a few weeks ago when I posted the question was to set the order of the cursor in the dataenvironment, which I have done. It doesn't do a darn thing. Has anybody actually tried this and it works? If not, how do I do this? As seems to be par for the course in learning VFP features and quirks, the documentation is of no help. I must find a way to do this, please help. Thanks
>
>Erik
i'd recommend building a cursor with the parent and child records in it. then tell the parent records not to print repeated values and/or put them in a group header on the report.
when you do what was suggested in the dataenvironment, you'd have to tell vfp that the relationship is 1 - many (set skip). otherwise, only the first child would ever be shown.