E
elbyc
I have a report based on a sharepoint list of less than 1000 records,
and about 5 other small tables. The report draws from a number of
queries, some of which are left join (1 to several). There are about
10 sub reports in the report, some with tables, some with charts and
some just pulling from the different queries.
I started having trouble when I added the most recent subreport.
Suddenly the report generates OLE errors (inconsistently) fro some of
the subreports when I run it. Also, it is slow to load even in design
view.
Anyone have any tips for how to streamline the report? Should I use
less queries based on other queries? Avoid cross tab queries?
and about 5 other small tables. The report draws from a number of
queries, some of which are left join (1 to several). There are about
10 sub reports in the report, some with tables, some with charts and
some just pulling from the different queries.
I started having trouble when I added the most recent subreport.
Suddenly the report generates OLE errors (inconsistently) fro some of
the subreports when I run it. Also, it is slow to load even in design
view.
Anyone have any tips for how to streamline the report? Should I use
less queries based on other queries? Avoid cross tab queries?