Release Notes for ReportServer 3.0.3

These release notes reflect the changes with respect to ReportServer RS3.0.2-5855.

Some Important Features and Noteworthy Improvements

RS-2601New FeatureConfiguration protect in variants in order to allow a read-only report execution

It is now possible to protect your variants against unauthorized configuration. The new "configuration protect" checkbox prevents variants from being configured/changed, similar to the write protection. This is especially important for Pivot and Saiku reports because, depending on the configuration, a user can heavily stress the system.
There are already read rights to reports: Why are they not sufficient to prevent the configuration of a report? If the user has read-only access to a report, he/she can’t open it (by design), but can only view and list it. However, he/she can’t execute the report. For this purpose the execution right is necessary: If a user has the right to execute a report, he/she is able to open, configure and execute it.
In the Saiku case, this configuring steps can already make a strong use of the system. The write protection prevents the saving of the variant, nevertheless you can create already during the configuration very resource-consuming queries. With a new function "configuration protect" such problems are solved. Variants are thus protected from any changes / configurations. In this way, "read-only" variants can be created. This feature works analogously for inline reports.

RS-2687New FeatureNew "Information" Menu for Reports, Variants and Folders. Important information about the selected item is shown, e.g. the teamspaces where the selected report is present in.

If different variants with the same name exist in different TeamSpaces, it is not easy to find out where exactly this variants are saved. Obviously, they have different IDs, but they can not immediately provide information on which TeamSpace the variant is stored. To help users in this matter, a new "Information" window has been added. Right-click on the variant, select “Information” and the new window appears, where the user can see all TeamSpaces of the variant, among other information. This window is also available for reports and for directories.

RS-2542New FeatureReports sent per e-mail can now be compressed

If you want to send scheduled reports by e-mail, these can become very large. To prevent this, a compression option was introduced in the scheduling configuration window.

RS-2526ImprovementAdd the user property dashboard:primaryDashboard analogously to teamspace:primaryTeamspace in order to permit to override the primary dashboard of a user

The user has now the possibility to set his/her primary dashboard via GUI or throw the new UserProperty “dashboard:primaryDashboard”, which can also be set by an administrator.

New FeatureDB JSON and XML support

XML and JSON datatypes are now supported. Refer to Figure 8 as an example of a JSON string for the customer “Jim Silver” with two addresses. In order to get these addresses, we can use the query in Figure 9. We will post more examples in the blog, stay tuned.

RS-2684New FeatureSaiku upgrade to 3.8

The Saiku and Mondrian libraries were upgraded to 3.8 and 4.3.0.1., respectively. These are in most of the cases not backward compatible. This means the following:
- Pivot table variants: you have to create new variants, configure them, and save them again.
- Mondrian datasources: if your Mondrian XML schema is defined in reportserver, you shall upgrade the schema to version 4, i.e. it must contain:

 <Schema name="YourSchema" metamodelVersion="4.0">

More information here.

RS-2644New FeatureNew report property "output_format_default" in order to set the default report export format

The default export format of reports can now be set by users. For this we added a new report property “output_format_default”, where you can write the desired value, e.g. “PDF” or “CSV” (Figure 10).

RS-2527ImprovementMake Excel export configurable (XLS vs XLSX)

The support of .xls and .xlsx Excel-export formats are both now supported in Jasper anagously to BIRT and dynamic lists. The configuration file for this purpose can be found in /etc/exportfilemd/excelexport.cf.

<?xml version="1.0" encoding="UTF-8"?>
<configuration>
   <xls>
      <format>xlsx</format>
      <stream>true</stream>
   </xls>
</configuration>

RS-2518New FeatureNew CSV export configuration file: /etc/exportfilemd/csvexport.cf. The CSV export dialogs were also adapted to further customize this new configuration per export.

The file /etc/exportfilemd/csvexport.cf was introduced for customizing the CSV export, e.g. the separator. This configuration can be modified in a per-export matter, e.g. following sample configuration.

