We need your help!

User feedback enables for a great product! Please take the time to answer our quick survey.

NextReports Designer - Release Notes

22.07.2014 version 7.2

  • [Feature] Report / Chart Internationalization
  • [Feature] "Display" report type: to show a single value and percent on how it evolved from previous period of time
  • [Feature] Use functions inside expressions from Headers and Group Headers
  • [Feature] Shadow property for alarm and indicator reports
  • [Feature] Add support for SYBASE9 driver (driver not included)
  • [Improvement] Xls Exporter: Use orientation (portrait , ladscape) for print purposes
  • [Improvement] Xls Exporter: set page size for print purposes
  • [Improvement] Sql Editor: Highlight error line (only for JDBC drivers where error contains line number like MySql, Derby)
  • [Improvement] Report Layout cache of report columns: Designer Column/Expression cell selection -> query was executed at every selection to get column names and types
  • [Improvement] Update firebird driver to version 2.2.5
  • [BugFix] MySql Image from database not shown
  • [BugFix] Parameter with JTextField as UI used inside source of other parameter: when writing inside the text field the dependent parameter is not populated.
  • [BugFix] PostgreSQLDialect map timestamptz type
  • [BugFix] CsvDialect map Time field
  • [BugFix] XlsExporter cache fonts: For large XML files we get: "the maximum number of fonts was exceeded" and those cells are not formatted
  • [BugFix] Edit parameter with source: schema may be lost generating "Table or View does not exists"
  • [BugFix] Insert Chart/Report inside another report : double click (instead of simple click) on entity window will corrupt report

