slow report - many charts

[jdesormeau]

I have a report that creates 8 different charts based on the same query. The record source for each chart is the query with some specific filtering. The report is quite slow. I believe that the underlying query is being run 8 times - one for each chart. How can make the query run only once.

Jennifer

 

[dhookom]

You might consider creating a temporary table based on your query. You then run the query once to add records to the table and then use the table as the main Row Source for your charts.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[jdesormeau]

Thanks. That sounds like it should work. I will let you know when I get a chance to try it.

Jennifer

 

[jdesormeau]

This works great. I think that I can use this in other areas of the database but have a couple of questions/concerns. At what point to I delete the temporary table? Also, this is a shared multiuser database, does each user create their own temp table or is there just one? If there is just one then there may be problems.

I appreciate your help. Jennifer

 

[dhookom]

I have a couple apps that include tables that contain the information to create and external, local mdb and with various tables. I had used the documenter to "reverse engineer" the required tables from an existing mdb.

I added code to a startup routine to create the mdb with tables & indexes and then link the tables. It only took a few seconds to accomplish this and kept my mdb files from bloating.

I would never have users share a single front-end mdb. Each user should have their own copy.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[jdesormeau]

Thanks dhookom
This raises some interesting points that I need to discuss with our network administrator. I may have more questions but not for this forum. Again thanks for your help.

Jennifer