Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Report shows only 1 line from 2sd table
Message
From
23/09/1999 08:46:58
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00267754
Message ID:
00267928
Views:
20
That was direction I was going in. I wanted to know why it worked in FPW 2.6 and not in VFP 5.

>>>>>>>>>
I find that the most stable way to prepare data for a report is to select everything into one cursor, then run the
report using that cursor. They you can group by to get your print out looking properly.

The side effect of using one report cursor is that the print preview button will work properly.
<<<<<<<<<

>I have the following, simplified, report I am trying to create in VFP 5.
>
>2 tables related by a common field. It is a 1-n relationship. Table 1 has a requisition nunber and table 2 has
multiple 1 to n lines for each requisition number. The report writer only shows the first line in table 2 even if it as
more lines. Table 1 is ordered by its primary key, code, which is not the common field and table 2 is sorted by
common field and line number. How do I get the report to display
>
Previous
Reply
Map
View

Click here to load this message in the networking platform