Have the report query the data for only what it needs. Use a View Parameter to make it easy. Then just REQUERY() the view.
>I had my SET VIEW ON operational and saw an old LV_ORDERS view open, which means that the REPORT's DataEnvironment is still holding that view. This is why it won't work. I am going to have to see how to clear out the old DataEnvironment.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer