Dynamically changing a section height in Crystal Reports

Question

I use Crystal Reports in Visual Studio 2003, and I want to automatically resize the part section (resize it) if one of the fields is empty. My report is as follows:
'-----------------------------------'
[Product] [Weight] [Quantity]
[Note]
'-----------------------------------

So, if [Note] is empty, I want it to automatically match the details so that it looks like this: '--------------------------- -------- '
[Product] [Weight] [Quantity]
'-----------------------------------'

Because now I get extra free space that I don’t want, and it looks like this:
'-----------------------------------'
[Product] [Weight] [Quantity]

'-----------------------------------

Answer 1

I would create a new subsection; therefore, you have two sections of information. Details-A and Details-B .

Put [Product] [Weight] [Quantity] in Details-A and put [Note] in Details-B below.

Then, in the expert section, select Details-B and click the formula button. Use the formula to suppress a section when [Note] is not populated; sort of:

if isnull([Note]) or [Note]='' then true else false 

This will suppress the section of the note if its space is; thereby keeping the size of your partition.