ReportServer 3.0.8 is now available

We announce that the 3.0.8 version of ReportServer is now available for download!

Among others, the following new features are important:

Exporting Parameters

With ReportServer 3.0.8, report parameters can be exported together with the dynamic list reports. For this purpose, a new report property has been introduced: “output_parameters” ( true / false ). By setting this report property to “true”, the parameters will be automatically included in the Excel Export as shown in the following example:

Parameter configuration:

Excel Export:

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

Clearing Mondrian Data Cache

The Mondrian data cache can now be easily cleared with a new button in the datasource configuration dialog.

Default Parameters

We now made it much easier to include default parameters / global parameters / metadata parameters in the respective query window.

For a list of all changes please refer to the Release Notes. The upgrade guide is available in the documentation area.

Happy reporting!

 

ReportServer 3.0.7 is now available

We announce that the 3.0.7 version of ReportServer is now available for download!

Among others, the following new features are important:

Pivot-Report Export Schema to Mondrian

It was never so easy to create Mondrian schemas! Pivot reports can be now exported into Mondrian 3 and 4 formats with just a click. In such a way, these reports can help you for an easy and quick report design and analysis of your data, being at the same time flexible enough to be used in any other tool supporting Mondrian 3 or 4 formats. This of course includes ReportServer (Mondrian 4): you can create a Mondrian report using your exported schema without any further modification!

Pivot-Report MDX Editor and Query

MDX queries can be now directly edited and executed in pivot reports. This allows a maximum flexibility in fetching the exact data you need.

Mondrian Upgrade

The Mondrian library was upgraded from version 4.3.0.1 to 4.7.0.0-12.

For a list of all changes please refer to the Release Notes. The upgrade guide is available in the documentation area.

Happy reporting!

Adding a Color Picker as a Report Parameter

In this post, we would like to show you an example of how to add a javascript color picker as a report parameter, which can be then used as any other parameter in your SQL queries. This is the basis for further scripts we are posting here soon, so stay tuned!

We create a script parameter (https://reportserver.net/en/guides/admin/chapters/parameter-script/), since a script parameter allows you to write custom HTML and javascript.

For this purpose, download the latest jscolor javascript file from here: http://jscolor.com/. At the time of writing, the latest version was 2.0.5. Copy the downloaded jscolor.js file into this location: Fileserver Root/lib/jscolor/jscolor.js. Check in the ”Properties” tab the URL of this file in your installation. It should be something similar to: http://localhost:8080/reportserver/reportserver/fileServerAccess?id=2189950.

Now you can create the script which will be the basis of your script parameter. We name this script PalettePicker.groovy:

#html
<html>
  <head>
    <script type="text/javascript" src="http://localhost:8080/reportserver/reportserver/fileServerAccess?id=2189950"></script>
    <script type="text/javascript">
	var callback;

	function initParameter(param, cb){
		callback = cb;
		//alert("The current value is: " + param.defaultValue);
		document.getElementById("mycolor").value = param.defaultValue;
		document.getElementById("mycolor").style.backgroundColor = '#' + param.defaultValue;
		setValue(param.defaultValue);
	}

	function setValue(value){
		//alert("Updating the value to: " + value);
		callback(value);
	}

    </script>
  </head>
  <body>
    <input id="mycolor" class="jscolor" onchange="setValue(this.value);">
  </body>
</html>
As you can see in the script, you install a color picker and use the default value for setting the initial value and background color of the input field. The URL mentioned previously must be adapted to your configuration:
<script type="text/javascript" src="http://localhost:8080/reportserver/reportserver/fileServerAccess?id=2189950"></script>
Finally, you can create the script parameter in your report and set the script field to point to your PalettePicker.groovy script in your parameter’s ”Specific Properties” dialog. Set your parameter’s default value to e.g.: ”FF0000” (without apostrophes). You can now use the color picker’s value in your query as:
SELECT * FROM myTable where myField = ${mycolor}

Note that your parameter’s name must be set to ”mycolor” for using this query.

This approach works for virtually all javascript libraries. Script arguments are a powerful tool for extending ReportServer parameters to user-defined functionality.

Many thanks to Karolina Boboli for sending us this and allowing us to publish the script.

ReportServer needs your support

Dear ReportServer users,

the ReportServer team in InfoFabrik GmbH needs your support!
We would like to invite you to participate in The BI Survey 19, the world’s largest annual survey of business intelligence (BI) users.

BARC’s annual survey gathers input from thousands of organizations to analyze their buying decisions, implementation cycles and the benefits they achieve from using BI software.

As a participant, you will:

  • Receive a summary of the survey results when they are published
  • Be entered into a draw to win one of ten $50 Amazon vouchers
  • Ensure that your experiences are included in the final analyses

The BI Survey 19 should take about 15 minutes to complete and is for us and the ReportServer Community a great opportunity to increase the visibility of ReportServer. As a result, we will be able to incorporate your experiences and needs into the ReportServer development in a more significant manner in a near future.

The survey is available in the following link:
https://www.efs-survey.com/uc/BARC_GmbH/f42f/?a=69

Thank you in advance for your participation!

Your ReportServer Team

New OS X VM in our Bitnami packages

We have replaced our native OS X Bitnami installers with an equivalent OS X Virtual Machine (VM). The old OS X Bitnami installers will not be available as of version 3.0.5-4.
A ReportServer Bitnami OS X VM is a virtual machine (VM) that includes everything you need to run ReportServer on your OS X system. Once downloaded, you can launch it and immediately begin using ReportServer.

What is the difference between an OS X native Installer and an OS X VM?

  • An OS X native installer installs the ReportServer Bitnami application stack and all its components directly on your OS X system.
  • An OS X VM is a virtual machine for OS X. It includes all the components of the ReportServer Bitnami application stack in a Debian-based virtual machine that runs on your OS X system. It uses the OS X native virtualization so it is not necessary to install other virtualization software previously like VirtualBox or VMware.

The following ReportServer credentials are configured by default on the OS X VM:

Username: user
Password: bitnami

Further, we upgraded the following components in all our Bitnami packages:

  • MariaDB to 10.1.38
  • Tomcat to 9.0.16

You can download all our Bitnami packages from our downloads site: https://reportserver.net/en/download/

Happy reporting!

Your ReportServer Team

Sneak Preview 3.0.6

Work on our next release (3.0.6) is under way. We want to give you an overview of some important features that are ready and will be available with ReportServer 3.0.6, released in a couple of weeks:

  • Scheduling
  • The Conditional Scheduling
  • Object Resolver Query
  • Perfomance
  • Language support

Read more…