Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Vertical Space on multi-column report

Status
Not open for further replies.

pduncan

IS-IT--Management
Jun 20, 2003
203
US
I have read through the FAQ’s and every thread I could find about reports – (I learned a lot, but didn’t find a answer to this problem)

I have a report that consists of multiple columns. Because of the way the data repeats (and due to the users needs) I have the report divided into sections using headers.

Here is an example:

-------------------------------------------------------------------
(Report Header)
REPORT TITLE
-------------------------------------------------------------------
(Page Header)
HEADINGS FOR COLUMNS GO HERE
-------------------------------------------------------------------
(Data A Header)
[data A]
-------------------------------------------------------------------
(Data B Header)
[data B] [data C] [data D] [data E]
-------------------------------------------------------------------
(Detail)
[data F]
-------------------------------------------------------------------
(Page Footer)
(date) (page x of y)
-------------------------------------------------------------------

My problem with this report is that the text in [data E] and [data F] varies from just a few words to a couple of paragraphs. The others (A – D) are all just a few words.
In the report, I had to make the area for [data E] and [data F] as tall as the longest text value. Otherwise it would cut the text off – even though I set the can grow and can shrink values to “yes.” The result is that I frequently have large gaps of vertical space between data on the levels in question (Data B Header and Detail sections.)
I have set these fields to can shrink = yes, but that doesn’t do it.

Any help would be greatly appreciated!


PDUNCAN - MEMPHIS, TN

“Friends help you hide. Real friends help you hide bodies.”
 
The controls should always grow if you have their properties set to grow. Did you also set the sections to Can Grow - Yes?
 
yes - I set both can grow and can shrink to yes.
Are you saying that I can make the boxes (E and F) smaller? and the text won't cut off? if so, I'll try that again.
thanks

PDUNCAN - MEMPHIS, TN

“Friends help you hide. Real friends help you hide bodies.”
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top