The report is set private. If I just change it to non private the cursors work perfectly. The select(1) is left over from some debugging. As views these cursors work just fine. Yes the code is in the init method - no tables are opened in the datasession window of the report - just these in the init.

Yes this is a foster care program. I am trying to gen up a report sorted by Terminations then Intakes then In hous moves. LA DCS wants the info just for their agencies.

Sorry if I was too brief. When I give a complete story it seems to extend into a saga of extra info that confuses everone.

Terry
>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