Release Notes for ReportServer 3.1.0

These release notes reflect the changes with respect to ReportServer 3.0.8.

Some Important Features and Noteworthy Improvements for ReportServer RS3.1.0

JXLS2 Support

ReportServer 3.1.0 supports JXLS2 reports and templates together with the legacy JXLS1. This means that you can decide which version you want to use. You can even use both versions together. This flexibility should help you with your JXLS migration: you can leave all your existing reports in the legacy JXLS1 version, while you create new reports with the JXLS2 version.

As you can see in the following screenshot, ReportServer 3.1.0 uses by default JXLS2. You can use JXLS1 by ticking the option "Use Legacy JXLS 1".

The same holds for JXLS1 and JXLS2 templates, as you can see in the following screenshot:

Amazon Redshift Support

Amazon Redshift is a fast, fully managed data warehouse that makes it simple and cost-effective to analyze all your data. It allows you to run complex analytic queries against petabytes of structured data.

ReportServer supports Amazon Redshift by its official JDBC driver As stated in the JDBC documentation, you have to obtain your JDBC URL from your AWS. An example URL is

jdbc:redshift://examplecluster.abc123xyz789.us-west-2.redshift.amazonaws.com:5439/dev

Google BigQuery Support

Google BigQuery is a serverless, highly-scalable, and cost-effective cloud data warehouse with an in-memory BI Engine and machine learning built in.

ReportServer 3.1.0 supports Google BigQuery datasources by the official Simba JDBC driver. Your URL should look similar to this:

jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId=MyBigQueryProject;OAuthType=0;OAuthServiceAcctEmail=bqtest1@data-driver- testing.iam.gserviceaccount.com;OAuthPvtKeyPath=/SecureFiles/ServiceKeyFile.json;

Teradata Support

Teradata is a fully scalable relational database management system produced by Teradata Corp. It is widely used to manage large data warehousing operations.

ReportServer 3.1.0 supports Teradata datasources by the official Teradata JDBC driver. Your URL should look similar to this:

jdbc:teradata://IP/DATABASE=myDatabase

Library Upgrades

The following libraries are upgraded in ReportServer 3.1.0:

Apache POI
upgraded to 4.1.0
JXLS2
upgraded to 2.6.0
BIRT
upgraded to 4.8.0
Jasper
upgraded to 6.9.0
UserAgentUtils
upgraded to 1.21

Exporting Parameters

The parameter export of dynamic lists was largely improved in ReportServer 3.1.0. For this, you can now set the following report properties:

Please note that these report properties are only available in Enterprise Edition.

If only "output_parameters" is true, then only the "real" parameters are being printed out, without separators, text, headers, etc.. If "output_complete_configuration" is set, EVERYTHING will be printed out. This includes user information, report information, report metadata, global variables, separators, headers, parameters, etc. With other words, everything that you can possibly include in the query.

Both "output_parameters" and "output_complete_configuration" take "output_include_hidden_parameters" into account. "output_include_hidden_parameters" controls whether hidden parameters are being exported (defaults to false).

For the following, "output_parameters" was set to true. In the first screenshot, you can see the Excel Export result. A new sheet "Parameters" is created and a list of parameters with their respective values is printed out:

For the HTML and PDF exports, this must be further configured in etc/dynamiclists/htmlexport.cf and pdfexport.cf, respectively, by using the variable ${parameterMapSimple}. As an example, refer to the following screenshot (pdfexport.cf):

You can see the result in the following screenshot. The parameters are printed in the specified position together with the dynamic list data in the exported PDF. The analogous configuration can be made for the HTML export.

New Features, Improvements and Bug Fixes for ReportServer RS3.1.0-6010

