Skip to main content

Command reference

Aggregate Functions​

Appearance​

Calendar​

Charts​

Cross-tabulation​

  • dbr.crosstab - Turns a result set into a cross-tabulation report. The first parameter is the crosstab column; the optional second parameter marks the last data column within the crosstab.
  • dbr.crosstab.col - Predefines the cross-tabulation columns
  • dbr.crosstab.col.style - Sets the column style for the crosstab horizontal summary column
  • dbr.crosstab.col.title - Sets the column title for the crosstab horizontal summary column
  • dbr.crosstab.data.tooltip - Defines a crosstab header tooltip based on the crosstab data value
  • dbr.crosstab.group - Groups crosstab column values by adding another header level
  • dbr.crosstab.header - Adds an additional header group to the crosstab
  • dbr.crosstab.header.col - Predefines the 2nd-level cross-tabulation header columns for dbr.crosstab.header
  • dbr.crosstab.options - Adds a crosstab option
  • dbr.crosstab.order - Sets the order of the cross-tabulation columns
  • dbr.crosstab.title - Overrides the default title for the horizontal summary column
  • dbr.havg - Calculates the horizontal average in a cross-tabulation report
  • dbr.hcount - Calculates the number of values horizontally in a cross-tabulation report
  • dbr.hidecolumn.data - Hides crosstab data columns while keeping the summary column. Used with dbr.calc
  • dbr.hidecolumn.data.all - Hides all crosstab data columns while keeping the summary column
  • dbr.hidecolumn.set.data - Hides crosstab data columns based on the CrossTabSet name
  • dbr.hidecolumn.summary - Hides crosstab summary columns while keeping data columns. Used with dbr.calc
  • dbr.hidedatacolumn - Same as dbr.hidecolumn.data, kept for backwards compatibility
  • dbr.hmax - Calculates the horizontal maximum in a cross-tabulation report
  • dbr.hmin - Calculates the horizontal minimum in a cross-tabulation report
  • dbr.hminus - Calculates horizontal values using the formula Col1 - Col2 - Col3...
  • dbr.hnull - Creates a placeholder for a horizontal column used with dbr.calc
  • dbr.hsum - Calculates the horizontal sum in a cross-tabulation report

File Downloads​

Editable reports​

Export Commands​

Header Levels​

Passing HTML Into the Page​

  • dbr.css - Includes CSS definitions in the report
  • dbr.file - Includes an HTML file in the report
  • dbr.head - Includes tags in the HTML head section
  • dbr.html - Passes HTML directly into the report. Use this for safe HTML (your own HTML)
  • dbr.html.ext - Passes HTML directly into the report. HTML content is filtered for unsafe code. Use this for unsafe HTML
  • dbr.html.ext: - Includes HTML in a string. HTML content is filtered for unsafe code. Use this for unsafe HTML
  • dbr.html: - Includes HTML in a string. Use this for safe HTML (your own HTML)
  • dbr.http.debug - Debugs an HTTP PUT/POST call
  • dbr.http.delete - Makes an HTTP DELETE request and optionally returns the result
  • dbr.http.get - Makes an HTTP GET request and optionally returns the result
  • dbr.http.header - Saves HTTP headers
  • dbr.http.option - Passes options to dbr.http.post
  • dbr.http.post - Makes an HTTP POST request and returns the result
  • dbr.http.put - Makes an HTTP PUT request and returns the result
  • dbr.http.save - Calls a procedure to handle an HTTP POST/GET result
  • dbr.javascript - Includes JavaScript code in the report
  • dbr.purehtml - Same as dbr.html, kept for compatibility
  • dbr.purehtml: - Same as dbr.html:, kept for compatibility
  • dbr.redirect - Performs a server-side 302 redirect to another page. Uses the same syntax as dbr.report
  • dbr.system - Executes a system call

Import Commands​

Linked Reports​

  • dbr.button - Creates a button containing a link
  • dbr.embed_object - Creates a placeholder or popup window for the linked report's content
  • dbr.list - Creates a list containing a link to a report
  • dbr.report - Creates a link to another report
  • dbr.searchable - Creates a search field to get dynamic content
  • dbr.selectlist - Creates a select list for linked reports
  • dbr.url - Creates a link to an external URL

Remote Calls to Other myDBR Servers​

  • dbr.remote.call - Executes the defined remote call and runs a local report to handle the results. Required
  • dbr.remote.options - Allows setting extra options for transfer. The option includes turning off the certificate check on the remote server. Optional and needs to be called before 'dbr.remote.prepare'
  • dbr.remote.prepare - Defines the server to be called, call to be made and local table to receive the results. Required, needs to be called before 'dbr.remote.call'

Running total​

Applying Styles​

  • dbr.avg_prefix - Override the default avg-prefix
  • dbr.cellclass - Applies a CSS class to individual cells based on a value in another column, enabling value-based formatting
  • dbr.cellformat - Applies a per-row printf format to a column using format strings from another column, allowing cells in the same column to be formatted differently across rows
  • dbr.cellstyle - Applies a CSS style to individual cells based on a value in another column, enabling value-based formatting
  • dbr.colclass - Adds a CSS class to a specified report column
  • dbr.colstyle - Sets a report column's style, combining printf formatting and CSS style definitions
  • dbr.count_prefix - Override the default count-prefix
  • dbr.footer.cellclass - Sets the footer's CSS class based on data in another footer column
  • dbr.footer.cellstyle - Sets the footer's CSS style based on data in another footer column
  • dbr.footer.colclass - Sets the CSS class for a footer column
  • dbr.footer.colstyle - Sets the style for a specific footer column
  • dbr.footerstyle - Sets the footer row style
  • dbr.header.colclass - Sets the CSS class for a header column
  • dbr.header.colstyle - Sets the style for an individual header column
  • dbr.headerstyle - Sets the header row style
  • dbr.hidecolumn - Hides individual columns, which can be positioned anywhere in the query
  • dbr.hidecolumns - Hides a specified number of columns from the right end of the result set
  • dbr.hideheader - Hides the column headers in the result set
  • dbr.html5data - Places a column's value into another column's HTML5 data-xxx attribute
  • dbr.html5data.rs - Adds an HTML5 data attribute to the result set table
  • dbr.max_prefix - Override the default max-prefix
  • dbr.min_prefix - Override the default min-prefix
  • dbr.resultclass - Adds a custom CSS class to the result table
  • dbr.rowclass - Applies a CSS class to report rows. A column in the query provides the CSS class name for each row
  • dbr.rowstyle - Applies a CSS style to report rows. A column in the query provides the CSS style for each row
  • dbr.showcolumn - Shows individual columns that were automatically hidden
  • dbr.sum_prefix - Override the default sum-prefix
  • dbr.summary.colstyle - Sets the style for an individual summary column

Templates​

Titles / Text​

  • dbr.subtitle - Gives a name to the result set in a report
  • dbr.text - Inserts a free text element into the report
  • dbr.title - Sets the report title. By default, the report's title is the report's name

Barcode Extension​

D3 Extension​

eChart Extension​

Form Extension​

Google Maps Extension​

iCalendar Extension​

IP2Location Extension​

  • dbr.ip2location - Retrieves location data for a given IP address
  • dbr.ip2location.language - Sets the language for names returned by MaxMind (defaults to 'en'). Refer to MaxMind's documentation for supported language codes

Mail Extension​

OpenStreetMap Extension​

Organization Chart Extension​

Push Notification Extension​

QR Code Extension​

SMS Extension​

  • dbr.sms - Sends SMS messages through the configured provider
© 2007 - 2026 myDBR.com. All Rights Reserved.