>Richard,
>
>Don't base the reports on raw tables, use cursors instead.
>
>>Does anyone know of a way to give users a preview of a report for a limited time? They've got tables open that we may need to reindex, etc., and they very often go home with the report previews up on screen. Ideally, we would shut them down after 10 minutes or so. Anyone have any ideas?

Good point. While we're unfortunately dealing with very large tables, I think you're probably right--it's better overall not to run the risk of locking the tables at all.

Thanks, David.