About Reports

Report Definitions (Definitions > Reports) are Process Definitions that let you run database reports and save their output in the following formats.

• CSV (Comma Separated Values)
• HTML
• XML
• RTX
• JSON

When you create a Report Definition, you can specify what you want it to contain as follows:

• You can specify the query that retrieves the data by choosing a filter, or write your own query in SQL.

• You can specify which columns you want to include.

• You can further narrow the results by providing selections (essentially, sub-queries) on individual columns.

• You can control how the results are sorted.

• You can specify a maximum number of rows to retrieve.

• You can preview the report before you save the Report Definition.

In addition to creating Report Definitions manually, you can create them with RedwoodScript.

Note: To create reports, you must have the Module.Scripting license key.

Note: Reports are limited to 500,000 rows.

Note: For information about report automation, see Generating Reports.