DBxtra Changelog

What's new in DBxtra 8.2.2

Apr 30, 2015
  • New:
  • Report Designer:
  • New Excel data export engine, it improves speed and memory usage and now supports tighter integration with Excel.
  • The field list on the pivot grid now supports 3 different modes, including an Excel like field list.
  • The report designer now has a spark line control.
  • The report now have sub-bands, which allow you to have a space where you can show additional information on any band.
  • A button was added to access the scripts editor window on the Report Designer.
  • Firebird data connections now can specify a port.
  • Projects importation speed was improved.
  • The Percent of Row and Percent of Column fields on the pivot grid can now be deleted from the view.
  • An option was added for cover values so it doesn't show the data being passed to the report in the parameter window.
  • MySQL now can take in account the First Day of Week configuration on DBxtra.
  • Report Web Service:
  • Date functions with custom ranges now ask for their value.
  • The log in speed of the Report Web Service while using Active Directory was improved.
  • GUID (Unique Identifier) parameters now work properly.
  • Dashboard Designer:
  • The Dashboard now has a Group element.
  • The Dashboard has now filtering specific elements (Combo box, List Box and Tree View).
  • Now you can edit the colors of some elements in the Dashboard.
  • Now you can change the width of columns in a Grid dashboard item.
  • Schedule Server:
  • Now you can send and export data and pivot grid views directly from the Schedule Server.
  • Troubleshooting messages while configuring SMTP settings were improved.
  • Bugs fixed:
  • Report Designer:
  • The Page Setup window on the Report Designer replaces commas with dots on regional settings which use commas as decimal separator.
  • Pivot grids inserted into a report show columns that don't appear in the view.
  • Renaming a calculated field on the pivot grid makes it lose its data.
  • Inserting and unbound sub report which contains its own pivot grid causes the designer to hang.
  • Exporting to CSV doesn't escape the delimiter (like commas) on the data and pivot grid.
  • Setting a User Variable uses a heterogeneous query.
  • Exporting to a Tab separated file doesn't work properly on the data and pivot grid.
  • Creating more Designer users than the allowed on your license, causes that only the first ones are able to log in.
  • Converting from normal to heterogeneous queries fails with syntax errors for PostgreSQL.
  • The First Day of Week option it's disabled for users without a Report Web Service license.
  • Changing from a designed view to the initial view make the fields lose the summary on the field caption.
  • Users created with the user import utility throw an exception when viewed on the Designer.
  • Using the same parameter name on different columns and on different sub queries causes and error while filling in the Report's field list.
  • An exception loading the data source makes the dashboard appear empty on the design view.
  • Schedule Server:
  • Exporting to CSV doesn't escape the delimiter (like commas).
  • Missing Outlook libraries causes a problem while saving the Project's configuration.
  • Report Web Service:
  • The pivot grid shows columns that are not part of the view, or the columns are out of order.
  • Using a data source with dynamic columns causes an exception.
  • The Sort field’s window doesn't load its contents until you perform a post back.
  • The view size it's very small after changing the summaries on the pivot grid.
  • When using Active Directory, you can still log in with DBxtra built in users.
  • First run welcome pop up it's not showing.
  • User group permissions are not reset when a user from a different user group logs in.

New in DBxtra 8.2.1 (Apr 30, 2015)

  • New:
  • Report Designer:
  • Direct data connection for SQL Server Compact was added.
  • DBxtra detects if there is a DBxtra Web Server already configured and use it on first time run.
  • Report Web Service:
  • Save to bookmark now let's you manually create a bookmark on browsers who don't support automatic bookmark creation (like Chrome).
  • The data grid now extends to the right of the page in case it doesn't fit in the available space.
  • The pivot grid now extends to the right of the page in case it doesn't fit in the available space.
  • The report frame now can change its size dynamically depending of the page size of your report. More...
  • Bugs fixed:
  • Report Designer:
  • The App Pool for the Report Web Service is still being configured to use 32 bits mode on Internet Information Services.
  • An exception is thrown when you configure the Report Web Service to use Internet Information Services and the site is missing some binding’s information.
  • Configuring the Report Web Service with Internet Information Services uses the repository path from the configuration file, instead of the one reported by the Report Web Service.
  • The internal web server doesn't start, when it's needed, at startup time.
  • The link automatically created on the desktop for the Report Web Service, when you configure it to use Internet Information Services, doesn't include port information.
  • Multiobject Web Report Widget doesn't support dashboards.
  • When saving a data grid view opened from the start page it marks itself as the default view.
  • Drill downs can't be created in the Data Grid.
  • Report Web Service"
  • Export to Excel doesn't select the appropriate format for large data grids when being grouped.
  • Exporting dashboards with gauges throws an exception on the Report Web Service .

