How to Customize Data Connectors in Bold Report Designer

When using the Bold Report Designer, you can enhance the user experience by customizing the list of available data connectors. This customization allows you to define a specific set of data sources, ensuring consistency and control over the data used in reports.

How to Filter Data Connectors

To customize the list of data connectors displayed in the data panel, use the filterDataConnectors property. This property accepts an array of strings, where each string represents a data connector that will be accessible to users.

Example: Limiting Data Connectors to Specific Databases

To configure Bold Report Designer to show only specific data connectors such as SQL, MariaDB, and MySQL, follow these steps:

1. Create a JavaScript application as outlined in the Bold Reports documentation.
2. Use the filterDataConnectors API to restrict the visible connectors.

<script type="text/javascript">
       $("#designer").boldReportDesigner({
           filterDataConnectors: ['SQL', 'MariaDB', 'MySQL']
       });
</script>

In this configuration, only the specified data connectors (SQL, MariaDB, and MySQL) will appear in the data panel. All other connectors will be hidden, helping create a more focused and streamlined reporting environment.

Visual Representation of the Data Panel

After applying the filter, the data panel will display only the specified connectors. Below is an example image showing the filtered data panel:

Note: The Shared option remains enabled by default in the data panel, allowing access to shared data sources unless further customization is applied.

Sample Application

You can download a complete sample application for the Embedded JavaScript Report Designer with filtered data connectors from this link.

By implementing these steps, you can tailor the Bold Report Designer’s data panel to show only the connectors relevant to your reporting needs, improving usability and maintaining better control over the reporting environment.