Change Detail Section Height

[john_noble3]

Hi folks,

My detail section height is 1000. I have 4 fields in the section as follows.

FIeld1

Field2

FIeld3

FIeld4

Each control height is 250.

If FIeld4 is empty, I want to change the height of the details section to 750.

I have added code to the Suppress property of Field4 if no value is present which works fine. I just cant see a property for the details section that will reduce the height to the minimum required. I thought 'Suppress Blank Section' would have sorted this but it made no difference.

Im sure there must be a way of doing this

J

PS I think I posted this question in the wrong group / forum. (posting doesn't seem to be as straight forward as it used to be)

[abhilash_kumar]

I'm sorry, I didn't see Ian's comment that says the same.

-Abhilash

[abhilash_kumar]

Hi John,

Yes, the vertical line forces the section to print even when the other fields are blank.

Go to the Section Expert > Highlight each Details Section > Click the formula button beside Suppress and use this code:

IsNull({field}) OR {field} = '' //if this is a numeric field use IsNull({field}) OR {field} = 0

-Abhilash

[john_noble3]

Hi Abhilash,

I tried as you said but it still shows the white space. But I think I know why...

I have a vertical line that starts in a header section and finishes in a footer section. Could it be that the line going through the detail b section is causing the suppress if blank function not to work ??

J

[Former Member]

If Suppress blank section not working try using a explicit condition

In section expert, click formula icon next to suppress for details4, enter this formula, using your field as appropriate.

isnull(field4)

If this condition is true then section will suppress irrespective of anything in section.

Ian

[abhilash_kumar]

Hi John,

Instead of placing all four fields in the same section, here's what you should do:

1. Insert four separate details sections.

2. Place Field 1 in Details a, Field 2 in Details b and so on.

3. Go to the Section Expert > Highlight each Details section > Check 'Suppress Blank Section'.

-Abhilash