New in DBxtra 8.2.0 (Sep 12, 2014)

  • New:
  • DBxtra now fully supports 64 bit computers, this enables you to work with more reports at the same time and use bigger data sets.
  • Learn more about the 64 bit version.
  • Query Builder: Support for MySQL stored procedures.
  • Improvements :
  • The “Fit All” algorithm on the Data Grid was improved so it looks the same on the Designer and the Report Web Service.
  • The length of the password for users was expanded to allow up to 32 characters.
  • Now you can select a connection from a different project for heterogeneous queries.
  • Bugs fixed:
  • An incorrect reference prevented the configuration of the Report Web Service with Internet Information Services.
  • When you export a Data or Pivot Grid to Excel the dates appeared as a number instead of as a date.
  • Adding several columns to a Data Grid View caused the last one to disappear on the Report Web Service.
  • Adding a filter to the Data Grid caused an exception in the Report Web Service and prevented the View from loading.
  • When an object was imported into DBxtra and you chose to create a new Connection, it was created with the same name and remained hidden.
  • The DBxtra Web Server failed to start on some computers.
  • When importing an Object the connection in the "Select Connection" dialog where in the order they were created, this was changed to alphabetical order.

New in DBxtra 8.1.0 (Mar 14, 2014)

  • New:
  • DBxtra now fully supports 64 bits computers, this enables you to work with more reports at the same time and use bigger data sets.
  • No support for MySQL stored procedures.
  • Improvements :
  • The “Fit All” algorithm on the Data Grid was improved so it looks the same on the Designer and the Report Web Service.
  • The length of the password for the users was expanded to allow up to 32 characters.
  • Now you can select a connection from a different project for heterogeneous queries.
  • Bugs fixed:
  • An incorrect reference prevented the configuration of the Report Web Service with Internet Information Services.
  • When you export a data or pivot grid to Excel the dates appear just as a number instead of as a date.
  • Adding several columns to a data grid view makes the last one disappear on the Report Web Service.
  • Adding a filter to the data grid caused an exception in the Report Web Service and prevented the view from loading.
  • When an object was imported into DBxtra and you choose to create a new connection, the connection was created with the same name and remained hidden.
  • The DBxtra Web Server failed to start on some computers.
  • When importing an object the connections in the "Select connection" dialog where in the order they were created, this was changed for alphabetical order.

New in DBxtra 8.0.0 (Oct 24, 2013)

  • New :
  • DBxtra Dashboard Designer add-on.
  • Bugs fixed:
  • Several minor bugs fixed.

New in DBxtra 7.2.2 (Sep 24, 2013)

  • New features:
  • Define if user group is allowed to view data connection settings.
  • Bugs fixed:
  • Several minor bugs fixed.

New in DBxtra 7.2.1 (Jun 5, 2013)

  • New features:
  • Stored Procedures: Now you can use multivalued parameters, they will be passed to the stored procedure parameter as a string of comma separated values.
  • Data Grid: On demand Drill Down, now the drill down data will be loaded only when you need it.
  • Free Viewer: Refresh button was added.
  • Bugs fixed:
  • Using multi valued parameters with descriptions in a In clause causes an error when selecting more than one value.
  • Using the same parameter name in more than one parameter cause the second appearance of the parameter to be ignored if date functions are enabled.
  • Query Builder: Sorting (Order By) wasn't working properly when the system language was different than English.
  • Designer: Opening a report twice make it open the wrong report when other reports are loaded.

New in DBxtra 7.2.0 (Jan 24, 2013)

  • New features:
  • The ability to see the detail of a summarized data on the Pivot Grid Drill Down.
  • Integration of the Pivot Grid data with Bing Maps.
  • Bugs fixed:
  • Automatic fix for the problem wwhen opening an object showed a Navigation Cancelled page in the Designer.
  • Improved compatibility with Common Expression Tables (CTE).

