>>>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.
>
>TO give some background: The report in question is a legal call log for a given member. It is based on 5 tables, all related in the DE. When I call the report, I use:
>
>REPORT FORM legalsheet noconsole to printer for memb.membnum = thisform.holdmemb
>
>The report works fine (prints all the child records) even though the relationship in the DE is not set to one-to-many.
>By building a cursor, do you mean construct a view with all the tables in the DE? Otherwise, I'm not sure I catch your drift....

yes. easiest way to 'sort' child records...