Charts in ReportServer

ReportServer (EN)
1

Hi,

as we have received many questions on charting capabilities in ReportServer, pls. note the following:

you can create graphical reports such as bar, pie charts in both pivot reports and mondrian reports. These are highly dynamic reports.

BIRT, Jasper, Excel and Crystal Reports also support charts.

You can see examples of a Saiku / BIRT / Jasper Reports in the online demo: https://reportserver.net/de/demo/

user: demoadmin
password: demoadmin

Saiku and Pivot reports are highly dynamic reports. With just a click, you can create different types of charts for the same report. As an example, check the following representations of the same report:









Pivot Report charts are analogous.

Here you can see two examples of a bar chart in a BIRT report: http://demo.raas.datenwerke.net/?locale=en#reportexec/uuid:f24c0277-6616-454f-917b-845846801178 and http://demo.raas.datenwerke.net/?locale=en#reportexec/uuid:6353c374-d43b-4e71-bf5a-cff0b2c46f52


Here an example of a pie chart in a Jasper report: http://demo.raas.datenwerke.net/?locale=en#reportexec/uuid:935406c1-4d39-4eda-ab35-0738a7bc539f

You can create even maps/ almost type of chart report with script reports:
http://demo.raas.datenwerke.net/?locale=en#reportexec/uuid:16d69439-6f56-4f8e-b1be-9eacb14f243a

Script reports also allow you to create charts easily. These are highly customizable, as you control the charting libraries directly.
We added a Highchart example (Script report) here:
https://github.com/infofabrik/reportserver-samples/tree/main/src/net/datenwerke/rs/samples/charts/highcharts/

You can find the chart here:
Highchart example

We added a D3 example (Script report) here:
https://github.com/infofabrik/reportserver-samples/tree/main/src/net/datenwerke/rs/samples/charts/radialtree/

You can find the chart here:
D3 example

You can also render DOT graphs to SVG and display them in your browser as shown in the following example:
https://github.com/infofabrik/reportserver-samples/blob/main/src/net/datenwerke/rs/samples/admin/svg/scriptreport

You can find the result here:
DOT example

Further, you can also use JXLS Templates to create Excel charts (JXLS Reports or JXLS Template for dynamic list). An example can be found here: https://github.com/infofabrik/reportserver-samples/tree/main/src/net/datenwerke/rs/samples/templates/jxls/jxlsreports (chart.xlsx and chart_result.xlsx). Thanks @Johann for this example:

More information on:
Jasper: https://reportserver.net/en/guides/admin/chapters/JasperReports/
BIRT: https://reportserver.net/en/guides/admin/chapters/Eclipse-Birt/
Pivot: https://reportserver.net/en/guides/user/chapters/Pivot-Mode-of-the-Dynamic-List/
Saiku / Mondrian: https://reportserver.net/en/guides/admin/chapters/Saiku—Mondrian-Reports/
Script: https://reportserver.net/en/guides/script/chapters/Script-Reporting/
Excel: https://reportserver.net/en/guides/admin/chapters/JXLS-Reports/

Your ReportServer Team

2

May I clarify how exactly can this be done and if there is any documentation we can refer to for instructions and/or examples? I’ve looked at https://reportserver.net/en/guides/admin/chapters/JXLS-Reports/ but cannot seem to find a section on charts. Any advise would be appreciated, thank you!

3

Hi Johann,

this should work in an analogous way as standard excel charting. Pls check the excel documentation on this and also the jxls documentation: http://jxls.sourceforge.net/

you are of course welcome to contribute with an example in the github if this works for you.

Regards,
Eduardo

4

Hi Eduardo,

Right, thank you! If I would like to contribute with an example, do I make a pull request on the Github repo (https://github.com/infofabrik/reportserver)? Sorry I am not too familiar with contributing procedures.

5

Hi Johann,

yes, you can create a pull request. For examples, you can use this repo: https://github.com/infofabrik/reportserver-samples

Regards,
Eduardo

6

Got it, thank you Eduardo!

7

Hi Johann,

many thanks for your contribution. I merged your pull request, made minor modifications (version number, instructions, last-tested version) and pushed the example into the jxls-examples repository: https://github.com/infofabrik/reportserver-samples/tree/main/src/net/datenwerke/rs/samples/templates/jxls/jxlsreports (chart.xlsx and chart_result.xslx). I also created this ticket for next reportserver release:
RS-5902: Add JXLS charting example
for letting the users know about the new charting example.
Again, thanks for creating this example and the pull request.

Regards,
Eduardo

8

Hi Eduardo,

Thank you for merging my pull request! It is my pleasure to contribute, and I hope it will help others who are working with JXLS charts too.

Just curious, where can the ticket be viewed?

Regards,
Johann

9

Hi Johan,

the implemented / fixed tickets can be seen in the release notes of the versions.
The open tickets are not publicly available, they are located in our internal ticketing system.

Regards,
Eduardo

10

Hi Eduardo,

I see, thank you for clarifying!

Regards,
Johann

11

Hi,

note that we added a D3 example chart to the list above.

Regards,
Eduardo

12

Hi,

note that we added a DOT graph (SVG) example to the list above.

Regards,
Eduardo