Release Notes for ReportServer 5.0.0

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

• Some Important Features and Noteworthy Improvements
• Java 21 or later required
• MySQL 5 No Longer Supported as RS Metadata DB
• Add Configuration Reload Button to Tools menu
• Syntax highlighting in markdown code
• Allow to configure strictHostKeyChecking
• Add TeamSpaces to user information window with role details
• JasperReports Version Display in System Console
• File and query edit popups - maximized by default with resize options
• Allow to configure OAuth2 datasink redirect URI
• Allow to copy General Info data easily to clipboard
• Added "job" Variable for Scheduled Script Datasinks
• Added Clear Filters Button in Scheduled Reports Overview
• New Features, Improvements and Bug Fixes for RS5.0.0

Some Important Features and Noteworthy Improvements for ReportServer RS5.0.0

Java 21 or later required

IMPORTANT

With the release of ReportServer 5.0, Java 21 or later is required. Older Java versions are no longer compatible, as ReportServer has been updated to leverage the latest features and improvements.

Users must upgrade their Java runtime to Java 21 or newer before deploying ReportServer 5.0. Running it on an earlier Java version is not possible.

MySQL 5 No Longer Supported as RS Metadata DB

IMPORTANT

The previously used MySQL 5 driver has been replaced with a newer version, as MySQL 5 itself reached End-of-Life (EOL) in October 2023. Continuing to support MySQL 5 as an RS Metadata DB is no longer viable. As a result, MySQL 5 is no longer supported for use as an RS Metadata DB. Users who still wish to use MySQL 5 as a datasource can manually download and install the old driver. However, it is important to note that the old driver can only be used for datasources and is no longer supported for the RS Metadata DB itself.

Add Configuration Reload Button to Tools menu

A new option has been added to the Tools dropdown menu, allowing users to reload the configuration directly from the interface. This eliminates the need to manually enter the reload command in the console, streamlining the process for easier and more efficient configuration management.

Syntax highlighting in markdown code

The syntax of Markdown code is now highlighted, as illustrated in the screenshot below. Additionally, a "copy" button has been added to facilitate easy clipboard copying of the code.

For enabling code highlighting, use the standard Markdown syntax, e.g. for Groovy:

```groovy
	... your groovy code ...
```

Allow to configure strictHostKeyChecking

ReportServer now allows you to configure strictHostKeyChecking globally for all SFTP and SCP datasinks via the /security/misc.cf configuration file. Additionally, this setting can be overridden on a per-datasink basis by specifying it explicitly for individual datasinks within the configuration. This allows for flexibility in cases where certain connections require different handling.

The default setting is "true", which is recommended for production environments. This ensures a higher level of security by verifying the host key before establishing a connection, preventing man-in-the-middle attacks. Changing this setting to "false" should only be done if you fully understand the implications, as it can expose your system to security risks, such as unauthorized access or data interception.

The complete /security/misc.cf configuration file is shown below.

Add TeamSpaces to user information window with role details

The user information window now displays the TeamSpaces a user is part of, providing better visibility and easier access to TeamSpace memberships. For each TeamSpace, the user’s assigned role (e.g., Manager, User) is shown next to it.

JasperReports Version Display in System Console

The JasperReports version is now included in the "General Info" section of the System Console, providing quick access to this information directly within the System Console.

File and query edit popups - maximized by default with resize options

The file and query edit popups now open in a maximized state by default. Additionally, they include buttons to restore its original size and toggle between collapsed and maximized views (see next screenshots).

Allow to configure OAuth2 datasink redirect URI

The redirect URI for OAuth2-authenticated datasinks (e.g., Dropbox, OneDrive – SharePoint (O365), Google Drive, Box) can now be configured in the datasinks/datasink.cf configuration file. If no custom URI is specified, the system will use the default URI, just like in previous ReportServer versions.

Allow to copy General Info data easily to clipboard

The contents of the General Info system panel can now be easily copied to the clipboard for further analysis. Please refer to the screenshot below.

Added "job" Variable for Scheduled Script Datasinks

When a script datasink is scheduled, the new job variable provides access to the corresponding scheduler job instance, which is an instance of ReportExecuteJob.

The following example demonstrates how to retrieve the list of job recipients and include them in the email content:

package net.datenwerke.rs.samples.tools.email

import net.datenwerke.rs.core.service.mail.MailBuilderFactory
import net.datenwerke.rs.core.service.mail.MailService
import net.datenwerke.security.service.usermanager.UserManagerService
import net.datenwerke.rs.utils.misc.MimeUtils
import net.datenwerke.rs.core.service.mail.SimpleAttachment
import java.nio.file.Paths
import java.time.LocalDateTime

def mailBuilder = GLOBALS.getInstance(MailBuilderFactory)
def mailService = GLOBALS.getInstance(MailService)
def userService = GLOBALS.getInstance(UserManagerService)
def mimeUtils = GLOBALS.getInstance(MimeUtils)

// the user ids. They have to exist and the ids are passed as long (L)
def to = [123L]
def subject = 'Script datasink'
def content = "ReportServer script datasink ${LocalDateTime.now()} job recipients ${job.recipients}"
// name of the zip
def attachmentFilename = 'data.zip'

def attachments = [
   new SimpleAttachment(data, // you can also use report
   mimeUtils.getMimeTypeByExtension(datasinkConfiguration.filename),
   datasinkConfiguration.filename),
   // add the script
   new SimpleAttachment(script.data, script.contentType, script.name) 
]

def mail = mailBuilder.create(
      subject,
      content,
      to.collect{userId -> userService.getNodeById(userId)})
      .withAttachments(attachments)
      .withZippedAttachments(attachmentFilename)
      .build()

mailService.sendMail mail

Added Clear Filters Button in Scheduled Reports Overview

A new button has been added to the Scheduled Reports interface, allowing users to clear all applied filters with a single click.

New Features, Improvements and Bug Fixes for ReportServer RS5.0.0