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