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
>
> code1
> reqno11 lineno11
> lineno12
> .
> .
> reqno12 lineno21
> lineno22
> .
> .
>
> code2
> reqno21 lineno11
> lineno12
> .
> .
>
>
>What I get is lineno11 for all records in table 2