New in DBxtra 7.1.1 (Jan 10, 2013)

  • New features:
  • Added users with Viewer privileges, that can log in into the Designer, but can't edit reports.
  • Bugs fixed:
  • MySQL connections didn't take the Connection Timeout parameter.
  • Exporting to CSV from the Report Web Service caused an error if the exported object was a Stored procedure with date (Datetime) parameters.
  • If no band or chart was selected and you opened the Advanced Chart Editor DBxtra threw errors.
  • The DBxtra Web Server was not accessible from outside computers if it was running on a Windows XP computer.
  • Better performance on slow connections for the Designer.

New in DBxtra 7.1.0 (Oct 29, 2012)

  • New features:
  • DBxtra can now use SQL Server Compact as the format of the repository instead of an Access database.
  • Schedule Server: Report Objects with parameters can be scheduled now.
  • Bugs fixed:
  • Datagrids on drilldowns display improperly (too narrow) on Mozilla Firefox, Google Chrome and Apple Safari.
  • Exceptions when a datagrid view with drilldowns is accessed directly from the report object's overview.
  • Column order and placement is lost when you save a bookmark of a datagrid in the Report Web Service.
  • The initial view doesn't appear in the view list of the Report Web Service when you have other views.
  • Firebird connections don't show any table.
  • Some databases throw exceptions when their queries are converted to heterogenous queries.

New in DBxtra 7.0.1 (Oct 29, 2012)

  • New features:
  • Free Desktop Viewer: now opens reports directly from within the Viewer interface and supports multiple reports to be opened. Download from here.
  • DBxtra Schedule Server: Now allows defining Excel format output (xls – xlsx).
  • Designer: Now offers the option to obtain the description of table columns – (mostly applied on DB2 databases).
  • Bugs fixed:
  • Some user passwords returned errors accessing report objects.
  • Some reports with parameters were not visible from within the project explorer.
  • Query Builder: DB2 connections returned an error when loading column descriptions.

New in DBxtra 7.0.0 (Oct 29, 2012)

  • New features:
  • New Designer interface.
  • Pivot grid now supports inserting charts.
  • Data Grid – now supports export to csv files.
  • Improvements:
  • Report Web Service - when running reports and browsing through pages speed was improved strongly.
  • Report Web Service - Data Grid and Pivot Grid load speed was improved.
  • Bugs fixed:
  • Designer: Error in date function – SQL Anywhere dataset, fixed.
  • Designer: Custom Colour Palette for charts - corrupts reports.
  • Designer - Inbound sub-reports loses data source when embedding several inbound sub-reports.
  • Designer - Several minor bugs fixed.
  • Schedule Server - various minor bugs fixed.

New in DBxtra 7.1.0 (Oct 29, 2012)

  • DBxtra can now use SQL Server Compact as the format of the repository instead of an Access database.
  • Schedule Server: Report Objects with parameters can be scheduled now.
  • Bugs fixed:
  • Datagrids on drilldowns display improperly (too narrow) on Mozilla Firefox, Google Chrome and Apple Safari.
  • Exceptions when a datagrid view with drilldowns is accessed directly from the report object's overview.
  • Column order and placement is lost when you save a bookmark of a datagrid in the Report Web Service.
  • The initial view doesn't appear in the view list of the Report Web Service when you have other views.
  • Firebird connections don't show any table.
  • Some databases throw exceptions when their queries are converted to heterogenous queries.

New in DBxtra 6.0.2 (Oct 3, 2011)

  • New features:
  • New Compact View mode for Pivot Grid.
  • Support for MySQL 5.5 and 5.1 (Dropped support for MySQL 4.0 and older.
  • Now, DBxta objects which uses date functions, can be exported to linked Excel files that also will remain updated regardless of when you exported them.
  • Applies to data connections: MS Access, MS SQL Server, Oracle and MySQL.
  • You can use sub-reports and Pivot grids with parameters in a Report and you'll be asked for the parameters in both the Designer and the Report Web Service.
  • The DBxtra Web Server now runs as standalone service, so you don't need to keep DBxtra opened to access it.
  • Report Web Service: Data headers now can be displayed as a popup in the Pivot grid (when you add more than 3).
  • Bugs fixed:
  • The port selector in MySQL and PostgreSQL connection can't be set to a value higher than 9999.
  • Refreshing fields in a Pivot Grid with the Filed List closed caused an exception.
  • Viewing the properties of an object sometimes caused an exception.
  • The schedule service can't connect to a DBxtra Repository in certain scenarios