Report and Dashboard Designer - Rapidly Design and Seamlessly Deploy Reports and Dashboards in Minutes

Overview of DBxtra Report & Dashboard Designer

The DBxtra Report & Dashboard Designer serves as the core component of our reporting suite. It enables you to create projects, establish database connections, and define user-groups and user security, while allowing you to design queries, reports, dashboards, charts, data grids, and pivot tables. Once you are ready, deploy reports and dashboards to the Report Web Service, which allows end-users to view secure reports from any web browser.

App Download

Connect to any data-source located locally, on the LAN or on the Internet

You can establish a direct connection to various databases such as MS Access, SQL Server, MySQL, Oracle, Pervasive, DB2, Excel, and Text Files. Additionally, you can connect to any other database using ODBC or OLEDB.
Access tables, views, and stored procedures from your databases
Connect to Salesforce, MS Dynamics, QuickBooks, Google Apps, Microsoft Office 365, Google AdWords and Analytics, and more through CData ODBC Drivers
Organize your reports with projects and folders for easy access and management
Easily edit or change database connections as needed

Build Complex SQL Queries Without Writing Code using the Visual Query Builder

Build complex SQL queries in drag-and-drop mode with the visual query builder, without writing any SQL code
Create queries from connected database tables and views, or from designed DBxtra objects, or by mixing both
Write your own SQL syntax or copy-paste queries in the SQL pane as a power user
Create heterogeneous queries from two or more different databases
Use unlimited expressions supported by the connected database
Convert database field types with the expression converter
Assign groups and aggregate functions like SUM, AVG, MAX, MIN, and more
Apply filter criteria to refine query results
Sort query results using data sorting
Define run-time parameter queries, reports, and charts, enabling end-users to specify parameters when running reports

Visualize Your Data in the Data Grid

Use the Data Grid to preview your data or build a customized data view
Sort and group by unlimited fields in the Data Grid
Change column orders and width by dragging and dropping
Add unlimited drill-down data grid views for in-depth analysis
Filter data and save filters for quick access
Search for specific data using the Data Grid
Select rows and columns to copy data
Export filtered data to text, CSV, XML, and Excel formats
Save your favorite data grid views for easy access

Analyze Your Data with the Pivot Grid

Create pivot grids to analyze data in different ways
Sort and group data by any number of fields within pivot grids
Enhance your pivot grids with charts for visual analysis
Enable end-users to model their own pivot grids to match their analysis requirements
Export pivot data to text, CSV, XML, and Excel formats for further analysis or sharing
Quickly select rows and columns to copy data
Embed pivot grids into reports for easy sharing and viewing
Save frequently used pivot grid views for easy access and analysis

Create Complex Reports in Minutes

Create professional-looking reports quickly and easily
Design report dashboards by embedding reports and charts into a single report
Organize report data using unlimited groups
Use the Total Wizard to calculate report and group totals
Integrate additional data sources to enrich report data
Create bound and unbound sub-reports and charts to support analysis
Customize report formatting with no limitations
Apply one-click quick formatting to ensure consistent styling
Define and save styles to reuse with just one click
Enhance report content by inserting drill down reports, pictures, barcodes, page information, rich text fields, shapes, and lines

Create Powerful and Interactive Dashboards in No Time

Use the intuitive drag-and-drop interface to design dashboards quickly
Prepare data for dashboards easily using the DBxtra Query Builder
Create filter and drill-down dashboard items in multiple formats including charts, pies, gauges, cards, grids, maps and pivots
Generate interactive cross-data filters from different data sources for deeper analysis
Deploy dashboards automatically using the Report Web Service or embed them into web pages with a single line of code

Learn more about the Dashboard Designer

Secure Your Data with User Security

Manage user groups and individual users with ease in DBxtra
Control access to features and data by assigning privileges to user groups
Integrate user information with Windows Directory (LDAP) for enhanced security and system compatibility

Deploy Reports and Dashboards Automatically

Save reports to a designated file location for easy retrieval
Establish a secure, centralized report repository using the Report Web Service
Streamline report distribution to end-users through the repository
Access reports and dashboards using the Desktop Report Viewer
Analyze underlying report object data in Excel in real-time for enhanced insights

In addition to that, the Designer module incorporates the Free Desktop Report Viewer.

System Requirements

Processor 1Ghz
4 GB RAM
900 MB available space on hard disk drive
Windows 7 or newer
.NET Framework 4.8 (or higher)
If you don’t have it installed than the DBxtra setup will automatically download and install .NET 4.8 for you
Optionally IIS (Internet Information Service) – suggested to publish the web report service

Create Professional Reports Quickly with DBxtra - Download for Free Now!

The trial version is fully operational, with access to multiple sample reports and dashboards.
Additionally, you have the capability to connect to your databases and generate your own reports.