Discover the world with our lifehacks

How do you use not like in Crystal Report formula?

How do you use not like in Crystal Report formula?

RE: Not Like Operator It should be in Report->Edit Selection Formula->Record if you want to limit rows in the report.

How do I add a record selection formula in Crystal Report?

To access or create record selection formulas, right-click your report and select Report ^ Edit Selection Formula ^ Records. This should open up standard Formula Editor Dialog. Note that the drop-down box that enables you to switch between Crystal and Basic syntax is grayed out this time.

What is selection formula in Crystal Report?

Record selections, or filters, are defined by a record selection formula built using the Crystal syntax of the Crystal Reports formula language. You can build a record selection formula using the Formula Editor by opening the Report menu and choosing Selection Formulas, Record.

How do I change formulas in Crystal Reports?

Click the + sign next to Formulas….To edit on the report:

  1. Right-click the formula field on the report.
  2. Select Edit Formula.
  3. Make the desired changes to the formula.
  4. Click Save & Close.

How do I use order by in Crystal Reports?


  1. In Crystal 8.5, go to Report > Sort Records. Select the field(s) to sort by from Report Fields box and move to Sort Fields box.
  2. In Crystal 11, go to Report > Record Sort Expert. Select the field(s) to sort by from Available Fields box and move to Sort Fields box.

How do you change a field formula?

Edit a calculated field formula

  1. Click the PivotTable.
  2. On the Analyze tab, in the Calculations group, click Fields, Items, & Sets, and then click Calculated Field.
  3. In the Name box, select the calculated field for which you want to change the formula.
  4. In the Formula box, edit the formula.
  5. Click Modify.

How do you assign a value to a formula field in Crystal report?

Text = “” + textBox1. Text + “”; For above first you have to create the formula field in your crystal reports and set the above code then after copy your formula field to your crystal reports. It will shows the specified value of textbox into formula field.

How do I filter records in Crystal Report?

To filter your data, first make sure that none of the fields on your report are selected. Next, go to Report>Select Expert. You can then choose to filter by record, group, or saved data. We want to filter by record since we are using our records within the report to filter the data.

How do you exclude in Crystal Reports?

How to exclude specific values for fields in a custom report

  1. Open Field Explorer in the Crystal Reports application and select Formula Fields.
  2. Click on the New icon on the upper toolbar to create a new formula.
  3. Enter a name for the formula.
  4. The following formula examples can be used:
  5. Click Save & Close.

How do I make a formula field editable?

It is not possible to make formula field as editable. formula field is a read only field. Show activity on this post. While not a formula field, you could also create a workflow rule which populates a field only when that field is empty.

How do you add two formula fields in Crystal Report?

To add the formula field, go to the Field Explorer panel. Click on Formula Fields to select it. Right click on Formula Fields, then select New.

Can I use basic syntax for Record selection formulas in Crystal Reports?

First, all record selection formulas have to be written in Crystal syntax. There is no option to use Basic syntax. This stems from the fact that Crystal Reports will take the record selection formula you create and write a SQL statement to retrieve the report results.

Can I create the record selection formula directly from the database fields?

On the other hand, if you were to create the record selection formula directly from the database fields, this in turn would be written to the SQL statement, and your report will run much more quickly. Was this article helpful? How can convert crystal code into oracle code for record selection?

What type of syntax is available in Crystal?

Historically, Crystal syntax was the first type of syntax available, and most work has been done translating it to SQL. You may see Basic syntax supported in future releases, but that’s up to Crystal Decisions!

What is the best practice for Record selection with a formula?

When working with a record selection formula, you have access to all of the fields, functions, and operators that are available within the formula language itself, including time periods, for instance: {Orders.OrderDate} In MonthToDate Best practice for record selection suggests that you only perform it on fields originating from your database.