Terry,
I'm somewhat confused: Do you have the report itself set to "private Datasession"? Or are you running it from a form with a private DS? If the former, where are you running your SELECT statements? In the INIT? I gather the code works from a test PRG. Does it work if the data is called from inside a form (using the form's Datasession) and then you call the report with NO private datasession set for the report itself?

A couple of other points: You don't need the SELECT SELECT(1) statement, since a cursor always shows up in a new select area. And I have had many problems with the nested JOINs. I know that's the way the View Designer writes them, but they always seem to fail for me.

Finally, from the field names it looks like you're writing an app. for Foster Care placement - I wrote one for my county many years ago (while I was still a foster parent).

Barbara

< snip >

>These generate data just fine untill I run the report in a private data session and then the second cursor is empty. Turn off the private session and all is fine. I don't understand.
>
>Thanks in advance for any help
>
>Terry