>Hello all,
>I have a report which has two tables in the dataenvironment. A field from table 2 needs to be filtered so that it contains the same value as a field from table 1, plus an additional criteria. Table 1 is the leading cursor, and table 2 is dependent on the value of its field. Now, I could have linked table 2 to table 1 with a simple relational link, but since table 2 has an additional criteria, a relational field predominates on the behavior of table 2 and the additional criteria is ignored. When I do a plain filter,
>the record in table 2 gets stuck at the value of the first field from table 1
>E.g. Filter : Table2.Fieldx.value= table1.fieldy.value + criteriaz
>What can I do ?
>
>Steve
IMO, report management gets much simpler if you first create one single cursor with all the data you need, and then run the report. Leave the report's data environment empty.
Hilmar.
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)