Suppress on a conditional formula 1

[mmemon]

Hello,

In the details section of my report, I have the section suppressed(no drill down) on a conditional. When you click on the formula box, I have the name of the formula.
It works fine. However, I have another formula that I would like to add in. So I need to suppress both formulas. But when I add the second formula, the first one gets canceled out.

@Formula1;
@Formula2;
Are you not allowed to have more than 1? I will also look into the code for the 2 formulas. Maybe something else is going on here.

Thanks
Michele

 

[checkai]

You may want to include example formula's...this question is unclear.

You want to conditionally show/supress the details sections based on both formulas, or one or the other?

 

[synapsevampire]

Difficult to understand the doings here.

"In the details section of my report, I have the section suppressed(no drill down) on a conditional. When you click on the formula box, I have the name of the formula. (what formula?)
It works fine. However, I have another formula that I would like to add in. So I need to suppress both formulas. (why do you need to suppress the formulas?) But when I add the second formula, the first one gets canceled out."

A section is suppressed based on what you put into the suppression formula, if there are 2 external formulas from which you base the suppression, and that result in boolean, and both conditions must be met, then use:

@formula1
and
@formula2

If it's to be suppressed if either condition is met, use:

@formula1
or
@formula2

If you supply example data, current formulas, and expected output, someone can more readily help.

-k

 

[mmemon]

Hello,

Sorry I didn't explain it better but I wasn't aware that you can use an AND statement between formulas. This worked.
Thank you

Michele