Design, distribute and manage reports
The DBxtra Report 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. You can design queries, reports, charts, data grids and pivot tables.
Deploy reports to a physical file, which end-users can open with the Free Desktop Report Viewer.
If you need advanced security, easier installation and deployment there's also 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. 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 your data
- 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.
- 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.
Create Queries without SQL knowledge
- 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 runtime parameter queries, reports and charts - end users can specify parameters when running reports.
View your data in the Data Grid
- Use the 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.
Design Charts
- Design charts with the quick or advanced chart wizard.
- A wide variety of charts like bar, pie, point, line, doughnut, etc. are supported.
- Embed multiple charts into reports.
- Fine tune charts just as you need them.
Export and E-mail Reports
- Export your reports to Excel, Word, PDF, HTML, CSV, Image files and XML.
- Send E-mails attaching reports and charts with a single click.
- Export to a live connected Excel sheet and live connected pivot table.
Report Deployment
- Save reports to a file location. End-users can open any DBxtra report with the Free Desktop Report Viewer
- Set up a centralized and secured report repository with the Report Web Service and automatically deploy Information to end-users.
User Security Settings
- Define user group and users
- Assign privileges to user groups.
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
Licensing: The DBxtra Designer is licensed on a concurrent user base. You can install it on as many computers as you want; but only the amount of concurrent users which your Designer license supports can use it at the same time.