Sub report expands even though Can Grow is no

C

Chuck W

Hi,
I have a main report and some subreports in the main report. I went into
the detail section of all of the sub reports and the main report and set the
Can Grow property to no. However, my subreports still expand to include all
values from the query. I want the subreport to only be a certain height even
if it cuts off values. Can someone help?

Thanks,
 
G

Gina Whipp

Chuck,

To stop subreports from growing you must set the Can Grow property (of the
subreport) to No via the Main report. Or as John Spencer put it... In
other words, the sub report CONTROL on the main report is what has the Can
Grow property.


--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
C

Chuck W

Gina,
Thanks for your help. I am confused as to where this is. On the main
report, I right clicked on the details section and set "Can Grow" to No. On
the details section of the subreports I also set the Can Grow" section to No.
But the subreports continue to expand. I am looking in the wrong place. I
don't see where else the Can Grow option is besides the detail section of the
main report and subreport.

I wrote my query in the subreport to return the top 5 but there are a lot
of ties for the fifth ranked item which causes the subreport to return more
than five records.

Thanks,
Chuck
 
B

BruceM via AccessMonster.com

The subreport control is the "box" on the main form that contains the subform.
Click the very edge of the subreport on the main form in design view so that
it shows an outline, then look at the property sheet by way of View >>
Properties or your preferred method. Set the Can Grow property there.

Chuck said:
Gina,
Thanks for your help. I am confused as to where this is. On the main
report, I right clicked on the details section and set "Can Grow" to No. On
the details section of the subreports I also set the Can Grow" section to No.
But the subreports continue to expand. I am looking in the wrong place. I
don't see where else the Can Grow option is besides the detail section of the
main report and subreport.

I wrote my query in the subreport to return the top 5 but there are a lot
of ties for the fifth ranked item which causes the subreport to return more
than five records.

Thanks,
Chuck
Chuck,
Click to expand...
[quoted text clipped - 22 lines]
Click to expand...
 
C

Chuck W

Thanks Bruce. That did the trick. Chuck

BruceM via AccessMonster.com said:
The subreport control is the "box" on the main form that contains the subform.
Click the very edge of the subreport on the main form in design view so that
it shows an outline, then look at the property sheet by way of View >>
Properties or your preferred method. Set the Can Grow property there.

Chuck said:
Gina,
Thanks for your help. I am confused as to where this is. On the main
report, I right clicked on the details section and set "Can Grow" to No. On
the details section of the subreports I also set the Can Grow" section to No.
But the subreports continue to expand. I am looking in the wrong place. I
don't see where else the Can Grow option is besides the detail section of the
main report and subreport.

I wrote my query in the subreport to return the top 5 but there are a lot
of ties for the fifth ranked item which causes the subreport to return more
than five records.

Thanks,
Chuck
Chuck,
Click to expand...
[quoted text clipped - 22 lines]
Thanks,
Click to expand...
Click to expand...
Click to expand...
 
B

BruceM via AccessMonster.com

I just jumped in at the end, but on behalf of all responders you're welcome,
and glad to hear you got it working.

Chuck said:
Thanks Bruce. That did the trick. Chuck
The subreport control is the "box" on the main form that contains the subform.
Click the very edge of the subreport on the main form in design view so that
Click to expand...
[quoted text clipped - 21 lines]
Click to expand...
 
Top