ReportServer Forum

rezarr

Member

Registered: 2018-11-08

very very newbie question :(

Just found out that i have to create a report reading data from a mySQL datastore and having to display the data in a PieChart or a Histogram.

I have added my data source.
For a custom pie chart or histogram, etc do I have to use a Jasper or Birt report definition?

What are the steps involved?

eduardo

Administrator

Registered: 2016-11-01

Website

Re: very very newbie question :(

Hi rezarr,

you may use the Jasper or Birt pie charts / histograms, as you pointed out. Create your reports outside of reportserver and then upload the file (.jrxml or .rptdesign) to reportserver. Set a datasource to use in reportserver (your mySQL datasource) and then you can run your report with reportserver.

An alternative is to use pivot reports. You may create these directly in reportserver. Check here for some information: https://reportserver.net/en/guides/user … amic-List/
Pivot reports may be rendered dynamically as a pie chart, as histograms and as other formats as well. Check the demo system: https://reportserver.net/de/demo/ Log in with demoadmin/demoadmin and in the bottom right corner of the dashboard you may see a pie chart based on a pivot report.

You may find a lot of information on the administration guide: https://reportserver.net/en/guides/admin/main/

Regards,
Eduardo

eduardo

Administrator

Registered: 2016-11-01

Website

Re: very very newbie question :(

Hi rezarr,

here are some examples of charts in reportserver:

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

BIRT, Jasper, Crystal and Excel 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: very very newbie question :(

Hi rezarr,

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

You can find the chart here:

Regards,
Eduardo