How To Get Northwind Data To JasperReports

.

How To Get Northwind Data To JasperReports

From MySQL Server

1) Check that you have already defined Data Adapter for the MySQL Server.

2) Create New Report.

Select Menu File/New/Jasper Report.

If the Jasper Report item is not displayed…

Select Menu File/New/Other…

And then select Jasper Report from the list.

3) Select Report Template

4) Set Report Name.

4) Select MySQL Data Connection.

5) Drag the customers table to Diagram window.

Select the fields. Click Next.

Select Dataset Fields.

Select fields to Group By.

Done.

6) Design Editor.

7) Preview Report.

.

How To Import Northwind Data To MySQL

.

How To Import Northwind Data To MySQL

Download the following sql (text) files.

Create Database: https://raw.githubusercontent.com/dalers/mywind/master/northwind.sql 

Insert Records: https://raw.githubusercontent.com/dalers/mywind/master/northwind-data.sql 

If you are using PHPMYADMIN…

Import both files.

You should get as follows.

.

Learn powerful non-relational database at:

https://medium.com/@mohamad.razzi.my/getting-started-with-adabas-natural-part-1-6597688406ad 

.

How To Connect Jaspersoft To MySQL Server

.

How To Manage Jaspersoft Data Connection

How To Manage Jaspersoft Studio Data Connection

1) Get the Data Repository View (if it is not displayed)

Select Menu: Window/Show View/Other...

In the Show View window, find Jaspersoft Studio/ Repository Explorer.

The Explorer Window will be displayed in the Application Window.

In the Repository Window, right-click Data Adapters/Create Data Adapter.

Select Database JDBC Connection.

Get ready with MySql Connector.jar file Get ready with MySql Server (you can use usbwebserver application to provide web and mysql access. Extract the zip file to C:\MYSQL ) Run the server before you start connecting to the mysql server. If the Apache light turns red, it could be that the web port has been acquired by other application. Perhaps Jasper Server is running on that port. Change the Apache port to 8081 Both lights must be in green color.

Add the MySQL connector jar file.

Enter the driver, url, username and password. And then click Test button.

You may want to choose password recovery option to protect your master password recovery.

Rename your Data Adapter.

.

How To Install JasperSoft Studio

.

How To Install JasperSoft Studio

How To Install Jasper Report

1) Run installer

Download File: jaspersoftstudio-5.6.1.final-windows-installer-x86

Accept the license agreement.

Choose components to install.

Choose Install Location.

Choose Start Menu Folder

Completing the Jaspersoft Studio Setup Wizard

Splash Screen pops up.

Workspace selection.

Create new directory.

Welcome Screen appears.

.