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  

Multi-column subreport repeats forever



 
 
Thread Tools Display Modes
  #1  
Old July 18th, 2007, 01:30 PM posted to microsoft.public.access.reports
jtertin
external usenet poster
 
Posts: 31
Default Multi-column subreport repeats forever

I have a multi-column subreport embedded into an access report which
works fine, but loops without end.

The form should put all of the data from a query in columns and stop,
which it does if you open the report that IS the subform. The last
column of data represents the last row in the query. However, when I
use that report as a SUBreport, it starts over again after the last
column is printed and loops forever. Any reason that this might be?

I had the problem at first of having every page display the SAME
[first] 10 columns of data (because my subreport is set to display 10
columns). Setting the subreport's "Can Grow" property to Yes solved
this issue, but I have heard of a bug related to that property being
set in subforms also. Could this be the problem, or do I need to use
master/child linked fields somehow to keep the columns from repeating?

Thanks!

  #2  
Old July 20th, 2007, 03:00 PM posted to microsoft.public.access.reports
jtertin[_2_]
external usenet poster
 
Posts: 5
Default Multi-column subreport repeats forever

I am so close to getting this fixed. The only problem I have now is the
subform repeating once it finishes creating columns for all of the data in
its query - it RESTARTS at the beginning, causing my report to be of infinite
length. Any suggestions?
 




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 02:17 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.