<?xml version="1.0" encoding="UTF-8"?>
<configuration>
   <csv>
      <printHeader>true</printHeader>
      <separator>;</separator>
	  <quote>"</quote>
	  <lineSeparator>\r\n</lineSeparator>
   </csv>
</configuration>

New Features, Improvements and Bug Fixes

RS-2518New FeatureNew CSV export configuration file: /etc/exportfilemd/csvexport.cf. The CSV export dialogs were also adapted to further customize this new configuration per export.
RS-2532New FeatureCSV export: newline configuration in Pivot/Saiku/Crystal reports
RS-2542New FeatureReports sent per e-mail can now be compressed
RS-2565New FeatureSupport for JSON/XML datatypes
RS-2568New FeatureGridReports: PostgreSQL JSON support
RS-2578New FeatureJasper/BIRT JSON support (PostgreSQL, MySQL, MSSQL)
RS-2579New FeatureGridreports: PostgreSQL XML support
RS-2581New FeatureJasper/BIRT XML support (PostgreSQL, MySQL, MSSQL)
RS-2582New FeatureMSSQL XML support
RS-2583New FeatureOracle XML support
RS-2601New FeatureConfiguration protect in variants in order to allow a read-only report execution
RS-2613New FeatureConfiguration protection in inline reports
RS-2633New FeatureOracle XML support
RS-2635New FeatureOracle JSON support
RS-2644New FeatureNew report property "output_format_default" in order to set the default report export format
RS-2684New FeatureSaiku upgrade to 3.8
RS-2687New FeatureNew "Information" Menu for Reports, Variants and Folders. Important information about the selected item is shown, e.g. the teamspaces where the selected report is present in.
RS-2683New FeatureReportServer translation to turkish
RS-2317ImprovementAllow (automated) generation of TeamSpaces without owner
RS-2320ImprovementBetter error message on script compilation errors
RS-2338ImprovementAllow setting parameter for dashboard via URL
RS-2345ImprovementHide Chart export formats from scheduler/sendto
RS-2346ImprovementTheming: improve styling of content panel headers
RS-2357ImprovementAllow to prioritize URLView modules in order to also move modules to the front of the module bar.
RS-2485ImprovementDisplay missing member error messages on saiku reports
RS-2490ImprovementRemove Saiku calls to Google Analytics
RS-2526ImprovementAdd the user property dashboard:primaryDashboard analogously to teamspace:primaryTeamspace in order to permit to override the primary dashboard of a user
RS-2527ImprovementMake Excel export configurable (XLS vs XLSX)
RS-2536ImprovementBetter portuguese translations
RS-2574ImprovementBlank spaces trim in user properties
RS-2584ImprovementGridReport: MSSQL tinyint support
RS-2606ImprovementJQuery upgrade to 3.2.1
RS-2607ImprovementJasper upgrade to 6.4.1
RS-2625ImprovementBetter Crystal CSV export
RS-2640ImprovementChanged mandatory fields in user profile. Name, username mandatory, rest not mandatory. Added "title" to "change user profile" window
RS-2654ImprovementLoading box shown in PDF reports (BIRT, Jasper, Crystal)
RS-2675ImprovementSaiku Pivot: Upgrade Schema to Mondrian 4
RS-2702ImprovementIncorrect translations corrected
RS-2724ImprovementEscape special characters in export filename
RS-2313BugPivotmode for demo datasource not working
RS-2315BugUser Variable definition windows are not correctly sized
RS-2316BugPermanent, unrecoverable error after removing TS root folder
RS-2335BugDenied report output formats can be selected in scheduler.
RS-2336BugScriptDatasources don't work in Pivot Mode
RS-2341BugGerman translation missing for users blocked by password policy
RS-2342BugPaging through Scheduler Jobs is unreliable under certain circumstances
RS-2343BugRevision Report on anything but dynamic lists does not work
RS-2344BugException when trying to edit a scheduler job with a no longer existing recipient
RS-2348BugTextparameters do not pickup width if height equals 1
RS-2363BugMissing xml plugin prevents BIRT to connect to webservice datasources
RS-2385BugScheduling into a Teamspace might fail if there is a high number of parallel jobs
RS-2436BugThe change password dialog should not allow to submit a new password if password and repeat are not matching
RS-2480BugParameter config not saved properly
RS-2486BugFix width of BirtDatasource in ParameterView
RS-2488BugSaiku reports on small screen with midsized result sets display wrongly sized scrollbars
RS-2491BugRemember MDX in Saiku Variants
RS-2496BugExport button starts export on drag event
RS-2498BugEmpty error message in scheduler dialog
RS-2501BugScheduler emails with attachment are always sent as html
RS-2504BugDatabase bundle with auto mapping is missing configuration field
RS-2505BugDatabase bundle with auto mapping does not support individual datasources in mapping
RS-2511BugUsers that are managers in more than one teamspace can only manage their default teamspace. For other teamspaces, they have to change their default teamspace and login again.
RS-2512BugHidden fields of grid editor are set to NULL when saving
RS-2513BugNVARCHAR datatype not supported in the grid editor report
RS-2514BugNPE in Grid Editors with DataBundles
RS-2515BugNCLOB is defined wrongly as a non-string type
RS-2519BugPermissions to Edit Scheduled Jobs from other users
RS-2520BugScheduler buttons "delete" and "archive" should only be shown in the admin panel for foreign jobs
RS-2521BugImprovement of error behaviour when user doesn't have permissions on teamspace, but has an assigned job (scheduler)
RS-2522BugScheduler: changing teamspace of job doesn't save correctly
RS-2523BugTeamSpace managers can select a higher role, e.g. Admin. This is not being saved.
RS-2528BugCrystal reports not working with Datasource bundles
RS-2529BugDatasource bundle: Crystal report selects wrong datasource in bundle
RS-2531BugIf configuration file (reportserver.properties) exists only in external directory: NPE error while trying to decrypt password (passphrase is empty)
RS-2533BugNPE in Crystal CSV export
RS-2535BugIf no explicit defaultTeamSpace value set, the value in the user profile is now empty
RS-2538BugISO-8859-2 characters in dynamic list pdf export
RS-2540BugIncorrect PDF/HTML export when exporting dynamic lists having aggregations
RS-2545BugDatasource parameter -> single selection -> dropdown: incorrect filter behaviour
RS-2546BugInline report execution view: layout window never disappears
RS-2547BugBug parsing comments (--comment) after the SQL query in dynamic lists / pivot reports
RS-2552BugInline report execution not working in some cases
RS-2558BugInline script report with parameter: 500 Internal Server Error
RS-2560BugCSV datasources with MSSQL
RS-2561BugBug in inline report execution with dependent script parameters
RS-2562BugInformix in dynamic lists
RS-2588BugSaiku 3.8: Sybase SQL Anywhere support
RS-2594BugDisplay bug in Month/Year windows
RS-2598BugSaiku: NPE in Grand Totals (Average)
RS-2610BugSaiku NVARCHAR/JSON support
RS-2619BugMemory Leak in StatementManagerServiceImpl
RS-2629BugSaiku CSV Export: bugs with "show headers" and "newline"
RS-2681BugCrossjoins order in Saiku: explicit right-to-left order. This corrects a pivot reports bug with more than 2 dimensions shown.
RS-2691BugBsiPasswordPolicy: Integer overflow when calculating when a locked account will be enabled again.
RS-2700BugDouble response header causing issue in Chrome
RS-2497BugTypo in Column Format Dialog (german)
RS-2711BugNPE when implementing SendToTargetProviderHook
RS-2664BugNPE if no value selected in Crystal optional parameters
RS-2759BugNPE when trying to save the user profile if the default teamspace is empty
RS-2764BugSaiku Reports saved temporarily in the session do not display correctly, e.g. charts in the dashboard
RS-2769BugPivot reports from a dynamic list do not work correctly: the preview is not shown correctly if the user is not a super user
RS-2770BugDashboard id is not correct in the UI
RS-2780BugPivot reports are not working in Windows with the demo data