Build dbxReport Clearly and Securely

This quick start shows the standard approach to search, sorting, pagination and actions. The full reference covers every output type and callback.

The mandatory procedure

1. Initialize report, set DD, FD and action.
2. Read filter values exclusively via the form pipeline.
3. Check sorting columns against a positive list.
4. Determine the unfiltered total count, the filtered result count and the paginated rows separately.
5. Configure actions, permissions and confirmation text before rendering.

$report = dbx()->get_system_obj('dbxReport');
$report->init('customer-report');
$report->_dd = 'crm|customer';
$report->_fd = 'crm|customer-selection';
$report->_action = '?dbx_modul=crm&dbx_run1=customers';
$report->create_selection_fields($report->_fd);

$report->_count_all = $db->count($report->_dd);
$report->_rcount = $db->count($report->_dd, $where);
$report->_rdata = $db->select($report->_dd, $where, '*', $sort, $direction, '', $limit, $offset);

return $report->run();

Verification and acceptance

Verify empty and large result sets, every allowed sort order, filter reset, page changes, permissions, multiple selection and all destructive actions before acceptance.