Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Dbf/index changes
Message
 
To
21/12/1999 20:01:23
Jim Crowder
Progressive Group Alliance
Boise, Idaho, United States
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00307040
Message ID:
00307051
Views:
18
Jim,
I'm assuming you assign a line # to each PO_Detail record (even if it is invisible to the user). If so, index the PO_Detail on PO Number + Line # (turning them into character values if appropriate). Then when you relate the two tables use this index.

Also, I personally prefer to collect all my report data into a cursor which can be grouped, ordered, etc. as I wish instead of using a FOR clause when calling a report. Less problems I've found.

HTH
Barbara

>It would appear that anytime a change is
>made to the dbf structure or index a report
>that used the above needs to be completely
>redesigned. Its easy enough to change
>the data environment properties in the report, but it never
>seems to work. OK, I can redesign the report, but help
>me with the following:
>
>Simple Purchase Order application. PO_Header.dbf and PO_Detail.dbf.
>Files are related by the PO Number. The Line items from the
>PO_Detail file all print, but I want them to print in the order they were entered in the child (PO_Detail) and
>am not sure how to make this happen.
>Have tried creating an index for line_item and setting Order to that index in the report, but that does not work.
>
>The report is called like :
>
>REPORT FORM po_header.frx FOR (po_header.fp_po = nFPPO);
> TO FILE V:\TEMP\TEST.FAX ASCII NOCONSOLE
>
>Thanks
Barbara Paltiel, Paltiel Inc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform