Adjusting the detail section of a report

[Guest]

I am making a report that can have anywhere from 1-15 lines in the group
detail section. Is there any way to cut the detail section off if there is
only 1 or 2 lines, so there isn't a lot of white space before the next group?

Thank you

 

[Rick B]

You would build your detail section only big enough to show one record. If
there are three, it will print and take up enough space to show three. If
there is only one, it will only take up enough space to show one.

I'm not sure I follow you. If you make your detail section two inches tall
and only use 1/4 inch for your record, you should see almost 2 inches of
white space between each detail.

 

[Guest]

The problem is that one record will be spread over multiple lines, but not
every record will take up the same number of lines. The detail section is
grouped to hold one record. For example, one record may have data in fields
1-6 that may be set up in the report detail as follows:

Field1 Field2
Field3
Field4 Field 5 Field6

Another record may have data in fields 1-2 only. I don't want two white
lines to print. Is there a way to shrink the detail section to keep any
blank lines from printing.

Thank you for your time.

 

[Duane Hookom]

Have you tried setting the controls to allow Can Shrink?

 

[Rick B]

Also, I would guess you are using a name and address block?

Don't you hate that City, state and ZIP are all spaced funny?


Replace that last line with an unbound text field and put something like the
following in it...


= [Field4] & ", " & [Field5] & " " & [Field6]

** Hopefully you are using more menaingful field names than the example.

 

[Guest]

I had set the Can Shrink property to Yes but what I didn't do is set all the
controls properties to Yes. Setting all the text boxes and the detail
section to Can Shrink did the trick. Thank you for your time.