Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sorting Detail Items (again)
Message
 
To
04/09/1997 09:48:13
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00048475
Message ID:
00048647
Views:
24
>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
Erik,

The first hing you need is an index that will both support hte relationship and give you the order you want. Let's assume the table is name dChild and its key for the relatioship is a field named ParentId (Character) and you want the recor din order by the EntryDate field (Date), you need an index like this one;

USE Child
INDEX ON ParentId + DTOS(EntryDate) TAG ReportOrder

Now set the order for the table, in the report's DE to ReportOrder and set the realtionship from Parent to Child and set the OneToMany property to .T.
Previous
Reply
Map
View

Click here to load this message in the networking platform