About read-only report database - already underway - as you say very obvious - just thought there might be a quick interim fix. A large number of the reports do have to be bang up to date (about 40%) and due to the nature of the business they do not restict themselves to three table joins with two records - plus the client insists on using CR parameters which seem to have the effect of doing the report query at least one for each dropdown etc ![]()
It looks like somewhere under the hood of CR it should be possible buy version 10 is the nearest I can find where it is possible.
I'll let you know when we find a definitive way around this one.