Patrick
Why don't you do an SQL select of your data and make that the source for the report? Also, evryone advises NOT having anything in the DE of a report - it's asking for trouble.
Tery
>I have encounter a problem when using a relation in the data enviroment for reports. The problem only happens if the child table is already in a relation before I call the report.
>The detail band will not use the related record for the first record only. It did work fine in VFP 7.0 but once I moved to 8.0 the problem surfaced.
>Example below:
>
>details:
>
>1. partno(Parent table) - description(child)
>The first detail will have the correct info from the parent but erroneous data from the child.
>The rest of the details match.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.