Chart in a report problem

[DanG]

I have 11 reports base on one query (using A97).
All reports are the exact same, they contain a chart (located in the page header) & a list of salesman below (in the detail).
The charts are of salesman performance and reflect the salesman list in the detail area (name, sales and goal).
Since the reports are using the same query I am using "district" (like a branch office) to filter the individual districts (11 districts...11 reports) for the salesman list in the detail area and the chart is built off of the same query .
Problem:
Everything works great, but sometimes the chart info and the report detail get out of sync. The chart will show all districts in the query and the report detail will be fine and sometimes the filters for the report will just disapear. The chart's row source leads to a "SQL Statement: Query builder" where I can change the district name to the correct district. This way I did not have to make 11 different queries. It just seems unstable and quirkey and I can't figure out why.

Any ideas to get me pointed in the right direction?

Thank you very much.

 

[VanRoekel.Clint]

Chart problems

"unstable and quirkey" are appropriate adjectives for charts and graphs created in Access. The problem is very random in our databases and I can't figure out why, either. Sometimes the data is the same for every graph in a report, but sometimes it is just the first graph on the second page is a duplicate of the 3rd graph on the first page. The problem seems to occur less frequently when we use the Access 2003 database on a Windows 2000 computer rather than an XP computer.

I don't have an answer just a similar problem. In addition, have you ever tried to format the data in a table below a graph? Percentages are impossible to format correctly...it doesn't work if the percentages are formatted in the query, in the Row Source query nor in the table that pops up when designing the graph.

 

[modest]

I have 11 reports base on one query (using A97).
All reports are the exact same, they contain a chart (located in the page header) & a list of salesman below (in the detail).
The charts are of salesman performance and reflect the salesman list in the detail area (name, sales and goal).
Since the reports are using the same query I am using "district" (like a branch office) to filter the individual districts (11 districts...11 reports) for the salesman list in the detail area and the chart is built off of the same query .
Problem:
Everything works great, but sometimes the chart info and the report detail get out of sync. The chart will show all districts in the query and the report detail will be fine and sometimes the filters for the report will just disapear. The chart's row source leads to a "SQL Statement: Query builder" where I can change the district name to the correct district. This way I did not have to make 11 different queries. It just seems unstable and quirkey and I can't figure out why.

Any ideas to get me pointed in the right direction?

Thank you very much.

I am not sure I truely understand what is going on, but I feel like I may know the problem. I am just curious how big the query is. When reports are based on a query, the report is opened sometimes before the query has finished running.

The best technique that I've found to open a report is to it programmatically via VBA:
1) Create a recordset to capture the query results (DAO.Recordset)
2) Put those results in a table (the reports should be based on this table)
2b) Loop through each record in the recordset and past to the table
3) When the loop is done, open the report up in code (Docmd.OpenReport)