I don't know "why", but may a suggest a different method of producing reports.
I also used to prepare all the data with SET FILTER, SET RELATION, etc., but now I don't. I find it much simpler, and more convenient, to prepare all the data with one or several SELECT commands.
Just select the data from one table, use a SELECT - SQL command to add records for a second table, add another SELECT - SQL command command to add the third table, etc. Do any sorting at the end. (If you try to do a single big SELECT for all the tables, it may be much slower.)
>Hi All,
>
>I generate a report based on the following tables:
>
>1. Somain.dbf ( Master File contains sono c(8), pcode c(8), date d, ...........)
>2. Sosub.dbf ( Transaction file : sono c(8), icode c(8), qntymaj N(13,2), qntymin N(13,2), ratemaj N(13,20), ratemin N(13,20))
>3. Pcode.dbf ( Customer File : pcode c(8), full_name c(63), address c(72) .....)
>4. Icode.dbf ( Product Master File: icode c(8), full_desc c(72), ........)
>
>I set the relation like: (Please note that I set the following relations in data environment).
>
>sele 4
>use icode orde icode alia item
>sele 3
>use pcode orde pcode alia party
>sele 2
>use sosub orde sono alia sosub
>set rela to icode into item
>sele 1
>use somain orde sono alia somain
>set rela to sono into sosub
>set rela to pcode into party addi
>
>Initially the report runs very fine, but after using a couple of times, it shows only one record of the transaction file (sosub.dbf).
>
>Why it is happening? Please guide..
>
>Thanks/Regards -Saifuddin
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)