Tech Story

Menu
  • Home
  • Programing
    • Delphi
      • Database
    • Arduino
    • Android
    • Unix Socket
    • Database
  • Network
    • Mikrotik
  • software
    • File Recovery
    • Driver software
    • backup
    • download
    • Drivers
    • format converter
    • programing tools
    • internet
    • phone apps
    • Network
    • graphics
    • professional
    • DISK AND PARTITION
    • OPTIMIZER
    • utility
    • programming tools
  • Digital Coin
    • Bitcoin
    • Blockchain
  • Free Proxy
  • Privacy Policy
  • contact us
  • news
  • Health and Fitness
  • General
  • Computer
  • Games
    • android games
    • computer games
    • ps4
  • Management skills
  • Monuments
  • Series and Movies
  • electrical and electronics
  • YouTube watch
Home
Programing
Database
Crystal Reports – Apply Boolean Formulas
Programing

Crystal Reports – Apply Boolean Formulas

November 28, 2020

There are different Boolean operators that can be used in formula in Crystal Reports. They are −

  • AND
  • OR
  • NOT
  • Eqv
  • Imp
  • XOR

All these operators are used to pass multiple conditions in formulas −

Boolean Operators

AND operator is used when you want both the conditions in the formula to be true. Other Boolean operators and their meaning is as mentioned in the above snapshot.

Using Boolean Operators ‘AND’ −

If {CUSTOMER.CUSTOMER_NAME} [1 to 2] = "AN" and
ToText({CUSTOMER.CUSTOMER ID}) [2] = "4" then
"TRUE"
Else
"FALSE"

Using Boolean Operators ‘AND’ and ‘OR’ −

If ({CUSTOMER.CUSTOMER_NAME} [1 to 2] = "AN" and
ToText({CUSTOMER.CUSTOMER ID}) [1] = "4") or
({CUSTOMER.CUSTOMER_NAME} [1 to 2] = "Ja" and
ToText({CUSTOMER.CUSTOMER ID}) [1] = "2") then
"Five star rating CUSTOMER"
Else
"1 star rating CUSTOMER"
Share
Tweet
Email
Prev Article
Next Article

Related Articles

// Check if a file is on a local drive …

Check if a file is on a local drive in delphi

// Load RTF Text from a resource file into a …

Load Rft Text from a resource file into a TRichEdit in delphi

Recent Posts

  • Udemy – Complete Elasticsearch Masterclass with Logstash and Kibana 2019-8
  • AquaSoft Stages 12.1.06 Multilingual x64 + Portable Free download
  • OfficeSuite Premium 5.10.36738 x86 / x64 + Portable
  • AquaSoft SlideShow Ultimate / Premium 12.1.06 x64 + Portable Free Download
  • Symantec Endpoint Protection 14.3.3385.1000 Win / Clients / 3384 full / macOS Free Download

Categories

  • Advertisement
  • Android
  • android games
  • antivirus
  • Arduino
  • audio video editor
  • backup
  • Bitcoin
  • Blockchain
  • Chinese medicine
  • Computer
  • computer games
  • Database
  • Database
  • Delphi
  • DISK AND PARTITION
  • download
  • Driver software
  • Drivers
  • electrical and electronics
  • Fashion and beauty
  • File Recovery
  • Forex Trading
  • format converter
  • General
  • general
  • graphics
  • Health and Fitness
  • Healthy Eating
  • internet
  • Management skills
  • Mikrotik
  • Monuments
  • Network
  • News
  • Nutrition
  • Operating System
  • OPTIMIZER
  • passwords
  • phone apps
  • phone software
  • professional
  • Programing
  • programing tools
  • programming tools
  • ps4
  • Raspberry Pi
  • Series and Movies
  • software
  • Sport
  • thems
  • Uncategorized
  • Unix Socket
  • utility
  • Videos
  • YouTube watch

Tech Story

Copyright © 2021 Tech Story
Theme by MyThemeShop.com

Ad Blocker Detected

Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker.

Refresh