RS-2353New Feature Provide hook JxlsContextVariableProvider to adapt JXLSReport context
RS-3515New Feature Add explicit supported report properties to GUI
RS-3532New Feature Print server information in license dialog: java version, application server, operating system
RS-3542New Feature Print client information in license dialog: browser and browser version
RS-3549New Feature Add complex expressions ($X{IN, column, parameterkey}, etc) to list of default parameters in query
RS-3568New Feature Support Google BigQuery datasources
RS-3570New Feature Support Amazon Redshift datasources
RS-3574New Feature Support Teradata datasources
RS-3576New Feature Upgrade to POI 4.1.0
RS-3577New Feature Upgrade JXLS2 to 2.6.0
RS-3579New Feature Support JXLS2 reports
RS-3580New Feature Support JXLS2 templates for dynamic lists
RS-3588New Feature Upgrade to BIRT 4.8.0
RS-3592New Feature Upgrade to Jasper 6.9.0
RS-3616New Feature Allow to export dynamic list complete configuration to HTML / PDF / Excel Export
RS-3618New Feature "output_include_hidden_parameters" report property for controlling if hidden parameters should be included in the parameter output
RS-3621New Feature Include parameters as a table in dynamic list HTML / PDF export
RS-3626New Feature Output_complete_configuration should take output_include_hidden_parameters into account
RS-3649New Feature New Hooker VariantToBeEditedHook called just before the edits of an existing variant are being saved
RS-3652New Feature Allow SAIKU_CHART_HTML in output_format_auth report property for Saiku/Mondrian chart export
RS-3672New Feature Upgrade to UserAgentUtils 1.21
RS-2356Improvement Use user/password fields in XMLA Datasources instead of requiring to have them in the URL
RS-2410Improvement Correct spelling in HookHandlerService (dettach -> detach)
RS-3240Improvement Combine offset and order queries in MsSQL dynamic list reports
RS-3563Improvement Centralized enum for report properties in code
RS-3564Improvement Show password in Mondrian datasources as "***" analogously as in relational datasources
RS-3581Improvement Better template descriptions
RS-3586Improvement Isolate old jxls 1 and poi 3 libraries
RS-3597Improvement Trim microseconds and seconds from datetime parameter in dynamic lists
RS-3604Improvement Trim microseconds and seconds from time parameter in dynamic lists
RS-3605Improvement Trim time information from date parameter with "Date" mode in dynamic lists
RS-3607Improvement Trim date information from time parameter in dynamic lists
RS-3608Improvement Trim date parameter depending on mode in Jasper reports
RS-3609Improvement Trim date parameter depending on mode in BIRT reports
RS-3610Improvement Trim date parameter depending on mode in Crystal reports
RS-3611Improvement Trim date parameter depending on mode in JXLS reports and JXLS templates for dynamic list
RS-3614Improvement Output parameters into a separate sheet in dynamic list excel export
RS-3615Improvement Output only explicit parameters when "output_parameters" option is set and filter out separators
RS-3620Improvement Consolidate effective report property
RS-3625Improvement Hide parameters tab in Excel when parameters should not be shown
RS-3635Improvement Set table alias explicitly in (select *) in MsSQL dynamic list query
RS-3636Improvement Combine offset and order queries in MySQL dynamic list reports
RS-3639Improvement Combine offset and order queries in PostgreSQL dynamic list reports
RS-3640Improvement Combine offset and order queries in Oracle dynamic list reports
RS-3642Improvement Combine offset and order queries in Google BigQuery dynamic list reports
RS-3643Improvement Combine offset and order queries in Amazon Redshift dynamic list reports
RS-3654Improvement Allow to see parameter value changes in pivot report without having to reset the cube
RS-3444Bug The "MDX Editor" is not correctly hidden in some cases although it should be hidden
RS-3553Bug Report key included in query is not showing up in dynamic list report
RS-3562Bug "MDX Editor" / "Show MDX" buttons are not being correctly hidden if the checkbox "MDX Editor" is unchecked in pivot reports
RS-3569Bug Datetime parameter is not sending the time correctly in dynamic lists
RS-3587Bug Job owner can not be changed in new jobs
RS-3601Bug Time parameter is not sending the time correctly in dynamic lists
RS-3613Bug Importing a pivot report from teamspace into dashboard does not show report correctly
RS-3641Bug Parameter value is not set correctly for hidden parameters that other parameters depend on
RS-3645Bug ConstraintViolationException in dynamic list prefilters in some cases
RS-3651Bug Time is not showing when setting formula in datetime parameter
RS-3664Bug NPE while trying to trim empty date/datetime/time parameters
RS-3665Bug Error exporting from pivot mode
RS-3668Bug Excel Export error in pivot reports when the pivot report has both rows and columns
RS-3670Bug NPE in Opera License Administration page
RS-3686Bug Variables in Oracle Upgrade Skript are not being replaced correctly

New Features, Improvements and Bug Fixes for ReportServer RS3.1.0-6011

