Edit a Data Expression
From Alchemex
Home > Connector > Data Expressions > Edit a Data Expression
Edit a Data Expression
To edit a Data
Expression, select the Data Expression which you want to edit and
on the Toolbar click the properties 
button. The
properties window will be displayed.
Amend your Data Expression properties and click OK to save your changes.
| Property | Description |
|---|---|
| Expression ID | This is a technical key identifier for the expression |
| Expression Name | The Name/Alias for the Expression |
| Expression Source | The Source Data Field Name |
| Expression Type | This indicates the type of expression that is being used. By default it is set to Data Field and in this case will be referring to a single column in an underlying Data Table. It can also be set to SQL Expression to allow a raw SQL expression to be used (including the use of the ODBC drivers available Functions), or to Excel Formula. In the last case Excel formulae can be specified in the Expression source. No equal sign should be used to prefix the formulae. When Excel formulae are used here then to reference other Data Expressions in the formula use their Expression Names. E.G. CONCATENATE(Category," - ",ProductName). If the Expression names have spaces or other non Alpha-numeric characters in them then simply replace these characters with underscores in your Excel Formula. |
| Allow Viewing | Make this Expression available for using in a Report Column |
| Allow Filtering | Allow users to filter on this Expression |
| Allow Sorting | Allow users to perform sorting using this Expression |
| Allow Lookups | Make Parameter Lookup Lists available for this Expression |
| Lookup Type | Make Parameter Lookup Lists available for this Expression |
| Data Type | The underlying data type for the Expression. If you change an Expression to be of Expression Type SQL Expression then you should pick the correct Data type that the Expression is expected to return. |