SAP Crytal Report

What is Formula Workshop in Crystal Reports?. The Complete SAP Crytal Report Developer Course 2023 [Videos].

Formula workshop is used to create different kinds of formulas. You can open formula workshop by going to Data → click formulas or by clicking formula tab on Data tool bar.

Formula Workshop

In the formula workshop there are 2 panels − Navigation Panel and Objects Panel.

Navigation panel contains a folder for each type of formulas in Crystal Reports.

Navigation Panel

Object Panels contains 4 fields −

Data Explorer − It contains in-use Objects, formulas, parameters and running totals present in the Crystal Report.

Result Objects − It contains all result objects available to use in the report.

Functions − It contains all inbuilt functions that can be used in the report. It also includes custom functions. Example − Sum, Count, String functions, Date functions, etc.

Operators − They are used to pass conditions between values. It includes: arithmetic operators, Arrays, Boolean operators, etc.

Object Panels

Formula workshop also contains formula text window and formula workshop buttons. Text windows is used to create or modify formulas and workshop panel button allows you to use filter formulas, sort formulas, delete, etc.

See All

Comments (356 Comments)

Submit Your Comment

See All Posts

Related Posts

SAP Crytal Report / Blog

What is Crystal Reports ?

SAP Crystal Reports is a Business Intelligence tool which is used to generate reports from both SAP and non-SAP data sources. It enables end users to generate reports that includes exceptional visualizations and implement new business requirements into reports to reduce dependency on IT and Report developers.
7-Feb-2022 /17 /356

SAP Crytal Report / Blog

What is GUI Navigation in Crystal Reports?

Crystal Reports for enterprise provides an interface that enables you to quickly and easily create, format, and publish effective reports. The menu bar provides full range of features available in Crystal Reports for Enterprise as shown in the following image.
7-Feb-2022 /17 /356

SAP Crytal Report / Blog

What is Options in Crystal Reports?

Report Options is one of the most commonly used feature in Crystal Report Designer, when you need to access/modify the values of Report Options of a Crystal report at runtime in a Crystal Reports .NET application.
7-Feb-2022 /17 /356