Expression Editor

Last modified

The Expression editor allows you to create expressions using column/field names, operators and functions e.g. Aged Debtors; currently this is shown as Aged 0 – Aged 5. The expression editor is used to show Aged 0 (current) and 60 days+.
Use of the expression editor is the same for either Grid or Pivot Table.  However, there are a few exceptions detailed below:

Grid Layout

To access the expression editor from within the Grid layout, right click and select Insert Calculated Column.

EE_GridLayout.png

Note:  The values displayed within Fields are proprietary CCH fields, Functions, Operators and Constants are defaults provided by DevExpress.

In the Aged Debtors example stated above, we only want to display Aged 0 and add the remaining Aged balances together.

Click Fields, then select Aged 1, click EE_GridLayoutPlusSign.png, then select Aged 2, click  EE_GridLayoutPlusSign.png etc. Click OK when finished.  Rename the relevant column headings, set the Aged 1 – Aged 5 fields as hidden within the Available Fields list. 

ExpressionEditorwithAging.png

TIP: The most common operators are displayed as icons for quick access.

DataOutput.png

To re-access the expression editor on an inserted column, right click on the column name select Expression Editor.

Pivot Table

To access the expression editor from within the Pivot Table, right click within the data grid and select Add Custom Column.

EE_GridLayout.png

Note:  The values displayed within Fields are proprietary CCH fields, Functions, Operators and Constants are defaults provided by DevExpress

In the Aged Debtors example stated above, we only want to display Aged 0 and add the remaining Aged balances together.

Click Fields, then select Aged 1, clickEE_GridLayoutPlusSign.png then select Aged 2, clickEE_GridLayoutPlusSign.png etc. Click OK when finished.  Rename the relevant column headings, set the Aged 1 – Aged 5 fields as hidden within the Available Fields list. 

ExpressionEditorwithAging.png

TIP: The most common operators are displayed as icons for quick access.

DataOutput.png

To re-access the expression editor from within the Pivot Table, hover over “Data Headers”, double click on additional column name, right click and select Expression Editor.

Concatenation

You are able to concatenate columns using the expression editor. In this example, Client Code and Name have been concatenated.

Within the expression editor, click Functions and select Concat(,) from the list of options.  Click Fields and select Client Code, etc.  Build the string as displayed below.  Click CloseButton.png to close.

Concat([Client Code],' ',[Name] )

For Further information regarding advanced usage of the Expression Editor, use the following link:

http://documentation.devexpress.com/#wpf/CustomDocument7554

 

Page statistics
423 view(s) and 18 edit(s)
Social share
Share this page?

Tags

This page has no custom tags.
(not set)

Comments

Attachments

 

 | Cookie Policy | Copyright | Privacy Policy Terms of Use | Contact Us |