list_reports | List .rpt files in a folder |
inspect_report | Page setup, tables / SQL commands / connections, links, parameters, formulas, selection formulas, groups, sorts, sections and every object (position, text, bound field, font), including conditional formulas hidden in formatting (suppress, color, number format…) |
batch_edit | Run several edit operations with one load, one backup and one save; all-or-nothing |
diff_reports | Structural diff between two reports (e.g. backup vs. edited) |
set_formula / delete_formula | Edit, create or delete formula fields |
set_selection_formula | Record or group selection formula |
add_parameter / set_parameter / delete_parameter | Report parameters; set_parameter changes prompt, type, multiple values or defaults in place, keeping every formula that uses it |
add_group / delete_group | Group on a field (per shift, per day, per month…); returns the new Group Header/Footer sections. Subtotals are formulas like Sum({T.Qty}, {T.Shift}) in the group footer |
add_sort / delete_sort | Record sort (ascending/descending); on a grouped field add_sort flips the group's order |
add_running_total / delete_running_total | Running totals (sum, count, distinct count, average, min, max) evaluated per record, on change of a field/group or on a formula, and reset never / per field / per group / on a formula |
set_command_sql | Replace the SQL of an existing SQL Command table (experimental) |
add_table | Add a database table (OLE DB / ADO, e.g. SQL Server or LocalDB) so its columns can be placed on the report; returns the column list |
set_datasource | Repoint tables to another server/database, optionally switching OLE DB provider (persisted) |
remove_table | Remove a table / command (guarded: refuses while its fields are used unless force) |
set_text | Change a text object's text |
set_text_with_fields | Text with embedded fields, e.g. Shift : {T.Shift} or Page {PageNumber} of {TotalPageCount}, in a new or existing text object |
set_object_props | Position/size, font, color, alignment, suppress, can-grow; for lines/boxes also end point, line style/thickness/color and box fill |
add_line / add_box | Horizontal/vertical lines and boxes (fill, rounded corners), optionally spanning into a later section |
add_picture / replace_picture | Insert an image, or swap a picture (e.g. a logo) keeping its name, position and size |
set_field_format | Number/date/time/boolean format of a field: decimals, thousands & decimal symbols, negatives, currency, zero text, date order/separator, 12/24h… or a custom pattern (#,##0.00, yyyy-MM-dd HH:mm) |
set_condition_formula | Set/clear conditional formulas (suppress, font color, display string, border, number format…) |
set_section_props | Section height, suppress, page breaks, keep-together, background |
add_section / delete_section | Add a section (e.g. a second Detail) or delete one (guarded while it holds objects) |
move_object | Move an object to another section, keeping its name, font, format and conditional formulas |
add_subreport / set_subreport_links | Insert another .rpt as a subreport and link it: main parameter → subreport parameter, or main field → subreport field (filters the subreport, e.g. per group) |
set_page_setup | Paper size (A4, Letter, Legal, … or custom), orientation and margins; returns the printable width |
add_text_object / add_field_object / delete_object | Add or remove report objects; field objects can also show special fields (RecordNumber, PageNumber, TotalPageCount, PageNofM, PrintDate, GroupNumber, FileName…) |
verify_database | Check the report against its database: columns that no longer exist (and what uses them), changed types, logon/provider problems. Never saves |
export_report | Run the report and export to PDF/Excel/Word/CSV/… or to PNG/JPG images (one per page, choose dpi and pages) so an agent can look at the layout itself. Image export renders through the PDF renderer built into Windows 10 / Server 2016+; PNG keeps text sharper and smaller than JPG. Rows can be passed inline (data) for DataSet/XML-based reports or quick previews without a database |