RS-3722Improvement Enable CodeMirror in file edit textfield in Internet Explorer
RS-3735Improvement Add POI4 commons-math3-3.6.1.jar dependency
RS-3736Improvement Remove old POI 3.11 libraries
RS-3737Improvement Upgrade to ooxml-schemas 1.4
RS-3738Improvement Add ooxml-security-1.1.jar library
RS-3680Bug Glitch in file edit textfield width in Internet Explorer
RS-3725Bug Lost password email does not show the parameter values in some languages
RS-3729Bug JXLS1 templates are not working in some cases
RS-3732Bug OutOfScopeException error while executing scheduled jobs in some cases

New Features, Improvements and Bug Fixes for ReportServer RS3.1.0-6015

RS-3740Bug POI 4 bug while shifting rows affects ReportServer JXLS templates

New Features, Improvements and Bug Fixes for ReportServer RS3.1.0-6016

RS-3761Improvement JXLS2 reports/templates for the dynamic list are not working with DynaBeans together with grouping
RS-3778Improvement Upgrade to JXLS2 2.7.1
RS-2556Bug Jasper subreport errors are not shown to the user
RS-3750Bug Mondrian elements (measures/columns/rows) are sometimes hidden from the GUI if MDX editor option is not set
RS-3751Bug NPE when resetting a mondrian report without having saved it previously as a variant
RS-3762Bug English language can not be removed from the UI
RS-3763Bug If language is not explicitly selected and no cookie is previously saved, locale cookie is saved always as english
RS-3768Bug JXLS2 reports/templates for the dynamic list are not working together with Excel formulas
RS-3770Bug Pivot/Mondrian reports throw error when sending them by email/to teamspace/to custom send-to or when exporting them if preview has not been activated before
RS-3771Bug OutOfScopeException when scheduling pivot / Mondrian reports
RS-3776Bug Pivot query is not being saved correctly in some cases
RS-3780Bug Some german translations are incorrect

New Features, Improvements and Bug Fixes for ReportServer RS3.1.0-6018

RS-3712Improvement Remove unnecessary jaxws-rt-2.2.7-promoted-b24.jar library
RS-3793Improvement Upgrade to JXLS2 2.7.2
RS-3808Improvement Remove unnecessary jaxws-api-2.2.8.jar library

New Features, Improvements and Bug Fixes for ReportServer RS3.1.0-6019

RS-3843Improvement Upgrade to ecj 4.4.2

New Features, Improvements and Bug Fixes for ReportServer RS3.1.0-6021

RS-3910Improvement When submitting values in a parameter dadget, only refresh the dadgets that use the given parameters
RS-3920Improvement Rename Dadget Library to Dashboard Library
RS-3904Bug LinkToEnhancer is not working correctly
RS-3909Bug No dadget write permissions should be necessary for using parameter dadget
RS-3914Bug "Import dashboard" dialog should only show dashboard elements
RS-3915Bug Dragging invalid objects should not be allowed in tree selection popup analogously as double-clicking them
RS-3916Bug Error message when importing more than one dashboard
RS-3918Bug Tree selection popup should remove DOM handlers when hiding

New Features, Improvements and Bug Fixes for ReportServer RS3.1.0-6023

