Add and Manage Data Elements (Columns) to the Report
The following procedures describe how to add data elements to a user-defined report or template. These become the columns on the report at runtime, and determine what data will be displayed on the report.
To add data elements to the report
- In the Edit Report window, click the Data Elements tab.
- Click Add Elements. The Data Element Picker opens.
- Choose one or more data elements from the list. (Press the Ctrl or Shift keys to select multiple data elements.)
- Click OK.
Add formulas to data elements
If you want to display the results of calculations based on data elements available for the data type you chose, you can create a formula column on the report.
Note: Use caution when creating a formula with data elements. It is possible to create a formula where the denominator is zero, which can cause a data conflict error when the report is run.
To add a formula
- In the Edit Report window, Data Elements tab, click the Add Functions buttons. The Data Element Properties window opens.
- From the Data Element drop-down list, choose Formula. The Data Element Properties window expands.
- Enter a column heading, which is displayed on the report.
You may specify how the column is displayed by specifying the alignment, column width, decimal places, 1000 separator, and negative number format.
- If you select Hide Column, the column will not be displayed on the report.
- Selecting Summary will display the sum of the column values at the end of the column.
- Select the number of Decimal Places and the Currency Format of the data element.
- Click Formula to open the Formula Creator. Create the formula and click OK.
To add a date add column
- In the Edit Report window, Data Elements tab, click the Add Functions button. The Data Element Properties window opens.
- From the Data Element drop-down list, choose Date Add. The Data Element Properties window expands.
- Enter a column heading, which is displayed on the report.
You may specify how the column is displayed by specifying the width (in pixels) and alignment. If you select Hide Column, the column will not be displayed on the report.
- For the Date field, click Select and choose the date data source.
- For the Add field, select the numerical data source. This is the value that will be added to the date element to arrive at the final value to display in the report.
- If you want the time to also display as well as the date, then select the Display Timestamp checkbox.
- Click OK.
To add a date difference column
- In the Edit Report window, Data Elements tab, click the Add Functions button. The Data Element Properties window opens.
- From the Data Element drop-down list, choose Date Difference. The Data Element Properties window expands.
- Enter a column heading, which is displayed on the report.
You may specify how the column is displayed by specifying the width (in pixels) and alignment. If you select Hide Column, the column will not be displayed on the report.
- Specify the earlier date and later date. Choose Today if you want to use the current day as one of the dates, or click Select to open the Data Element Picker. Select a data source from the drop-down list, then select a data element from the resulting list.
- If you want to show results with partial days, then select the Show Partial Days checkbox.
Note: Date Picker data elements (as opposed to Date Only pickers) include timestamps. When calculating the difference between these date and times, it is possible to get a result in partial days. If you select this checkbox, results will display two decimal places; if you do not select this checkbox, results will be in whole numbers.
- Click OK. The calculation is Later Date - Earlier Date, in days.
Last Published Saturday, July 13, 2024