Report has 126 pages and take forever to run
in [Reports]
|
Prev: Query results not showing nulls
Next: missing data
From: gmazza via AccessMonster.com on 2 Nov 2009 10:53 Hey there, I'm minorly new to reports and simple ones are working fine but I have this complex one that has 399 text boxes on it and in the On Open event I open up 2 different recordsets to see which textboxes get displayed, along with their relevant data, and which disappear. All the logic works except 2 problems: 1. My report has 126 pages 2. It takes a good minute to run, which is way too long. For the 126 pages, my data in the On Open event is only showing 100 textboxes, and since they are layed out 8 per line, it doesn' take up much room, maybe 3/4 of a normal page. Every odd page is the exact same as the 1st page which is all I want, the first page. Every even page just has the page headers. Can anyone explain? Why it takes so long to run is beyond me too. Is it my code? My database is compacted and really small and I don't have much data. Any suggestions? Thanks for all your help in advance! -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200911/1
From: Gina Whipp on 2 Nov 2009 11:49 gmazza, Does the RecordSource of the report open quickly? If yes, do you have page numbers on your report? If Yes, then remove the Page numbering and see what happens. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "gmazza via AccessMonster.com" <u37142(a)uwe> wrote in message news:9e84ed202d532(a)uwe... > Hey there, > I'm minorly new to reports and simple ones are working fine but I have > this > complex one that has 399 text boxes on it and in the On Open event I open > up > 2 different recordsets to see which textboxes get displayed, along with > their > relevant data, and which disappear. > All the logic works except 2 problems: > 1. My report has 126 pages > 2. It takes a good minute to run, which is way too long. > > For the 126 pages, my data in the On Open event is only showing 100 > textboxes, > and since they are layed out 8 per line, it doesn' take up much room, > maybe > 3/4 of a normal page. Every odd page is the exact same as the 1st page > which > is all I want, the first page. Every even page just has the page headers. > Can > anyone explain? > > Why it takes so long to run is beyond me too. Is it my code? My database > is > compacted and really small and I don't have much data. Any suggestions? > Thanks for all your help in advance! > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200911/1 >
From: gmazza via AccessMonster.com on 2 Nov 2009 12:03 Thanks for the reply Gina. My name is Gino :) The record source of my report is based on a table, not a query so its tough to say. If I open the table it opens no problem. In the page footer I have a text box with this as a control source: ="Page " & [Page] & " of " & [Pages] I deleted it but it was still 126 pages and took long to open. Gina Whipp wrote: >gmazza, > >Does the RecordSource of the report open quickly? If yes, do you have page >numbers on your report? If Yes, then remove the Page numbering and see what >happens. > >> Hey there, >> I'm minorly new to reports and simple ones are working fine but I have >[quoted text clipped - 22 lines] >> compacted and really small and I don't have much data. Any suggestions? >> Thanks for all your help in advance! -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200911/1
From: Marshall Barton on 2 Nov 2009 12:18 gmazza via AccessMonster.com wrote: >I'm minorly new to reports and simple ones are working fine but I have this >complex one that has 399 text boxes on it and in the On Open event I open up >2 different recordsets to see which textboxes get displayed, along with their >relevant data, and which disappear. >All the logic works except 2 problems: >1. My report has 126 pages >2. It takes a good minute to run, which is way too long. > >For the 126 pages, my data in the On Open event is only showing 100 textboxes, >and since they are layed out 8 per line, it doesn' take up much room, maybe >3/4 of a normal page. Every odd page is the exact same as the 1st page which >is all I want, the first page. Every even page just has the page headers. Can >anyone explain? > >Why it takes so long to run is beyond me too. Is it my code? My database is >compacted and really small and I don't have much data. Any suggestions? When you get the same information on every page, it's usually because the recport's record source query is returning too many records. To figure out what's going on, you should work with the query by itself, the report is probably just getting in the way of analyzing the problem. The query being overly complex might(?) also be the reason for the long time to see the report. Again, test the query by itself. If the query runs a lot faster than the report, then it might be the reports grouping or ?? As for the even pages only having the page header, that is often caused by having the ForceNewPage property set inappropriately. Another thing to check that can cause this is when the report's width exceeds the space between the margins. -- Marsh MVP [MS Access]
From: Gina Whipp on 2 Nov 2009 12:31
Gino :o Well then I am going to have to say that is must be the Report set-up. You say 100 fields per page and the Report Header every other page, why? It could be this paging that is causing the slowness. Are they the same 100 fields or does the data *rotate* depending on which page? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "gmazza via AccessMonster.com" <u37142(a)uwe> wrote in message news:9e8589246e4de(a)uwe... > Thanks for the reply Gina. My name is Gino :) > The record source of my report is based on a table, not a query so its > tough > to say. If I open the table it opens no problem. > In the page footer I have a text box with this as a control source: > ="Page " & [Page] & " of " & [Pages] > > I deleted it but it was still 126 pages and took long to open. > > Gina Whipp wrote: >>gmazza, >> >>Does the RecordSource of the report open quickly? If yes, do you have >>page >>numbers on your report? If Yes, then remove the Page numbering and see >>what >>happens. >> >>> Hey there, >>> I'm minorly new to reports and simple ones are working fine but I have >>[quoted text clipped - 22 lines] >>> compacted and really small and I don't have much data. Any suggestions? >>> Thanks for all your help in advance! > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200911/1 > |