From: Scott Cragun on 29 Apr 2010 19:16 I have a report based off a query that has started to fail. I have a copy of my database from 4-27 where it works and another copy from 4-28 where I've added a lot of functionality for something else completely unrelated to the report that fails. In the newer copy it works a few times but after a while it begins to fail. The query the report is based off of always works and generally takes 5-10 seconds to run. When I run the report, it doesn't pop up (even after many minutes) and when you look at the task manager it is using all of the computer's resources. I've let this run for 30 minutes and the report never pops up and the entire time it's consuming all resources. I have to ctrl-alt-del and end the process to get out of it. When I go back in, the query still takes just a few seconds but the report still won't open (and it never displays an actual error message). Any ideas?
From: Allen Browne on 29 Apr 2010 21:14 It's possible the report is corrupt, but a more likely answer is that the report is unable to plot a layout solution. To test this idea, open the report in design view. Open the Properties box, and for each section in the report, set the Keep Together property to No. (On the Format tab of the Properties box, when looking at the properties of a section.) Then open the Sorting And Grouping pane. Select each group header in turn, and set them to: Do not keep group together on one page. If this solves the problem, you have verified that the report is constantly advancing through the records to test if all these records will fit on the page, and then retreating back through them when they don't, and repeating the same thing on the next page and so on, without finding a workable solution. While you are there, what fields are you sorting or grouping on? Are these fields indexed in their respective tables? -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Scott Cragun" <ScottCragun(a)discussions.microsoft.com> wrote in message news:2E97D5EA-6093-43A4-9BAB-F181254E0842(a)microsoft.com... > I have a report based off a query that has started to fail. I have a copy > of > my database from 4-27 where it works and another copy from 4-28 where I've > added a lot of functionality for something else completely unrelated to > the > report that fails. In the newer copy it works a few times but after a > while > it begins to fail. The query the report is based off of always works and > generally takes 5-10 seconds to run. When I run the report, it doesn't > pop > up (even after many minutes) and when you look at the task manager it is > using all of the computer's resources. I've let this run for 30 minutes > and > the report never pops up and the entire time it's consuming all resources. > I > have to ctrl-alt-del and end the process to get out of it. When I go back > in, the query still takes just a few seconds but the report still won't > open > (and it never displays an actual error message). Any ideas?
From: Petr Danes on 4 May 2010 05:07 I had a report go off the deep end that way once, turned out I had a 'Keep together' property turned on erroneously. The SECTION being generated didn't fit on a page, so Access went to the next page, where it didn't fit either, so it went to the next page... Seems like the report engine ought to be smart enough to catch this, but it wasn't (back in 2000, anyway). Check the 'Keep together' properties of ALL your elements and see if one isn't causing this. Pete "Scott Cragun" <ScottCragun(a)discussions.microsoft.com> píše v diskusním příspěvku news:2E97D5EA-6093-43A4-9BAB-F181254E0842(a)microsoft.com... >I have a report based off a query that has started to fail. I have a copy >of > my database from 4-27 where it works and another copy from 4-28 where I've > added a lot of functionality for something else completely unrelated to > the > report that fails. In the newer copy it works a few times but after a > while > it begins to fail. The query the report is based off of always works and > generally takes 5-10 seconds to run. When I run the report, it doesn't > pop > up (even after many minutes) and when you look at the task manager it is > using all of the computer's resources. I've let this run for 30 minutes > and > the report never pops up and the entire time it's consuming all resources. > I > have to ctrl-alt-del and end the process to get out of it. When I go back > in, the query still takes just a few seconds but the report still won't > open > (and it never displays an actual error message). Any ideas?
|
Pages: 1 Prev: Reporting the size of a OLE object on Access Database Next: positioning a subreport |