reduce report connections

[iccsi]

I have a report which has many subreports and get too many database
opened error message when users print the report from preview.

I tried to reduce connections and would like to prepare data in to
local tables instead of running queries to retreive data from backend
mdb files.

I would like to know, does report count connections if I query local
tables?
The reprots take one minute to get result, if I use local table to
prepare the report data will improve performance?


Your information is great appreciated,