Not suppressing tab - Formula Help

[JBourne77]

I am not getting an error message on my formula, however the detail section I placed this on is not suppressing the details tab. I added this to my details A tab under the x-2 tab on the suppress tab. I'm not sure if I need to re-write this differently or whats broken.

{?SHOWDETAIL} = False 
AND
IF {Data.Type} <> 1 THEN
    TRUE
ELSE IF {Data.Diagnosis} = -1 AND ISNULL({@TicketNumber}) THEN
    FALSE
ELSE IF {Data.Diagnosis} = -1 AND {@TicketNumber} = "" THEN
    FALSE
ELSE IF {Data.Diagnosis} = -1 AND {@TicketNumber} = {Data.TicketNumber} THEN
    TRUE
ELSE
    FALSE

 

[IanWaterman]

If you create a formula using

IF {Data.Type} <> 1 THEN
TRUE
ELSE IF {Data.Diagnosis} = -1 AND ISNULL({@TicketNumber}) THEN
FALSE
ELSE IF {Data.Diagnosis} = -1 AND {@TicketNumber} = "" THEN
FALSE
ELSE IF {Data.Diagnosis} = -1 AND {@TicketNumber} = {Data.TicketNumber} THEN
TRUE
ELSE
FALSE

and place this in details is it returning the correct value?

Ian

 

[JBourne77]

IanWaterman -

Yes, that works fine. I tried adding in the "{?SHOWDETAIL} = False AND" part to an all ready working formula and it seems to not like that.

 

[GJParker]

False + True = False

try changing your formula to

IF Not {?SHOWDETAIL} Then
IF {Data.Type} <> 1 THEN
    TRUE
ELSE IF {Data.Diagnosis} = -1 AND ISNULL({@TicketNumber}) THEN
    FALSE
ELSE IF {Data.Diagnosis} = -1 AND {@TicketNumber} = "" THEN
    FALSE
ELSE IF {Data.Diagnosis} = -1 AND {@TicketNumber} = {Data.TicketNumber} THEN
    TRUE
ELSE
    FALSE

Gary Parker
MIS Data Analyst
Manchester, England

 

[JBourne77]

GJParker -

This seems to not make a difference either in my testing.

 

[GJParker]

Please explain the logic you require to suppress your details section.

Gary Parker
MIS Data Analyst
Manchester, England

 

[JBourne77]

The Logic is, the End User has a check box on the third party application that indicates "Show Detail ?". If they check it, they get back this detail tab. If they uncheck it, they dont see the results.

As I mentioned earlier, I tried adding in the "{?SHOWDETAIL} = False AND" to the previous formula on there and it seems to not like what I did. Not sure how I can combine them both.

 

[IanWaterman]

If this is the condition
{?SHOWDETAIL} = False

The surely this must override your other conditions, because detail will be suppressed full stop.

Thus Gary's suggestion should work, ie you only want the other suppression to kick in when user wants details.

Ian

 

[lbass]

Try:

{?SHOWDETAIL} = False or
{Data.Type} <> 1 or
(
{Data.Diagnosis} = -1 and
not isnull({@TicketNumber}) and
trim({@TicketNumber}) <> "" and
{@TicketNumber} = {Data.TicketNumber}
)

-LB