Getting started

myDBR turns your database stored procedures into reports. If you can write a SQL SELECT statement, you already have everything you need to build your first report.

How myDBR works

A myDBR report is a stored procedure in your database. The procedure name carries the prefix sp_DBR, which myDBR uses to identify report procedures. Once you attach a procedure to the myDBR report hierarchy, myDBR executes it and renders the result set: as a table, a chart, a cross-tabulation, or other output formats.

Alongside regular SQL queries, you can use myDBR commands: special string values returned by the procedure that myDBR interprets at runtime to control layout, formatting, linking, and more.

What this section covers

This section walks you through the most common report types and features, step by step:

• Creating Your First Report: create a stored procedure, attach it to myDBR, and display tabular data
• Cross-tabulation Report: pivot data into a cross-tab layout
• Creating Your First Chart: visualise data with charts
• Pageview Report: display a single record in a readable form
• User Parameters: add input parameters that users fill in before the report runs
• Report Linking: link reports together and pass parameters between them
• Column Reference: reference columns from earlier in the result set
• Report Layout: control how multiple result sets are arranged on the page
• Editable Reports: let users edit data directly in the report

Start with Creating Your First Report if you are new to myDBR.