At this point I am trying to just run the report on its own. I had it working on Northern Cal's data just fine. I tried it on Sothern's data and it failed. I discovered it I undid the private data session it ran (for a while, about 4 times). I must clarify though. In the process of tracking down the problem I am now at the stage you see. These cursors were originally views. The first was called as part of the source for the second. I have been working my way through the process of eliminating things to track the problem down. I would like to use the private data session (partly for education) to elimiate interfearance with existing open tables in the default session. For example the misc_tables table is open in the main screen for utility purposes. With out the private datasession the sql didn't make the connection to it unless I included it (sharable) in the datasession screen of the report.

I keyed on your statement about complicated sql views/cursors. I may try breaking up the statements creating more intermediate temp tables/cursors to see if this will correct the problem.

Terry
>Terry,
>Interesting to find someone writing the same reports I did in Clipper in the 80's - for San Mateo County.
>
>You have checked the two cursors with 'browse'? I've found that sometimes the error is in the report setup not the actual data.
>
>Is the report called from a form method? From a PRG? I guess I'm trying to find if you can run the data from outside the report and then call the report without the private DS. I've found this to be an easier way of handling report data, since you can change the layout without worrying about the data code getting changed by mistake.
>
>Barbara
>
>>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