Report and Dashboard Server - Docker Image and New Data Source Options - Early Access Preview (v19.2)

Reporting Team Blog
27 August 2019

If you are an active Report and Dashboard Server subscriber and would like to test upcoming v19.2 features prior to official release, you can download the early access preview build from the DevExpress Download Manager and test the features described in this blog post.

Your feedback matters – should you have any questions regarding these new features or need technical assistance, please submit your comments below.

Report and Dashboard Server Docker Image

We currently use a Dockerized version of Report and Dashboard Server for internal testing. We decided to release this Docker image as part of our general distribution. Feel free to experiment with our containerized version and determine whether you’d like to deploy Report and Dashboard Server in a container.

Both the image and associated instructions are available on Docker Hub.

Feedback

Bind Reports and Dashboards to JSON Web Services

You can now create a JSON Data Model, specify its parameters, and use it within our data source wizards:

Create JSON Data Model

Feedback

Bind Dashboards to OLAP Cubes

You can now create an OLAP Data Model, point it to a specific OLAP cube and use the Dashboard Data Source Wizard to bind dashboard items to OLAP cubes:

Create OLAP Data Model

Bind a Dashboard to OLAP Cube

Feedback

Export Documents Using the Web API Method Calls

We’ve extended the Report And Dashboard Server’s Web API methods and now allow you to trigger document export operations and generate resulting files. Here are some examples:

  1. How to get a scheduled job result:
> POST /api/jobs/results
> Content-Type: application/json
> Authorization : Bearer <oauth-token>
>
> {  
>     id:32,
>     exportOptions:
>     {   
>         exportFormat:"pdf"
>     }
> }
	
< HTTP/1.1 200 OK
< Content-Type: application/pdf
< Content-Disposition: attachment; filename=document.pdf

  1. How to export a dashboard to an image:
> POST /api/dashboards/export
> Content-Type: application/json
> Authorization : Bearer <oauth-token>
>
> {
>    id:5,
>    exportOptions:
>    {
>       exportFormat:"image",
>       format:"jpeg"
>    },
>    documentParameters:
>    [
>    	{
>   	   name:"dashboardParameter",
> 	   value:5
> 	}
>    ]
> }

< HTTP/1.1 200 OK
< Content-Type: image/jpeg
< Content-Disposition: attachment; filename=dashboard.jpeg
  1. How to export a report to PDF:
  • Start an export task:
> POST /api/reports/export
> Content-Type: application/json
> Authorization : Bearer <oauth-token>
>
> {
>    id:10,
>    exportOptions:
>    {
>    	exportFormat:"pdf"
>    },
>    documentParameters:
>    [
> 	{
>   	   name:"CustomerID",
> 	   value:15
> 	}
>    ]
> }

< HTTP/1.1 200 OK
< Content-Type: application/json; charset=utf-8
<
< {
<    "exportId": "l39b47e1d8dd4d1a80303ae84da8rab9"
< }
  • Get an export task status:
> GET api/documents/l39b47e1d8dd4d1a80303ae84da8rab9/export
> Authorization : Bearer <oauth-token>

< HTTP/1.1 200 OK
<
< "Complete"
  • Download an exported document:
> GET /api/documents/l39b47e1d8dd4d1a80303ae84da8rab9/export/download
> Authorization : Bearer <oauth-token>

< HTTP/1.1 200 OK
< Content-Type: application/pdf
< Content-Disposition: attachment; filename=report.pdf
NOTE: Early Access and CTP builds are provided solely for early testing purposes and are not ready for production use. This build can be installed side by side with other major versions of DevExpress products. Please backup your project and other important data before installing Early Access and CTP builds.
Jacek Kosiński
Jacek Kosiński
Did you plan Linux version of image?
27 August, 2019
Dmitry Tok (DevExpress Support)
Dmitry Tok (DevExpress Support)

Hi Jacek,

We are unlikely to offer Linux-based images in v19.2, but we may do so in the future based on our customers' demand, which we are currently evaluating.

We encourage everyone who's interested in the containerized Report & Dashboard Server deployment to post a comment here or e-mail us at reportingteam@devexpress.com so that we can determine your requirements.

I'd be more than happy to further discuss this topic with you, so do not hesitate to send us an e-mail describing your environment and the use case.

28 August, 2019
David Crumb
David Crumb

Excellent news!  Thank you for all your hard work on this!

--Dave

28 August, 2019

Please login or register to post comments.