RS-4119 New Feature Upgrade to PDF.js Version 2.3.200 (build: 4ae3f9fc)
RS-4188 New Feature Allow jxls2 reports to be configured to allow streaming
RS-4196 New Feature Allow to configure jxls2 report streaming parameters: jxls_stream_row_access_window_size, jxls_stream_compress_tmp_files, jxls_stream_use_shared_strings_table
RS-4214 New Feature Allow dynamic list jxls2 templates to be configured to allow streaming
RS-4222 New Feature Allow to configure dynamic list jxls2 template streaming parameters: jxls_stream_row_access_window_size, jxls_stream_compress_tmp_files, jxls_stream_use_shared_strings_table
RS-4186 Improvement Print VM arguments in license dialog
RS-4199 Improvement Disable HTML export in jxls2 report streaming
RS-4200 Improvement Avoid having the complete result in memory while creating the jxls2 report stream workbook
RS-4223 Improvement Avoid having the complete result in memory while creating the dynamic list jxls2 template stream workbook
RS-4224 Improvement Allow Java 8 syntax
RS-4226 Improvement Change DTO creation script compatibility to Java 8
RS-3367 Bug Grand totals are not showing in Excel Export of Pivot/Saiku reports if multiple grand totals are being exported at the same time
RS-3590 Bug Moving / renaming variants per terminal "mv" command is not working
RS-3902 Bug Templates are not sorted when exporting dynamic lists via template
RS-3946 Bug Permission checks on report's scheduler job list are not sufficient in some cases
RS-3952 Bug New lines are not displayed correctly in report documentation
RS-3967 Bug Jasper reports are not working together with script datasources if the database cache setting of the script datasource is 0
RS-3973 Bug BIRT reports are not working together with script datasources if the database cache setting of the script datasource is 0
RS-3997 Bug Some Saiku reports produce a stack overflow error because of Hibernate deep unproxy
RS-3999 Bug Incorrect report documentation's logo example in theme.cf configuration file
RS-4016 Bug Executing scheduler jobs is possible in some cases even though owners do not have rights on the report
RS-4018 Bug User Variables tab is not being kept open when switching users
RS-4027 Bug "mv" command is not allowing to use wildcards
RS-4028 Bug "cd" command is not allowing to jump inside a basic report
RS-4029 Bug "mv" command is not checking that target resolves to exactly one location
RS-4030 Bug "cp" command is not allowing to use wildcards
RS-4031 Bug Copying variants per terminal "cp" command is not working
RS-4032 Bug "mv" command should not be able to move variants to a location outside of a basic report
RS-4033 Bug "cp" command is not checking that target resolves to exactly one location
RS-4035 Bug "cp" command should not be able to copy variants to a location outside of a basic report
RS-4052 Bug Pasting computed columns leaves empty computed column type
RS-4055 Bug Grand total headings are not showing in Excel Export of Pivot/Saiku reports
RS-4059 Bug Default configuration should not export dynamic list parameters by default in the export html comment in PDF/HTML export
RS-4075 Bug Pasting computed columns does not ask for replacement if computed column with same name already exists
RS-4094 Bug Templates are not sorted when editing list of dynamic list templates
RS-4096 Bug redir parameter should not allow to redirect to external websites or execute javascript
RS-4102 Bug Open file leak during startup with translation files
RS-4104 Bug Open file leak while creating translation properties files
RS-4109 Bug Length of hibernate.connection.password should not be shown in the logs
RS-4115 Bug XXEs (XML External Entities) should be disabled in the import functionality
RS-4116 Bug Session ID is not being renewed when a user logs in
RS-4117 Bug pdf.js file parameter should not allow to load external content
RS-4120 Bug "Library Dadget" dialog should only show dadget elements
RS-4125 Bug Logo is not showing correctly on report documentation
RS-4150 Bug BIRT Excel export is not working when the report contains cross tabs
RS-4195 Bug Jxls2 report output generator is not closing output stream correctly
RS-4221 Bug Dynamic list jxls2 template output generator is not closing output stream correctly

New Features, Improvements and Bug Fixes for ReportServer RS3.1.0-6024

RS-4231 Improvement Jxls2 report streaming is not keeping template sheet name for results
RS-4232 Improvement Use the original template sheet for printing results in jxls2 report streaming
RS-4235 Improvement Use the original template sheet for printing results in dynamic list jxls2 template stream
RS-4236 Improvement Dynamic list jxls2 template stream is not keeping template sheet name for results
RS-4229 Bug HSQL connection test is not working
RS-4233 Bug Jxls2 report streaming does not allow more than one sheet containing jxls commands
RS-4234 Bug Jxls2 report streaming is showing hidden columns in result
RS-4237 Bug Dynamic list jxls2 template stream does not allow more than one sheet containing jxls commands
RS-4238 Bug Dynamic list jxls2 template stream is showing hidden columns in result

New Features, Improvements and Bug Fixes for ReportServer RS3.1.0-6028

RS-4047 New Feature Add new license types: "Corporate" and "Test / Dev" licenses
RS-4241 Improvement Allow logo customization in evaluation version
RS-4242 Improvement Automatic version file creation
RS-4261 Improvement Delete log files from src automatic generation
RS-4271 Improvement Complete and correct currency locales
RS-4259 Bug Open file leak in APIDOC creation
RS-4262 Bug Currency format is not correct in some cases
RS-4264 Bug Scheduled report filename should not contain ":" character
RS-4269 Bug Position of currency symbol is incorrect in some cases

New Features, Improvements and Bug Fixes for ReportServer RS3.1.0-6029

