AX1086
(missing or bad snippet)Configuring the report for editing and saving data
(missing or bad snippet)Limitations and requirements
(missing or bad snippet)How the data save works
(missing or bad snippet)Combining multiple save types
(missing or bad snippet)Example
In the following example, the SalaryAdjPct and SalaryAdj columns have been configured as editable. Several calculated columns reference these editable adjustment columns, so the calculations have been configured to update live in response to user edits. Lastly, the save property has been configured to save the edits back to the LaborBud table. If desired, the calculations could also be saved back to the target table.
Example FixedReportColumns data source configured to allow edits and save data
When the form is rendered, the editable column values display in editable cells:
Example Fixed Report component with editable columns
When an edit is made to a value, the background color of the cell changes to yellow, to indicate that the grid contains an unsaved change. In this example, the dollar adjustment for the hourly Executive Assistant position was changed to $0.75. Because the calculated column RosterAdjTotal ("Proposed Base Pay") is configured for live updates, it has updated to show the new base pay using the edited adjustment value.
Example Fixed Report component after making an edit
Once the save button has been used to save changes to the database, the grid updates to display the latest data from the database. The background color of the edited cell reverts back to blue, because now it is showing the queried value from the database.
Example Fixed Report component after saving edits
