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

x
?
Solved

Crystal Boolean Formula

Posted on 2009-02-19
14
Medium Priority
?
985 Views
Last Modified: 2012-05-06
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
Comment
Question by:Collegeguyes
  • 8
  • 6
14 Comments
 
LVL 17

Expert Comment

by:MIKE
ID: 23685607
Yes more info please.

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

by:Collegeguyes
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

by:MIKE
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
Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

 

Author Comment

by:Collegeguyes
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

by:MIKE
ID: 23686105
Ok..well... need more info....

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...

{BAQReportResult.RcvDtl.ReceivedComplete}=false




0
 

Author Comment

by:Collegeguyes
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

by:Collegeguyes
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

by:
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

by:MIKE
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

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

Expert Comment

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

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

0
 

Author Closing Comment

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

Expert Comment

by:MIKE
ID: 23686852
Glad I could help out...
0
 

Author Comment

by:Collegeguyes
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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

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

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question