Sub report expands even though Can Grow is no

  • Thread starter Thread starter Chuck W
  • Start date Start date
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,
 
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
 
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
 
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...
 
Back
Top