ReportServer Forum

mohamad

Member

Registered: 2019-05-12

Charts( Bar charts, Pie charts , ...)

Dear Experts,
I want to use Report Server Community for another open source software (ProcessMaker).
I managed to connect ProcessMaker's DB to Report Server. However, I'm beginner in Report Server, I am trying to make some graphical reports such as bar charts, pie charts and etc.
Unfortunately, I could not do it by now, Is it possible in community to do that? and If it is possible, how can I do that?
I was wondering if you could help me to solve my issue.
Looking forward to your comments
Kind Regards

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Charts( Bar charts, Pie charts , ...)

Hi mohamad,

you can create graphical reports such as bar, pie charts in both pivot reports and mondrian reports. These 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 … 5846801178 and http://demo.raas.datenwerke.net/?locale … f0b2c46f52

Here an example of a pie chart in a Jasper report: http://demo.raas.datenwerke.net/?locale … 38a7bc539f

You can create even maps/ almost type of chart report with script reports:
http://demo.raas.datenwerke.net/?locale … acb14f243a

Further, you can also use the JXLS Templates to create Excel charts.
More information on:
Jasper: https://reportserver.net/en/guides/admi … erReports/
BIRT: https://reportserver.net/en/guides/admi … ipse-Birt/
Pivot: https://reportserver.net/en/guides/user … amic-List/
Saiku / Mondrian: https://reportserver.net/en/guides/admi … n-Reports/
Script: https://reportserver.net/en/guides/scri … Reporting/
Excel: https://reportserver.net/en/guides/admi … S-Reports/

Regards,
Eduardo

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Charts( Bar charts, Pie charts , ...)

Hi mohamad,

in community edition you have Jasper, Mondrian / Saiku, BIRT and Excel Reports, so all screenshots above apply. Only script reports and pivot reports are not available. You can use the Enterprise Evaluation Edition if you want to check all other types. A comparison is found here: https://reportserver.net/en/pricing/
(scroll down for a detailed comparison)

Regards,
Eduardo

mohamad

Member

Registered: 2019-05-12

Re: Charts( Bar charts, Pie charts , ...)

Thanks for detailed and kind reply
So, to check my comprehension out of your words, you mentioned that, in Community Edition I can not have charts, unless I use another program like Jasper or BIRT?
I passed considerable time to figure out how to create charts, and I could not find any menu for that!
If I am wrong would you please help me?
Kind Regards

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Charts( Bar charts, Pie charts , ...)

Hi mahamad,

in community you do have charts!

You have Jasper, Mondrian / Saiku, BIRT and Excel Reports, so all screenshots are available.

Only script and pivot reports are not available in community.

Regards,
Eduardo

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Charts( Bar charts, Pie charts , ...)

Hi mahamad,

pls note we added a Highchart example (Script report) here:
https://github.com/infofabrik/reportser … ighcharts/

You can find the chart here:

Regards,
Eduardo

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Charts( Bar charts, Pie charts , ...)

Hi mahamad,

note that more examples can be found here: https://forum.reportserver.net/viewtopic.php?id=2704

Regards,
Eduardo