Then I add these formulas to a text box on the report. I format the text box to suppress if mailto:%7b@fmt1 - {@fmt1 } = "Text:  - " then true else false

 

The box is suppressed, but I want the report to "fit" the section as well.

Here's the layout:

fmt1    fmt2

fmt3    fmt4

fmt5    fmt6

fmt7    fmt8

 

If fmt3 - fmt8 are "empty" by the suppress formula, then fit the section to the bottom of fmt1/fmt2

 

Is that possible?

 

Then, change your formulas - fmt1 and fmt2 stay the same, but the rest of the odd numbered ones will look like this:

 

if (not IsNull({Command.Code}) then

chr(13) + chr(10) + Text: " + {Command.CODE} + " - " + {Command.DESC}

else ''

 

And the even numbered ones will look like this:

 

if (not IsNull({Command.Code} then

chr(9) + Text: " + {Command.CODE} + " - " + {Command.DESC}

else ''

 

chr(9) = Tab character

chr(10) = Line Feed

chr(13) = Carriage Return

 

Take the manual returns out of the text box and let the formulas handle it.  So, what's in the text box might look like this:

 

{@fmt1}      {@fmt2}{@fmt3}{@fmt4}{@fmt5}...

     

If you have any data in the same section as the text box but which is displayed below the text box, create a new section under this section and move the fields to the new section.  The section that your text box is in will grow based on the size of the field and the other data will automatically appear below it no matter what the size is.

 

-Dell