RS-4296 Bug Entries are not being found in the search if user performing the search does not have read permissions on the tree root
RS-4297 Bug Automatically selecting search result is not working when user does not have read permissions on the tree root
RS-4298 Bug "Expand all" button is not working when user does not have read permissions on the tree root

New Features, Improvements and Bug Fixes for ReportServer RS3.1.0-6031

RS-4457 New Feature Allow to disable session renewal
RS-4701 New Feature MariaDB support for pivot/Saiku reports
RS-4439 Improvement Upgrade to activation-1.1.1.jar
RS-4584 Improvement Perform redir check in server-side
RS-4626 Improvement Optimize maintainance queries
RS-3531 Bug HTML email is not working with Java 11
RS-3554 Bug Override metadata in variants when including it into datasource parameter query analogously as when this is included in the report query
RS-3555 Bug Override report internal properties in variants when including them into datasource parameter query analogously as when these are included in the report query
RS-3599 Bug Importing reports into TeamSpace always add "(copy)" into report's name
RS-3873 Bug Scheduler dialog should not allow job's end date to be before begin date
RS-4034 Bug mv and cp commands should check permissions on source objects
RS-4202 Bug Datasource parameters are not showing available parameters and expressions in menu
RS-4318 Bug Type mismatch: Condition to ReportConditionDto
RS-4402 Bug Login Bundles are not working together with Java 11
RS-4410 Bug Dadget height can not be set in the dadget library for some dadget types
RS-4412 Bug Refresh interval and height can not be set in dadget library when editing report dadgets
RS-4415 Bug Refresh interval and height can not be set in library dadgets correctly
RS-4416 Bug The incorrect refresh interval, name and height fields should not be shown in dadget library
RS-4498 Bug Paging is not actualizing correctly in grid reports when filtering
RS-4557 Bug Aggregations with grouped fields are not showing correctly in dynamic list Excel export
RS-4620 Bug Email date should be set in header explicitly

New Features, Improvements and Bug Fixes for ReportServer RS3.1.0-6039

RS-4769 Bug Parameters are not showing in dashboard for reports imported from TeamSpace as a reference
RS-4820 Bug Parameter dadget value is not applying for reports imported from TeamSpace as a reference
RS-4851 Bug Jxls1 is not working when the template contains merged cells in some cases

New Features, Improvements and Bug Fixes for ReportServer RS3.1.0-6041

RS-4782 Bug Excel export is not working in grid reports: NPE

New Features, Improvements and Bug Fixes for ReportServer RS3.1.0-6042

RS-4992 Bug Crystal reports: ClassNotFoundException LogManager
RS-4993 Bug Crystal report error: The process cannot access the file because it is being used by another process

New Features, Improvements and Bug Fixes for ReportServer RS3.1.0-6045

RS-5018 Improvement Hide DB password from Mondrian error messages
RS-5020 Improvement Better error message in "lost password" dialog if email is NULL
RS-3754 Bug Error in "search" window when clicking on any result category
RS-4325 Bug Calling reports per URL from within Javascript in HTML dadget is not working
RS-4827 Bug "allcolumns" setting is not working when exporting reports via URL for base reports when using inlinereport
RS-4853 Bug Blank spaces in terminal window are not showing correctly in some cases
RS-4980 Bug Search results are not showing correct report icons
RS-5005 Bug New lines are not showing correctly in terminal in HTML output
RS-5008 Bug Assigning and executing terminal command aliases is not working correctly
RS-5016 Bug Pivot reports are not working in case of MSSQL Server if JDBC URL contains MSSQL instance together with backslash separator
RS-5019 Bug NPE in "password lost" dialog if password is NULL
RS-5030 Bug Executing reports by URL is not working correctly in Community Edition
RS-5036 Bug "Test"-Button should not be shown in database bundles as it does not work for bundles
RS-5043 Bug Search result categories are not showing correctly in some cases
RS-5044 Bug Not all search categories are being shown if many categories are contained in the result list, as no scroll bar is visible
RS-5045 Bug Some DB-Bundle texts are not being shown correctly

New Features, Improvements and Bug Fixes for ReportServer RS3.1.0-6047

RS-5093 Improvement Delete unnecessary .gwt.xml files
RS-5056 Bug JXLS1 export is not always calculating formulas when opening sheet
RS-5060 Bug Inhibited users can log in
RS-5164 Bug Search is requiring permissions on admin areas but it also should accept read permissions on objects