limitation subreport

[iccsi]

I just calculated that my report has 16 subreports on my main report.
Are there any number limitation for subreport?
If there is then what will be the limitation?
I hope that my application deos not over the limitation of Access
2003.

Your information is great appreciated,

 

[Marshall Barton]

I just calculated that my report has 16 subreports on my main report.
Are there any number limitation for subreport?
If there is then what will be the limitation?
I hope that my application deos not over the limitation of Access
2003.

Other that the time it will take to process all the
subreports, the number of controls in a report (or form) is
limited to 754. That includes text boxes, lables,
subreports, lines, etc.

 

[Larry Linson]

I just calculated that my report has 16 sub-
reports on my main report. Are there any
number limitation for subreport? If there is
then what will be the limitation?

There is a limitation on the number of nested subforms or subreports, but
that is high enough for any practical use of nesting. At the same level,
there's no specific limit for subforms or subreports.

I hope that my application deos not over the
limitation of Access 2003.

With that many subreports, depending on the Record Sources used, you might
see some performance hit, but you won't run into a limit due to the
subreports. See Marshall Barton's response for the total control
limitations.

Larry Linson
Microsoft Office Access MVP

 

[Glenn_H]

Hello Marshall,

Is there a way to determine how many controls are contained in a report?

Glenn_H

 

[John Spencer]

IF the report is open then you can use
Reports("ReportName").Controls.Count
to return a count of all the controls on the report. That counts - textboxes,
labels, subReports (but not all the controls on the subreport), lines, etc.
Every object on a report is a control

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County

 

[Glenn_H]

Thank you.

Now that I know the report has approx. 120 controls, I need to find out why
I can't get additional subreports to show in the preview.

 

[Marshall Barton]

Now that I know the report has approx. 120 controls, I need to find out why
I can't get additional subreports to show in the preview.

Maybe they don't have any related data???

You might alos get that effect if some of the subreport
controls overlap or do not have CanGrow set to Yes. Make
sure the section with the subreports also has its CanGrow
set to Yes.

 

[NL]

Hi Larry;

I'm having a similar issue to this one. I have 3 subreports all set with
CanGrow=Yes but when I preview the report the subreports are cut off . I
have about 3/8" space between each subreport on the main report.

Any suggestions?

Thank you!
~Nicole

 

[Marshall Barton]

I have 3 subreports all set with
CanGrow=Yes but when I preview the report the subreports are cut off . I
have about 3/8" space between each subreport on the main report.

Make sure that the section(s) with the subreport controls
has its CanGrow set to Yes as well.