Report Designer - Design and Deploy Reports in Minutes

The DBxtra Report & Dashboard Designer is the core part of the reporting suite.It allows you to create projects, connect to your databases and define user-groups and user security.

Design queries, reports, dashboards, charts, data grids and pivot tables.
Deploy reports and dashboards to the Report Web Service where end-users can view secured reports with any web browser.

Report Designer Features

As a report creator, you’ll benefit from a complete set of layout and design controls to create formatted, interactive and professional-looking interactive reports and dashboards. DBxtra can address any report formatting and layout requirement by your company and makes it easy to design almost any report. A complete set of design controls offer the flexibility to give your reports a professional and pixel-perfect appearance.

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

Connect to your database located locally, on the LAN or on the Internet.
Connect to almost any database like MS Access, SQL Server, MySQL, Oracle, Pervasive, DB2, Excel, text files and through ODBC or OLEDB.
Connect to Salesforce, MS Dynamics, QuickBooks, Google Apps, Microsoft Office 365, Google AdWords and Analytics, etc., through CData ODBC Drivers.
Access tables, views and stored procedures from your databases.
Have access to all database objects like tables, views and stored procedures.
Once a data connection was established it will always be accessible from within DBxtra.
If required you can change edit database connections easily.
Organize your reports with projects and folders.

The visual query builder lets you build complex SQL queries in drag and drop mode, without the need to write any SQL code

The visual query builder lets you build complex SQL queries in drag and drop mode, without the need to write any SQL code.
Create queries from connected database tables and views and also from designed DBxtra objects or by mixing both.
Power users can also write their own SQL syntax or copy-paste their queries in the SQL pane.
Create heterogeneous queries from two or more different databases.
Assign 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, etc.
Apply filter criteria.
Apply data sorting.
Define run-time parameter queries, reports and charts – end users can specify parameters when running reports.

View your data in the Data Grid

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

View your data in the Pivot Grid

Design pivot grid views.
Sort and group by unlimited fields.
Add charts to your pivot grids.
Let the end user model his own pivot grids.
Export pivot data to text, CSV, XML and Excel.
Select rows and columns to copy data.
Embed pivot grids into report.
Save your favorite pivot grid views for quick access.

Design even the most complex Reports in Minutes

Quickly create great looking reports.
Design report dashboards by embedding reports and charts into a single report.
Insert unlimited groups.
Use the total wizard to enter report and group totals.
Insert data tables.
Add additional data sources to your report.
Create bound and unbound sub reports and charts.
Define report formatting with almost no limitation
Assign one-click quick formatting.
Define and save styles to apply with just one click.
Insert pictures, barcodes, page information, rich text fields, shapes and lines.

Quickly build powerful and interactive Dashboards

Design Dashboards with drag and drop interface.
The DBxtra Query builder makes it easy to prepare your data for your Dashboards.
Create filter and drill-down Dashboard items in various formats like charts, pies, gauges, cards, grids and pivots.
You can even create interactive cross-data filters from various different data-sources.
Deploy Dashboards automatically with the Report Web Service or embed them into web-pages with a single line of code.
More about designing Dashboards.

User Security

Define user group and users.
Assign privileges to user groups.
Synchronize with Windows Directory (LDAP).

Deploy Reports and Dashbaords

Save reports to a file location.
Set up a centralized and secured report repository with the Report Web Service and automatically deploy Information to end-users.
You can also use the Desktop Report Viewer to consume Reports and Dashboards.
View the underlying Report object real-time data in Excel.

System Requirements

Processor 1Ghz
1GB RAM
80 MB available space on hard disk drive
Windows XP, 1603 (32/64 bits), Vista (32/64 bit), 7
.NET Framework 4.0 (or higher)
If you don’t have it installed than the DBxtra setup will automatically download and install .NET 4.0 for you
Optionally IIS (Internet Information Service) – suggested to publish the web report service

Pricing & Licensing

See pricing here.

Licensing:

The DBxtra Designer is licensed on a named user base (NUL).

This product requires an active subscription license to Developer Express Inc.’s Universal Subscription.