12.05.2014 version 7.1

  • [Feature] NextCharts: Bubble Chart
  • [Feature] NextCharts: tooltip with #x markup for x label value
  • [Feature] NextCharts: showLabels property ( true means X labels are shown on X axis, or with lines for pie; false means no labels are seen on X axis; no lines with labels for pie, in this case user can use #x markup to show the value on tooltip message )
  • [Feature] NextCharts: Tooltip message property for chart: can be changed using existing markups #val , #total , #x, #percent and tags
  • [Feature] Survey Action (only once after 10 days of first run)
  • [Feature] Images from database: test sql blob type for image content and show the image inside a report
  • [Feature] Excel template & sheet number to write the report inside a sheet from existing excel.
  • [BugFix] PieChart issues: total (from tooltip) is not formatted with tooltip pattern
  • [BugFix] PieChart issues: negative values breaks labels positions (should be considered as 0)
  • [BugFix] PieChart issues: for 0 or very small values labels can overlap
  • [BugFix] NextCharts:  space for halfdiagonal and diagonal labels is not correctly computed
  • [BugFix] "Group By" cannot be empty if no Aggregate function is present (we should allow it to be empty)
  • [BugFix] Parameter default values for 'unsigned int' generates an exception
  • [BugFix] NullPointerException when designer starts after all data sources were deleted
  • [BugFix] Column Names with spaces raise error on some situations (select columns from a dragged table and run query, create a parameter with source table.column)
  • [BugFix] Insert a chart (using CSVDialect) inside a report throws exception at runtime
  • [BugFix] MSSQL dialect: map image type as java sql blob

25.02.2014 version 7.0
  • [Feature] New HTML5 Charts which support all existing flash functionality / settings.
  • [Feature] New horizontal stacked bar chart (HTML5)
  • [Feature] New bar-line and stacked bar-line charts (HTML5)
  • [Feature] Horizontal bar now supports style property (HTML5)
  • [Feature] Validate sql: besides report sql, parameters sql (if any) and subreports sql (if any) are checked
  • [Feature] Validate sql: Validation returns error messages, not just "sql is not valid"
  • [Feature] Validate sql: Validation allows for bulk replace functionality if error
  • [Improvement] Image chart exporter: pie and normal bar without shadows
  • [Improvement] On connection broken try to recreate the connection (connection may be broken because of pool timeout)
  • [BugFix] On connection broken the entity cannot be saved. Now a connection broken dialog with the option of saving current work is shown.
  • [BugFix] View actual clob data inside report
  • [BugFix] MySql TIME field is not mapped
  • [BugFix] Download report/chart from server with UTF-8 characters: characters are wrong
  • [BugFix] Edit Chart/Report in Designer (called from server) with UTF-8 characters: characters are wrong
  • [BugFix] Dispatcher for "Edit in designer" has wrong links for designer artifacts
  • [BugFix] FOR Report Regression: all values passed as parameter are the same

19.12.2013 version 6.3

  • [Feature] Use expression/variable in Indicator title/description
  • [Feature] View columns that have indexes (special icon)
  • [Improvement] CheckForUpdates action will call internal url to save audit info in database
  • [BugFix] SQLite DialectException is raised if we want to run a query, or we drag a table to designer
  • [BugFix] MySql Dialect TINYINT UNSIGNED was not mapped to a jdbc type

08.10.2013 version 6.2

  • [Feature] "Max Rows Checked" property in Settings to be able to select or not by default "max rows" from query builder panel.
  • [Feature] Functions in Header and Group Header: User is allowed to add functions in Header bands (not just in Footer ones)
  • [Feature] Dialect new add method: public boolean needsHoldCursorsForPreparedStatement(); For Firebird this must return true: otherwise an exception "resultSet is closed" is raised
  • [Feature] Add new VerticaDialect
  • [Feature] Possibility to add dialects by users through VM parameters
  • [Feature] 'Cell formatting conditions' are now similar to 'row formatting conditions'. This means to be able to select an arbitrary expression to compare its value with.
  • [Improvement] View Columns Info: allow to copy from table (selection was not possible in previous versions)
  • [Improvement] Check for Update is rewritten to look on github releases (instead of proprietary install4j process)
  • [BugFix] HTML export : not enough <tr> when a band row has rowSpan > 1
  • [BugFix] Xls Exporter: if a sub-report is followed by other column, some columns values from the first row will be overwritten (won't be seen)
  • [BugFix] Query Result Table: datetime fields are seen as simple dates (without time)
  • [BugFix] Bug in replaceAll on FindReplaceDialog ( try to replace all "[" with "v1.[" the program enters in a recursive loop )
  • [BugFix] Wizard - Template Step is not showing in some situations when we click Next
  • [BugFix] Report Layout Copy / Paste gives Error on Linux
  • [BugFix] Report Layout Copy / Paste a merged cell, when we Open Report it generates ArrayIndexOutOfBounds
  • [BugFix] Report Layout Copy function with expression does not keep expression (when we double click on the copied cell we will not see the expression selected)
  • [BugFix] Report Layout Copy Hyperlink band element does not keep the text and url (when we click on a copied Hyperlink we do not see the text and the url)
  • [BugFIx] Report with groups: Change a column name inside query, if column is used by a group it will raise a NullPointerException

25.06.2013 version 6.1.1

  • [BugFix] Driver for MSSQL Server jtds-1.3.0 was good just for Java 1.7. For compatibility we added jtds-1.2.8.
  • [BugFix] HTML exporter with more barcodes inside report : HTML exporter will show all identical with the last one
  • [BugFix] Query Results Table : copy actions -> copied elements are not formatted like inside the table
  • [BugFix] Query Results Table : Integer / Long elements must not contain thousand separator.

11.06.2013 version 6.1

  • [Feature] CSV Data Source : can create reports using data from csv files
  • [Feature] Multiple Report : Multiple Report is a report with a special sql query which will return values for a column. "Multiple Report" will be replaced inside layout with as many reports as values are inside special query after execution.
  • [Feature] Favorites Menu to automatically open reports or charts which were previously added to favorites.
  • [Improvement] Update JDBC drivers to current versions
  • [BugFix] XlsExporter - more subreports on same header line: Exporting a report with more subreports on same header line shows the subreports cascading
  • [BugFix] Publish report/chart with a version bigger than server engine version fails in some cases without giving the needed info
  • [BugFix] Report Layout Pick pattern : when edit pattern some fields from panel are not completed from pattern

25.02.2013 version 6.0

  • [Feature] New type of report: Value Indicator (to follow a value inside a defined interval)
  • [Feature] Report has a type property (default, alarm, table, indicator)
  • [Feature] Wizard has now support for creating special reports like table, alarm, indicator
  • [Improvement] Publish Improvement : report will be published with it's defined type (no need for table and alarm checks; bulk publish of different report types is now possible)
  • [Improvement] New Internationalization file can be added by user
  • [BugFix] Parameters with source & id column is of type CHAR will raise an error "type for value cannot be Serialized."
  • [BugFix] Format a date ParameterBandElement when the parameter has a manual source does not work.
  • [BugFix] Create a Report from a query with timestamp parameter in Derby fails
  • [BugFix] Databases with default schema (%) ParameterUtil.getColumnValues shows an error
  • [BugFix] Firebird current date error: "Column unknown NOW"

06.12.2012 version 5.4

  • [Feature] Charts Dynamic Series: A new property "column query" is used to define dynamic series.
  • [Feature] Parameters $P{..}  can be used inside Chart column legends
  • [Feature] New chart properties: X axis label font and Y axis label font
  • [Feature] Chart Layout Panel  : user can now select other data source to run (like inside Report Layout Panel)
  • [Feature] Total Page Number variable for PDF exporter
  • [Feature] New Background Image Property for report to be used in PDF and HTML
  • [Feature] New "Custom" paper size for document
  • [Improvement] When loading a chart/report template, all colors are added to color history
  • [Improvement] Publish to server : auto set credentials when we change the server from combobox
  • [BugFix] Pdf Exporter : font specified by nextreports.pdf.font system property is not embedded in pdf
  • [BugFix] Engine method ReportUtil.loadReport(InputStream is) does not read the file with UTF-8 encoding
  • [BugFix] JFreeChartExporter does not set legends fonts
  • [BugFix] Regression: wrapText for PDF is allways true
  • [BugFIx] Parameter with "Column selection" for values gives an "object not found" error at runtime if there are more schemas present.
  • [BugFix] ReportLayout : change data source -> list of compatible data sources is taken after type, but it should be after driver
  • [BugFix] "Show at startup" panel is not shown at a fresh install

24.09.2012 version 5.3

  • [Feature] Reports inside reports
  • [Feature] New actions: Edit report & Edit chart for report and chart band elements so that user can edit inner reports and charts
  • [Feature] Installer: all user data is kept in user home allowing more users on same computer
  • [Feature] Settings : change locale from user interface
  • [Feature] Report Layout: new barcode element
  • [Improvement] Instances: there can be more designer instances opened at the same time allowing that edit reports/charts in designer from server to work even if an instance designer is already opened
  • [Improvement] Simplify perspectives : Use only a layout perspective instead of report & chart perspectives
  • [BugFix] Publish report with 'Dashboard Table' check : checkbox is not selected if we publish it again
  • [BugFix] Report Layout: for cut/copy paste cells, properties like 'wrap text' and 'text rotation' are lost
  • [BugFix] Report Layout: If pattern is not present, Date, Timestamp and Number elements are not generated with default Locale
  • [BugFix] If "Edit in Designer" from server is used, reports and charts with spaces in their names are downloaded with '%20' instead space characters
  • [BugFix] Xml Exporter: some xml characters like & < > " ' were not escaped
  • [BugFix] Excel Exporter: maximum number of fonts exceeded error in MS Excel if many formatting conditions are found
  • [BugFix] Not-resizable dialogs must not use dimension preferences
  • [BugFix] Ssl keystore file used for HTTPS must be saved in user home designer data folder instead of installation folder
  • [BugFix] Publish Bulk Charts : dashboard table and dashboard alarm properties must not be visible

31.05.2012 version 5.2

  • [Feature] An internal auto conversion mechanism which transforms a Next report from an older version to a new one.
  • [Feature] Extend Dynamic values (see server for explanation)
  • [Feature] Creating "row" concept (Row Element)
  • [Feature] Row Formatting Conditions (similar with band cell element formatting conditions)
  • [Feature] Save bound preferences for dialogs (when application is reopened the dialogs have your adjusted size)
  • [Feature] New text rotation property for PDF and Excel (90degree, 0 and -90 degree)
  • [Improvement] New Page property is removed from Band Element and added to Row Element
  • [Improvement] Cell Formatting Conditions for multiple selection if all cells have the same java type (previous version allows just for single selection)
  • [Improvement] ReportLayout: Text Property when selecting a cell is editable only for simple text
  • [BugFix] ReportLayout: Combobox editor for ColumnBandElement shows gray areas if new columns are added into query
  • [BugFix] ParameterManager:  When adding parameters from other report, the other report is loaded and the save will overwrite that report
  • [BugFix] RuntimeParametersPanel: sometimes values are missing or are duplicated on repetitive runs for list dependent parameters
  • [BugFix] Excel exporter: image in header on every page is duplicated on the first page
  • [BugFix] ChartLayout: In charts, null values are interpreted as value 1, instead of 0 
  • [BugFix] JFreeChartExporter fo pie and bar charts if more values with the same  label shows only the counter (without label)
  • [BugFix] RuntimeParametersPanel: If a parameter P depends on a hidden parameter and also on another parameter, in designer at runtime the values for P will never be populated
  • [BugFix] ReportLayout: Paste an expression  band element in another cell keeps the same expression name instead of making it unique
  • [BugFix] RuntimeParametersPanel: Chart Dependent Parameters with not-found Default values will raise a NullPointerException in ListSelectionPanel

07.03.2012 version 5.1

  • [Feature] Expressions can contain functions
  • [Feature] New bands inside report layout : page header band and page footer band
  • [Feature] New document padding property for PDF, RTF, Excel
  • [Feature] New Page Number Variable (useful for PDF and RTF)
  • [Feature] New ReportName Variable
  • [Feature] New Roman Number Converter
  • [Feature] System properties to auto-open datasource , chart, report at startup
  • [Feature] Register nextreports protocol & Save path to every version of designer installed. This protocol is used by NextReports Server to open the designer on edit actions
  • [Improvement] History Color Chooser : add color only if it is not already in history
  • [Improvement] Expression Panel : do not show empty parameters list if no parameter is defined in report
  • [BugFix] Rename query,report,chart : change the name also inside XML
  • [BugFix] ResultExporter : newRow variable incorrectly computed for some cases
  • [BugFix] Publish to server store file properties  : are not saved if file name too long
  • [BugFix] Bulk Publish: reports and charts name contained the extension

16.01.2012 version 5.0

  • [Feature] Bulk Publish to server
  • [Feature] Bulk Download from server
  • [Feature] Add parameters from other queries/reports/charts
  • [Feature] Clone parameters
  • [Improvement] Update to poi 3.7
  • [BugFix] Publish Login : Last used server was not set as default

11.01.2011 version 4.2

  • [Feature] New Area Chart Type 
  • [Feature] Animations for Bar, Line, Area charts
  • [Feature] Add more foreground colors / columns/ legend columns
  • [Feature] Chart Template
  • [Feature] New connection.timeout property in Settings 
  • [Improvement] In save report/query dialogs it is possible to create new folders
  • [Improvement] Show in UI parameters used in other parameters (and not in main query) even if they are not hidden
  • [Improvement] Update Oracle driver to 11.2.0.3
  • [Improvement] Report Layout : keep settings of cell if we insert another 'text' entity
  • [BugFix] Horizontal bar charts are not drawn due to main font property
  • [BugFix] Image chart preview : series incorrect for charts with no Y column function
  • [BugFix] Image chart preview : StackedBar chart does not correctly compute maximum Y value
  • [BugFix] Image chart preview : first and second values added to a chart with integer X values were the same
  • [BugFix] Flash chart preview : HorizontalBar generates labels with step = 1 
  • [BugFix] Flash chart preview : When values are added as BigDecimal to a StackedBarChart, the bars are drawn over the title
  • [BugFix] Dependent Parameters Designer UI : Added listeners for date picker, checkbox and text field
  • [BugFix] Report Layout : Column value in footer group band is the value of the next group

08.11.2011 version 4.1

  • [Feature] Format empty band elements
  • [Feature] Add SQLite driver and dialect
  • [Feature] Add chart pattern property for y column tooltips
  • [Feature] Use hidden parameter in another not hidden parameter even if it is not used in the main query
  • [Feature] Add chart main font property
  • [Feature] Add chart xaxis and yaxis color properties
  • [Feature] JColorChooser History
  • [Improvement] JFreeChart export set range axis interval with same algorithm used for JSONExporter
  • [Improvement] Parameters of type Date must not show time in UI (only Time and Timestamp)
  • [Improvement] Update jersey to 1.7 version
  • [Improvement] Pie chart with gradient fill and animation
  • [BugFix] Engine - Export chart as excel crashes
  • [BugFix] Engine - MSSQL Dialect map 'numeric identity' type
  • [BugFix] Engine - Excel Cells with date fields are added as STRING_CELL_TYPE and cannot be filtered accordingly to a date filter
  • [BugFix] Designer Outer Join is not ANSI style  and works only for Oracle
  • [BugFix] Evaluation of expression with parameter failed if it is an IdName
  • [BugFix] Criterias with parameters are not taken into account if we do not have joins between tables
  • [BugFix] A report with hidden and not-hidden parameters may generate IndexOutOfBounds in RuntimeParametersPanel
  • [BugFix] User is not asked to save the chart after modifying anything inside the query (without selecting the chart perspective)

03.28.2011 version 4.0

  • [Feature] A JDBC driver implemented using Web Services, which allows clients (NextReposts Designer) to connect to datasources defined on server using the standard JDBC interface
  • [Feature] Engine & Report Layout: Add LEGAL, LEDGER and TABLOID formats to report page format property
  • [Feature] Engine: New flat file format with fixed size columns exporter
  • [Feature] Report Layout: Column Size action in characters (added to existing one in pixels)
  • [Feature] French Internationalization
  • [Feature] Engine: Export chart to image
  • [Feature] Engine & Report Layout: Insert chart inside report using a ChartBandElement
  • [Feature] Engine & Report Layout: New chart property 'showValues' for Y axis used by image export
  • [Feature] Engine & ReportLayout: Add new page (pdf, rtf) or new sheet (excel) on any row from band
  • [Feature] Sql validation for query/report/chart to see if a column, table, view used inside sql was renamed or removed
  • [Improvement] Report Layout: Resize Image Action works on multiple selection
  • [Improvement] Publish dashbordable report to server : check all parameter have default values
  • [Improvement] Update derby· driver to 10.7.1.1
  • [BugFix] Engine HTML exporter : for cells with rowspan > 1 and colspan > 1, the necessary empty rows were not added

11.15.2010 version 3.5

  • [Feature] Engine & Report Layout : Alarm reports
  • [Feature] Publish alarm reports to server
  • [Feature] Publish reports and charts to https servers
  • [Feature] Data Source : add & edit with an auto-connect checkbox
  • [Feature] Templates : A template contains now also a footer
  • [Feature] Report Layout : Upper left corner is clicked for showing report properties
  • [Feature] Report Layout : Border Chooser has now different colors, for top, left, bottom, right
  • [Improvement] Report Layout : Border chooser has different thickness for top, left, bottom, right
  • [Improvement] Report Layout : Insert Image band element with image preview
  • [Improvement] New Report : default padding 1 for all cells
  • [Improvement] New Report : create an empty footer row (F0)
  • [Improvement] Use jdic library to open generated files (java 1.6 still has bugs)
  • [Improvement] Right click actions with more understandable names
  • [Improvement] Report Layout : Change ruller unit measure with simple double click on it
  • [Improvement] Templates : save folder is application internal "templates" folder
  • [Improvement] Templates : for create & modify user remains inside panel until the close button is pressed
  • [Improvement] Parameters used by stored procedures may be or may be not checked as "stored procedure parameters" to interpret values
  • [Improvement] Connections are sort by name inside tree explorer
  • [BugFix] Report Layout : Insert image on a not-saved report crashes with NullPointerException
  • [BugFix] Templates : for background and foreground could not select excel colors

08.31.2010 version 3.4

  • [Feature] Engine : Interpret values for parameters with default source at runtime
  • [Feature] Report Layout : Zoom in  / Zoom out
  • [Improvement] Move to Java 1.6 and update swingx to 1.6 version
  • [BugFix] Query Editor : Exception when going from designer tab to editor tab and no data source is connected

08.02.2010 version 3.3

  • [Feature] Parameters with MULTIPLE values also for those without a source
  • [Feature] 'Hide when expression' property
  • [BugFix] Verify query / report / chart version on import actions : cannot import newer versions on older designers

06.09.2010 version 3.2

  • [Feature] Query Editor : Find / Replace history
  • [Feature] Report Layout : Formatting conditions
  • [Feature] Report Layout : Expressions support
  • [Feature] Report Layout : Group Row Variable
  • [Feature] Color chooser : new 'Excel Palette' to select excel known colors
  • [Feature] Report Layout : paper size for RTF and RTF
  • [Feature] Chart Layout : use parameters in title and legends
  • [Feature] Publish Report - dashboardable check (to inform that a report can be added to a server dashboard)
  • [Improvement] Update to iText 5.0.2
  • [BugFix] Excel export : maximum number of fonts and styles was reached
  • [BugFix] Report Layout - Insert row / column : Pressing close in the dialog will insert the column / row anyway.
  • [BugFix] Error for parameter with a source that returns a char column
  • [BugFix] Database Keywords used as table names : drag and drop table in designer fails
  • [BugFix] OpenChart : chart is not opened if sql query returns an error (when getting columns)
  • [BugFix] Import Chart : not visible on right click in the tree explorer (on Charts node)
  • [BugFix] N-Layer (N>2) Dependent Parameters with default values : only first dependent parameter was automatically filled

04.21.2010 version 3.1

  • [Feature] Image Size
  • [Feature] New property "locale" in designer properties file
  • [Feature] View user in License info
  • [Feature] Engine : Export a report / chart to a table memory object (header and data)
  • [Feature] Global properties for report : orientation, header on every page (no selection at runtime is needed)
  • [Feature] Groups : "New Page After" property (for RTF, PDF, EXCEL)
  • [Feature] Header on every page also for RTF and EXCEL (similar to PDF)
  • [Improvement] Update to poi 3.6
  • [BugFix] Publish Report : error thrown if data source was renamed on the server
  • [BugFix] Import from older versions : first import properties file (with tnsname)

03.18.2010 version 3.0

  • [Feature] Charts : Line, Bar, Horizontal Bar, Stacked Bars, Pie
  • [Feature] Backup, Restore, Import actions also include now the charts.
  • [Feature] Older ViewReportSQL Action is now ViewSQL Action and allows to view the sql from a query, a report or a chart.
  • [Feature] Extend Wizard action to support also chart creation.
  • [Feature] Publish and Download actions for reports and charts. For report the images are also published / downloaded.
  • [Feature] Add images in report layout for export in HTML, PDF, RTF, EXCEL. Images are not scaled.
  • [Feature] Add hyperlinks in report layout for export in HTML, PDF, RTF, EXCEL
  • [Feature] Export to XML
  • [Feature] Engine: add run listener to be notified about the current row exported
  • [Feature] Update integration demo : hints for dependent parameters and default parameter values, chart demo
  • [Feature] ProgressBar on Next splash screen
  • [Improvement] Calendar in user interface allows for hour & minute selection.
  • [Improvement] Redesign menu & toolbar actions. Only one Save and Save As actions (will save query, report or chart, depending on what was created/opened).
  • [Improvement] Stop Run Report and Stop Preview Chart actions: only one message will be visible to the user.
  • [Improvement] Update oracle driver to 11.1.0.7 with better support for statement cancel.
  • [Improvement] Update mssql  driver to 1.2.5
  • [Improvement] Oracle Tns Name will show databases in a combobox (if tnsnames.ora file is found and no exception is thrown)
  • [Improvement] Import&Export : remind last selected folder for further imports/exports.
  • [BugFix] Html Exporter:A report with a cell with rowSpan>1 and colSpan= will have the row after that cell on the same line.
  • [BugFix] For parameter of type Time or Timestamp, user interface shows a TextField. Should show a calendar.
  • [BugFix] Alias for a column with a 'group by' function is not restored when the query is opened.
  • [BugFix] GroupBy after drag&drop columns with SHIFT key pressed does not change the selection in user interface (if output property is false)
  • [BugFix] Cannot open a report with an invalid query (a table from the designer has been renamed or deleted)
  • [BugFix] Incorrect test for loading a newer report from an older engine.
  • [BugFix] Count Distinct for Integer values does not work.
  • [BugFix] Oracle Tns Name value is not seen updated in Settings panel.
  • [BugFix] QueryExecutor - jdbc driver errors : If driver throws other exception than SqlException, the application remains blocked with the glass pane
  • [BugFix] Pdf "header on every page" does not take into account row and column spans (Update iText library).
  • [BugFix] Query Editor: Search Replace with characters that are special for regular expressions does not work.
  • [BugFix] Export query, report, chart : create destination folders path if it is not found.
  • [BugFix] Auto-Join for a foreign key will fail if the table with the primary key is in a different schema than the first table.

02.12.2009 version 2.4

  • [Feature] Added version 2.1.7 of iText with support for rowSpan and colSpan in PDF and RTF
  • [Feature] Added support for Firebird database
  • [Feature] A parameter with manual source allows for values sort after id or after name
  • [Feature] When export from report layout panel, user is allowed now to select a number of records (to see faster how the report looks)
  • [Feature] User is allowed to export the current report using other datasource than the one on which it was created (useful for test & production databases with the same structure)
  • [Feature] Parameters have support for default values (by default selected in user interface at runtime)
  • [Feature] Parameters can be "hidden". That means the user cannot see them and their default values are computed and replaced when the report is runned
  • [Feature] User can see in real time the number of records exported
  • [Feature] A ruler can be seen in report layout panel if user customize the columns size
  • [Feature] New settings : ruler visibility and ruler unit measure
  • [Feature] New setting : The cvs delimiter can be modified from Settings.
  • [Feature] Pdf export : at runtime user can set to see the report header rows on every page.
  • [Feature] Bulk column resize
  • [Feature] Delete, CTRL-C, CTRL-X, CTRL-V shortcuts for Delete, Copy, Cut Paste in report layout
  • [Feature] Layout selection with the mouse can be done in any direction (not only from top-left to bottom-right)
  • [Feature] Layout selection can be done also with SHIFT pressed and arrow keys
  • [Feature] Cut/Copy group of cells (matrix) in the report layout
  • [Feature] Publish report to NextReports server
  • [Feature] Download report from NextReports server
  • [Feature] New property 'Wrap text' for cell (has meaning for Excel, Pdf and Html)
  • [Feature] New property 'Hide repeated value' for cell (has meaning for any column cell from band detail)
  • [Feature] Add metadata to excel, html, pdf and rtf exported files
  • [Improvement] Dialect for supported databases is improved.
  • [Improvement] CTRL & mouse selection in report layout is improved. (for CTRL pressed, drag is ignored)
  • [Improvement] Because a dialect is needed for every type of database, only the supported ones can be used to create data sources
  • [Improvement] Copy to disk & Copy from disk actions select by default the output folder with datasources
  • [Improvement] The total number of records computation is improved.
  • [Improvement] Parameters properties are organized  by meaning
  • [Improvement] Settings properties are organised by meaning
  • [Improvement] Open the generated exported file do not block the application anymore.
  • [Improvement] Insert and Delete rows, columns are done on the grid headers, not on selected cell
  • [Improvement] User is notified if the current connection is invalid.
  • [Improvement] Export Data Source : allow for overwrite the data source file
  • [Improvement] ComboBox in any layout editor cell has a popup which allows to see the names despite their length
  • [Improvement] The names of queries, reports and folders can contain any character except \ / : * ? " | % (and they cannot start with space or .)
  • [Improvement] Unmerge cell(s) works now on multiple selection
  • [Improvement] Insert columns & rows : the number spinner was replaced with a text field and the user is notified if he introduces more than allowed
  • [BugFix] Saving query of an opened report duplicates the object in tree, or may overwrite an existing query with the same name without notice
  • [BugFix] HTML export for a report with a row span on the cells on the first column does not create a new row in html
  • [BugFix] Rtf Export for reports with row span > 1 has erroneous position for cells
  • [BugFix] ExitAction cancel button does not work. The application still exits.
  • [BugFix] Store Procedure call for some databases does not work
  • [BugFix] Export to pdf : an empty row has no default height
  • [BugFix] Export to pdf : if no padding is set the row text is cut by border
  • [BugFix] MySql : could not create a report from a query with different columns with the same name, even if we used aliases
  • [BugFix] Data Source rename : could not rename a data source with a name with the same text but different upper/lower letters
  • [BugFix] Close application: When a newly created and not saved report is in the layout and we press close (or exit) and we select close from the save panel, the application still exits and the report changes are lost
  • [BugFix] After we modify the property for more than one selected cells, only the first cell remains selected
  • [BugFix] Report Layout editors where not removed when we opened a new report or when we delete a row or a column


07.01.2009 version 2.3

  • [Feature] A new action Extract Template from current report
  • [Feature] User can add functions now in the footer band (not only in the group bands)
  • [Feature] Vertical allignment for cell
  • [Feature] A new Settings action to modify properties from nextreports.properties file from application
  • [Feature] Validation for a single procedure
  • [Feature] Column resize in report layout. The user can work now with auto size or manual size.
  • [Feature] A new property in configuration file : A4.warning to notify user if report layout width is bigger than A4
  • [Improvement] Update excel export using a new poi api version 3.2
  • [Improvement] Paste in the layout can be done now for multiple cells and for any kind of cell (not just for empty cells)
  • [Improvement] Bulk delete for rows and bulk delete for columns
  • [Improvement] Import from an old version : the properties from nextreports.properties configuration file are also imported
  • [Improvement] A new docking api version.
  • [Improvement] After importing a license, if it is valid the application will not need a restart.
  • [Improvement] On any export action, the application is now blocked also before showing the runtime parameters panel
  • [BugFix] Save As Report overwrite report was not allowed
  • [BugFix] Rename Query & Rename Report : name was not shown in the input text field
  • [BugFix] Functions with the same name where overwritten with the first function value
  • [BugFix] Values for parameter with manual select source were ordered by id.
  • [BugFix] Importing a license with a different name than license.dat was not working.
  • [BugFix] GroupBy for columns with output set to false was not working in all the situations.
  • [BugFix] Custom pattern for cell was erroneous shown for date and time categories.
  • [BugFix] An empty report (without any column or row) could be saved in previously versions, but cannot be saved anymore.
  • [BugFix] Mouse Right Click on a report node modified the current path
  • [BugFix] Excel color support was erroneous for some light colors
  • [BugFix] Report without header rows could not be loaded

04.30.2009 version 2.2

  • [Feature] Folder creation for Queries and Reports
  • [Feature] Drag&Drop for queries, reports and folders : move with the mouse, copy with the mouse and CTRL pressed
  • [Feature] Html accessibility properties : scope, id , headers (508 compliance)
  • [Feature] Show stored procedures in explorer tree
  • [Feature] Queries with stored procedure call
  • [Feature] Drag&Drop for procedures from explorer tree to query editor
  • [Feature] New Action "Validate Procedures" which will mark which stored procedures are candidates for reporting
  • [Feature] New field 'previewValue' for stored procedure parameter
  • [Feature] Copy query to disk & Copy report to disk
  • [Feature] New Oracle - Service template  for data source driver
  • [Feature] New Oracle - Tns Name template for data source driver - if you have an Oracle client installed on the same machine and you specify the path to tnsnames.ora file in next-reports.properties, you can use the database name from that file in the url
  • [Improvement] Show the opened query or report in the title application bar
  • [Improvement] Show success message for Copy query from disk, Copy report from disk, Backup and Restore
  • [Improvement] Query and report are added in explorer tree to their alphabetically sort position
  • [Improvement] Refresh action on explorer tree does also a refresh on tables, views and procedures (not just on queries and reports)
  • [Bug Fix] User was allowed to add null parameter to criteria
  • [Bug Fix] Cannot delete an expression with a function
  • [Bug Fix] Adding criteria to an expression was not possible in some circumstances
  • [Bug Fix] Sort type in criteria was saved different for different languages
  • [Bug Fix] Executed query does not contain comments anymore (before that commented parameters were shown at runtime)
  • [Bug Fix] Query and report name cannot contain other characters than letters and digits

03.19.2009 version 2.1

  • [Feature] Quick Start screen & Show at start up functionality
  • [Feature] New action Tools/Import : import data sources, queries and reports from an older version
  • [Feature] New action Tools/Reset layout : restores docking layout to default
  • [Feature] New action Apply Template : apply template on any loaded report
  • [Feature] New action Help/Tutorial
  • [Feature] New action Help/Manual
  • [Feature] Run query directly from query designer panel (not only from query editor panel)
  • [Feature] Report export directly from explorer tree
  • [Feature] RTF export
  • [Feature] Support for 'or criteria' in designer
  • [Feature] Undo/Redo for report layout actions
  • [Improvement] Ask for 'save query' or 'save report' only if some modifications occurred
  • [Improvement] Wizard : visually select default report templates
  • [Improvement] Wizard : ask for saving the created report
  • [Improvement] A new version of iText (2.1.5) which brings performance improvements for generating PDF  and RTF
  • [Bug Fix] Deselect 'Group by' only if the column is not in the select (output=false)
  • [Bug Fix] Designer columns drag&drop for joins (keep the selection in the table from where the column is dragged)
  • [Bug Fix] LIKE operator : for parameter value the character ' was duplicated
  • [Bug Fix] IN operator : for parameter value the characters ( and  ) were duplicated
  • [Bug Fix] '>=' and '' and '<'
  • [Bug Fix] The use of the same table more than once in the designer was not allowed
  • [Bug Fix] PDF & HTML fonts where not used correctly (new property 'font.directories' inside next-reports.properties)
  • [Bug Fix] Change Language : some strings where not changed for a specific locale
  • [Bug Fix] Create report with columns with same name from different tables : force user to use aliases
  • [Bug Fix] Remove column from layout did not work if empty cells where not shown in explorer tree
  • [Bug Fix] Actions in menu bar or toolbar that cannot be performed at a specific moment, were not disabled
  • [Bug Fix] SaveReport Action : report was saved even for cancel (if tried to save with a name of another existing report)
  • [Bug Fix] Layout : cell editing was started on any key pressed. Move with arrow keys was not possible
  • [Bug Fix] Wizard, select query step, changing between radio buttons did not clear the state of previous selection resulting in a an erroneous column selection

NextReports Designer Links

Share

Follow NextReports on Twitter