Skip to Content
0

Change Detail Section Height

Aug 21, 2017 at 08:03 PM

37

avatar image

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)

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Abhilash Kumar
Aug 21, 2017 at 08:12 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
John Noble Aug 22, 2017 at 10:21 AM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0
Abhilash Kumar
Aug 23, 2017 at 07:24 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Abhilash Kumar
Aug 23, 2017 at 07:28 AM
0

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

-Abhilash

Share
10 |10000 characters needed characters left characters exceeded