---
title: "Data Shaping Operations"
slug: "data-shaping-operations"
updated: 2023-08-09T09:21:00Z
published: 2023-08-09T09:21:00Z
canonical: "docs.avontus.com/data-shaping-operations"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.avontus.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Data Shaping Operations

In addition, the Field List can help you add calculated fields to data columns for performing various calculations in a report. Calculated fields allow you to pre-process a report's input data, based on a certain expression. So, using calculated fields allows you to apply complex expressions to one or more data fields that are obtained from your report's underlying data source.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/be948238-86a9-41d9-ae68-96318ca2bd56.png)

Select **Add Calculated Field** and this will create the calculated field.

Right-click the calculated field in the **Field List** and select **Edit Expression.**

**![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/5b11a3a1-3875-4527-8b07-ccafa700e64b.png)**

In the invoked **Expression Editor**, construct the required expression. You can use data fields, report parameters, predefined constants as well as various date-time, logical, math and string functions.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/3fe73f1f-fb6b-4eaf-b211-9ae9ff1f8807.png)

The report's **Calculated Fields** property provides access to the calculated field collection.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/5aa5be0d-25fa-49c0-aea1-b42e59570652.png)

You can click the **Add Calculated Field** button in the Toolbar's **Home** tab to invoke the **Calculated Field Collection Editor**.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/671e4162-6387-4c13-ba5e-6b474c1f787e.png)

You can drag the calculated field from the **Field List** onto the required band like an ordinary data field.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/35a40580-bde4-436f-a571-ae4926d100bd.png)

#### Property Grid Tabs

The **Property Grid** allows you to access and customize report/report element settings such as the text font and size.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/b40d971c-8fcc-4f48-927b-cb437a2a80c9.png)

## Categorized and Alphabetical Modes

You can switch between categorized and alphabetical modes.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/5a6d9a86-1f25-4942-a904-16fe15f82a37.png)

In the categorized mode, properties are listed in a tree-like form and the properties are displayed in alphabetical order.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/8640163a-ead3-4025-a933-4339d1010d4d.png)

In the alphabetical mode, all properties are displayed in a single list and are sorted alphabetically by name.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/4081435e-dacc-425b-95ba-986d9b9e98de.png)

### Favorite Properties

The **Favorites** tab displays favorite or most frequently used properties.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/7cf87e80-3428-4c5e-9231-9547cd5cafd0.png)

Click the **Edit Favorite Property List** context menu item to set up the favorite properties. Enable check boxes for the controls' properties in the invoked **Favorite Properties Editor** to include these properties in the favorite list.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/dda8a2d6-5d6f-4bb2-acfa-214a48e18321.png)

Click in the checkbox for each of your chosen favourite properties and then click **OK**.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/4e4a44a6-17a4-4295-987e-2b7a3f1f4d63.png)

### Search Properties

The Property Grid's search box allows you to search for a property. When you type within the search box, the Property Grid automatically creates a search criteria based on the entered text and filters the list of available properties.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/935618d3-7ae6-4707-beca-a97ebd7a196b.png)