>Your question implies your reports are attached directly to your tables. I tend to collect all my report data in a cursor first to ensure I have what I need. I don't know if that approach will help you.
That's precisely what I do, too. Much easier to have variable conditions for the report (select specific data on user criteria, use different sort orders, etc.).
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)