A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Subreport repeats infinitely



 
 
Thread Tools Display Modes
  #1  
Old July 30th, 2007, 01:55 PM posted to microsoft.public.access.reports
jtertin
external usenet poster
 
Posts: 31
Default Subreport repeats infinitely

I have a form with a continuous subreport on it which is based on a
query that returns 24 hours worth of log data. The query that the
report is based on is running correctly - from midnight to midnight at
even intervals. This data is even reported correctly in my report's
column structure. However, once the data is written into columns in
my report, it starts over at the beginning and re-generates all of the
columns causing my report (which should be ~130 pages of columns) to
be seemingly infinitely long. Any ideas what would cause this type of
behavior?

Some add'l info:

  #2  
Old July 30th, 2007, 01:58 PM posted to microsoft.public.access.reports
jtertin
external usenet poster
 
Posts: 31
Default Subreport repeats infinitely

1. The subreport DOES have "Can Grow" set to ON. This is necessary
for the data to be continuous from page to page.
2. The subreport is located in the Detail section of my main report.
3. Opening the subreport independently generates as it should - all of
the data without repeating.

Please let me know if you need more info!!!

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:49 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.