[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
Solved

# Crystal Boolean Formula

Posted on 2009-02-19
Medium Priority
985 Views
I am using Crystal Reports XI Release 2 Service Pack 4, and need help with a boolean Formula

I have a field in the database {BAQReportResult.RcvDtl.ReceivedComplete} that returns two Values, False and True, Because some of the parts behind this value return false and some return true.

I need a formula that will look at {BAQReportResult.RcvDtl.ReceivedComplete} and if there is  True and False anywhere in the record it needs to be suppressed, but if there is only True returned it should not be suppressed.

Let me know if you need any clarification :-) thanks.

0
Question by:Collegeguyes
• 8
• 6

LVL 17

Expert Comment

ID: 23685607

So,...BY ROW...this field can only return a SINGLE TRUE or a SINGLE FALSE...correct?

So are you meaning that by GROUPING of another COLUMN....that somehow this field can return a TRUE in one row...and a FALSE in the next or other row?

or

Do you mean that the 3 possible results for this column in a single row can be:

TRUE
FALSE
TRUE FALSE

????
0

Author Comment

ID: 23685893
By Row there can only Return a Single True or a Single False, but the Column Returns

1 True
2 False
3 True
4 True
5True

Because there is one False in the Column it needs to suppress. So the suppress needs to look at all the values and not just the first.
0

LVL 17

Expert Comment

ID: 23685977
OK..so you are GROUPING this field by another field right? What is that other field?

ORDERID, CUSTOMERID....INVOICE# or what???

When you say SUPPRESS...what needs to be suppressed....the FALSE row itself..OR the entire GROUP for this section..????

See you need to GROUP on the field that is GROUPING these True/False items...then use a formula VARIABLE to do what you are seeking to do..

0

Author Comment

ID: 23686064
i have a Plain text Field that i want to suppress based on, {BAQReportResult.RcvDtl.ReceivedComplete} if that field returns any Falses in any Row.
0

LVL 17

Expert Comment

ID: 23686105

But generally,....if you want to suppress a field then RIGHTCLICK the field and go to FORMAT >> COMMON TAB >>> SUPRESS FORMULA...and there enter your formula...something like this...

0

Author Comment

ID: 23686120
Maybe this Pic will help explain what i am failing to  :-D, i need a better formula for what you see in the pic
HelpSuppress.jpg
0

Author Comment

ID: 23686206
See the Data returns two values, but it will return only True and some times only False, so if it EVER, has a False statment in it. then it needs to suppress.

False = Suppress
False and true = Suppress
True = No Suppress
HelpSuppressData.jpg
0

LVL 17

Accepted Solution

MIKE earned 2000 total points
ID: 23686311
Ok....so......again....what is the GROUP...?

I can't see it very well but it appears to be PO LINE or PO "SOMETHING".....?

You can do this in a few ways, but try this:

Create a formula that will return EITHER a "1" if the field is FALSE or a "0" if the field is TRUE. Place this formula in the DETAILS section or wherever this {BAQReportResult.RcvDtl.ReceivedComplete} is located. Ok it will return a 1 or a 0.

Then do a summary on that new formula field....in the GROUP header or Footer....probably footer.

Then create your suppression formula basedon this NEW formulas...something like this:

@NewFormula >0

It should suppresee if at least ONE TRUE is found in the data...

Make sense????
0

LVL 17

Expert Comment

ID: 23686324
Sorry minor corrections for above:

It should suppresee if at least ONE **FALSE**  is found in the data...

: )
0

LVL 17

Expert Comment

ID: 23686354
Sorry typing too fast...I meant suppress formula to be:
GROUP1 SUM @NewFormula > 0
0

LVL 17

Expert Comment

ID: 23686394
New formula fied would be something like this:

//@NewFormulas
if {BAQReportResult.RcvDtl.ReceivedComplete} = false then 1 else 0

0

Author Closing Comment

ID: 31548935
Thank you very much, sorry about the Bad description :-D, Good out side the box thinkin :-D
0

LVL 17

Expert Comment

ID: 23686852
0

Author Comment

ID: 23686900
I created a Summary for the {BAQReportResult.RcvDtl.ReceivedComplete} and set it to minimum. Put the summary in the report foot hidden. If all the minimum value was false i suppressed the text. if the minimum was true it remained.
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater â€¦
Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Coâ€¦
Screencast - Getting to Know the Pipeline
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can eâ€¦
###### Suggested Courses
Course of the Month17 days, 16 hours left to enroll