The same mechanism can be used to send INSERT, UPDATE or DELETE statements.
An end user could Crystal's experts and wizards to filter and sort the data.
But instead of showing the data in the usual tabular format, the report consists of a series of INSERT statements - one for each row - incorporating the values to be inserted.
In another Hex Central article (Use SQL commands to solve report problems and speed Crystal Reports), Mike Lewis explains how you can arrange for CR to send a SQL SELECT statement to the database as a way of obtaining the data for the report.
In fact, you're not limited to a SELECT statement when using SQL commands.
Instead of the updating being done within the report, you use CR to generate a script.
The script contains the required INSERT, UPDATE and DELETE statements.The second approach is to use SQL to handle the updating of the database.This method has the advantage of not requiring any external components to be distributed, although it does demand at least a basic knowledge of SQL.Keep in mind that SQL commands are executed as soon as you save them.This means that the update will take place, not just when you run the report, but also every time you edit and save the command.Clearly, any functions you create in this way would be capable of performing any task that's supported by your chosen programming language - and that includes updating a database (subject to the security imposed by the database and the operating system, of course).