Shrinking a subreport

[Waz816]

I have a just started using a subreport. What I'm having trouble with is this: I have a single customer record, I'm linking it to a table that has a possible four service pipe records. I would like my subreport to shrink or expand based on the number of pipe records I bring into the subreport. Thereby shifting the main report that follows the subreport up or down accordingly.

Example:
MMM = Main report rows
SSS = Subreport rows

Report could be -
MMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM
MMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM

SSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS

MMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM
MMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM

OR could be -
MMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM
MMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM

SSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS
SSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS
SSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS
SSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS

MMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM
MMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM

Right now I only have a static sizing on my subreport, so the first exampple would look like this.

MMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM
MMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM

SSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS




MMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM
MMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM

Basically, can I make it expand and contract when necessary?
Thanks.

 

[dgillz]

I am assuming you have sections for Details A and Details B. If not, right click on the details section of the report and click on "insert section below". This creates Details A and Details B. Place the subreport object in details B. At this point, details B can be one line long or 1 million, it makes no difference. Make sure you format details B to supress blank section, this should get rid of the white space. Software Support for Sage Mas90, Macola, Crystal Reports and Goldmine
Cell/VM: 714-348-0964

 

[kenhamady]

Make sure that the subreport object itself (in design) is very shallow (less then one line deep). As long as it has it's "Can Grow" property checked in its formatting attributes, it will grow when needed. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[Ngolem]

As a further comment to Ken's

Make the Subreport as wide as need be on the mainreport and enable the "Can Grow" property of the Subreport field on the main report.

**But**

Create a sub section that ONLY holds the Subreport Field , make it one row high and tighten the borders to the field.

This way the subreport can grow largre if necessary but won't overwrite anything underneath it.

Jim