Sub report expands even though Can Grow is no

[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,

 

[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

 

[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

 

[Chuck W]

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
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.

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,

[quoted text clipped - 22 lines]

Thanks,