Report resizing

[andrew.menendez]

I'm trying to fit more rows of data per page on a report, however
resizing it manually in design view does not seem to help me reach my
goal. The text keeps getting smaller and smaller, and there's more than
enough room to allow for extra rows, yet there's no change.

Is there an alternative way of doing this? I'm comparing my report with
another similar report that seems like it has bigger text, yet can fit
more rows of data on it.

 

[fredg]

I'm trying to fit more rows of data per page on a report, however
resizing it manually in design view does not seem to help me reach my
goal. The text keeps getting smaller and smaller, and there's more than
enough room to allow for extra rows, yet there's no change.

Is there an alternative way of doing this? I'm comparing my report with
another similar report that seems like it has bigger text, yet can fit
more rows of data on it.

Did you set the report section's CanGrow property to Yes?

 

[Marshall Barton]

I'm trying to fit more rows of data per page on a report, however
resizing it manually in design view does not seem to help me reach my
goal. The text keeps getting smaller and smaller, and there's more than
enough room to allow for extra rows, yet there's no change.

Is there an alternative way of doing this? I'm comparing my report with
another similar report that seems like it has bigger text, yet can fit
more rows of data on it.

You also need to make the control'd Height property. If all
the controls are text boxes, then you can set the text boxes
and their section's CanShrink property to Yes.

Also make sure there is little or no space above, below or
between (vertically) the controls. It is important when
moving controls to make sure that they do not overlap top to
bottom so double check their Top and Height properties.

OTOH, you can make all the controls shorter than required to
contain the text and set their CanGrow property instead.