Optional Installations

Chart Support with ChartDirector

myDBR Premium includes a license for the ChartDirector charting module. This module provides advanced charting capabilities directly within your reports.

To enable this feature, download the ChartDirector for PHP package and follow the installation instructions provided in the package or available online.

PDF Export Support with wkhtmltopdf

myDBR supports wkhtmltopdf for generating high-quality, pixel-perfect PDF reports. wkhtmltopdf uses the WebKit rendering engine to ensure that your reports look exactly like they do in the browser.

Installation and Configuration

1. Install wkhtmltopdf on your server following the instructions on the official website.
2. Ensure the executable is in your system's PATH. If it cannot be added to the global path, specify the full path in user/defaults.php:

$mydbr_defaults['export']['wkhtmltopdf']['command'] = '"C:\Program Files\wkhtmltopdf\bin\wkhtmltopdf.exe"';

3. Verify the installation in Environment settings under the Installed modules tab.

Version Check and Temporary Files

myDBR verifies the wkhtmltopdf version upon user login. To bypass this check, you can manually define the version in user/defaults.php:

$mydbr_defaults['export']['wkhtmltopdf']['skip_version_check'] = [
  'wkhtmltopdf_exists' => true,
  'wkhtmltopdf_version' => '0.12.5'
];

To generate PDFs, myDBR saves temporary HTML files to the system's tmp directory. You can customize this location using the following setting:

$mydbr_defaults['export']['wkhtmltopdf']['tmp_directory'] = '/your/custom/tmp/path';

Troubleshooting PDF Exports

If you encounter issues with PDF generation:

• Verify accessibility via the troubleshooting tool: https://[yourserver.com]/mydbr/tools/troubleshoot/wkhtmltopdf.php.
• Enable PDF debugging by adding this command to the beginning of your report:

  select 'dbr.export.options', 'debug', 1;

• Ensure the server can resolve its own hostname, as this is required to load CSS and JavaScript resources during PDF generation.

Graphviz Support

Graphviz provides support for hierarchical and network charts. To use these chart types, Graphviz must be installed on your server.

1. Download and install the latest version of Graphviz from the official download page.
2. If myDBR cannot locate the dot or neato commands, specify the installation path in user/defaults.php:

$mydbr_defaults['graphviz']['command_path'] = '/usr/bin/';