>>Hi Don,
>>
>>> did you mean set it to crsTemp?
>>
>>No, usually it should be sufficient to switch to the report cursor and run the report. Unless of course, some code or properties in the data environment change this.
>
>crsTemp IS the report cursor.
>How do I set to property since it is readonly in the designer?

Don,

I'm sorry, but did you add NOFILTER to your select command? I bet it's creating a filtered view and thus you're getting the problem.