Talli,
What does a 'good' report look like? I wish I had seen/used Crystal Reports, but I haven't. Can you point us to some examples of what your users expect?
It seems like copying the data should be required if the Manager type starts joining tables or selecting everything from acs_objects, etc. Isn't this what Greenspun termed 'Data Warehousing'?