Labels

ionic (40) Google Apps Script (28) Construct2 (6) Google API (5) Google Cloud (5) Java (5) presentation (5) jasper (4) plunker (4) Notepad++ (2) liferay (2) ms access (2) mysql (2) PHP (1) SQLite (1) android (1) blogspot (1) html5 (1) ionic-creator (1) javascript (1) mobile (1) plainjs (1) utilties (1)

Learn the powerful enterprise adaptable database:

Getting Started With ADABAS & Natural

Showing posts with label ms access. Show all posts
Showing posts with label ms access. Show all posts

Saturday, September 10, 2016

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.
If you are using PHPMYADMIN…
Import both files.
You should get as follows.
.
.