Formulas to format sections

[abolk]

Is it possible to suppress a section with an if statement.

I want to say if a certain field = 1 then suppress this section.

Thanks

 

[rosemaryl]

Dear Abolk,

Yes, that is very easy.

Right Click on the gray area to the left of the section you want to suppress with the formula.

Click Format Section

Click the Formula Editor (x-2) button next to Suppress No Drill Down

Enter Your formula.

Click the Suppress Blank Section check box.

You're done. Hope this helps.

ro Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[rosemaryl]

Dear Andy,

I know I just replied to you off forum, but wanted to also post the answer to your question here as it might help somone else.

******
Andy wrote and told me that he put in the formula:

If {Table.Field} = 1

and he received an error message that the then is missing.

********

I answered:

Hey Andy,

You do not actually put the if in the code. I assumed the *if* was conversational.

When you put the actual statement in the Suppress you would write

{Table.Field} = 1

the *if* is inferred by the functionality of the Suppress Formula Editor

Hope this is helpful,

ro Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.