Oops, I used the data environment to drop fields on my report as a short cut and then deleted the table when I was done. But what I forgot was to remove the table name in the property section of each field. I think this is the second time I made this dumb mistake.. not learning from my mistakes.
But thanks for your suggestions.



>>I'm not following. I thought that when you run a report (no tables in the report designer data environment) after selecting a table/cursor, the report uses that selected table or cursor. I do select the cursor before running the report. In fact when I scan thru the records to save the cursor to a table, the records are correct. Why then is the report losing the records and duplicating the initial record for each record in my cursor?
>>Maybe someone who has experience hacking the report .frx can tell me where to look?
>>Thanks again.
>
>Allen,
>sometimes I have different problems with reports like that.
>I prefer delete table or cursor from data environment and include such code in DataEnvironment.Open Table method:
>
>IF USED("cTempCursor")
> SELECT cTempCursor
> GO TOP
>ENDIF