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
Creating & Modifying Formulas
Database

Creating & Modifying Formulas

November 28, 2020

You can create single or multiple formulas in one go and use them in your report. You can also delete the formulas, or search and change text of formulas in the formula text window.

To create a new formula, you can right click on Formula tab under Data Explorer. Once you click on the new formula → enter the formula name → it opens the formula workshop.

New Formula

You can also create a new formula by opening the Formula workshop from the Formula tab under Data → New → New Formula as shown in the following image.

Formula Tab

To write a formula in the formula text window, you can use in-use objects under the Operator tab and different operators to pass condition in the formula.

Operator Tab

formula can be saved using the save option at the bottom of the page. Once the formula is saved it comes under the list of formulas in Data Explorer tab.

Data Explorer Tab

You can drag this formula to any section of the report.

Section

In the above snapshot, Test formula has been dragged to Report footer and it has calculated value as Quantity sold/2 in the Report footer.

Now to modify the formula,click on formula name under Data explorer, it will open the Formula workshop. Make changes to formula and use the save button at the bottom to save the changes. These changes will be automatically applied to the Report values.

To delete the formula from a report, right click on the formula name and click on Delete.

Delete Formula

Problem pane at bottom is used for debugging purpose. It shows you the syntax error in the formula. The error message in the following image says that the field in red underline is not known as field syntax and is incorrect.

Problem Error

Share
Tweet
Email
Prev Article
Next Article

Related Articles

Using the Mouse library, you can control a computer's onscreen …

Arduino – Mouse Button Control

Google Charts is a pure JavaScript primarily based charting library meant …

Google Charts Tutorial

Teclast M40 10.1'' Tablet 1920x1200 4G

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