JasperReports Tutorial for Beginners 2026 | SubReport in JasperReports & MYSQL (Full Course Part 20)

Learn how to create Subreports in JasperReports using MySQL Database in this beginner-friendly tutorial. In this Part 20 of the JasperReports Full Course, we will build a real-world example using the Departments and Employees tables. You will learn how to create a Main Report, design a Subreport, pass parameters between reports, map department IDs, and display employee records department-wise. In this video, you will learn: ✔ What is a Subreport in JasperReports ✔ Why Subreports are used in real-world reporting ✔ Create Main Report (Department Report) ✔ Create Subreport (Employee Report) ✔ Create and Use Parameters ✔ Parameter Mapping Between Reports ✔ Use MySQL Database with JasperReports ✔ Display Department-wise Employee Records ✔ Best Practices for JasperReports Subreports This tutorial is suitable for beginners and intermediate developers working with Java, JasperReports, Jaspersoft Studio, and MySQL. 📌 Technologies Used: JasperReports Jaspersoft Studio Java MySQL 📌 Example: Department → Employees List IT Department Ahmad Khan Karim Ahmadzai Samiullah HR Department Ali Rahimi Farid Hamidi Finance Department Hamid Noori Jawad Safi If you enjoy this tutorial, don't forget to Like, Share, and Subscribe for more JasperReports tutorials. #JasperReports #JaspersoftStudio #Subreport #Java #MySQL #Reporting #Database #JavaTutorial #JasperReportsTutorial #SoftwareDevelopment Playlist Link Section 📚 JasperReports Full Course Playlist:    • JasperReports Tutorial for Beginners 2026 ...   ---------------------------- Database Scripts ---------------------------- USE JasperReportsDB; USE JasperReportsDB; CREATE TABLE departments ( id INT PRIMARY KEY AUTO_INCREMENT, department_name VARCHAR(100) NOT NULL ); INSERT INTO departments (department_name) VALUES ('IT'), ('HR'), ('Finance'), ('Marketing'), ('Administration'); CREATE TABLE employees ( id INT PRIMARY KEY AUTO_INCREMENT, employee_name VARCHAR(100) NOT NULL, email VARCHAR(100), phone VARCHAR(20), salary DECIMAL(10,2), department_id INT, FOREIGN KEY (department_id) REFERENCES departments(id) ); INSERT INTO employees (employee_name, email, phone, salary, department_id) VALUES ('Ahmad Khan', '[email protected]', '0701000001', 50000, 1), ('Karim Ahmadzai', '[email protected]', '0701000002', 45000, 1), ('Samiullah', '[email protected]', '0701000003', 55000, 1), ('Ali Rahimi', '[email protected]', '0701000004', 40000, 2), ('Farid Hamidi', '[email protected]', '0701000005', 42000, 2), ('Hamid Noori', '[email protected]', '0701000006', 60000, 3), ('Jawad Safi', '[email protected]', '0701000007', 58000, 3), ('Nasir Mohammadi', '[email protected]', '0701000008', 45000, 4), ('Zahid Azizi', '[email protected]', '0701000009', 47000, 4), ('Omid Aria', '[email protected]', '0701000010', 52000, 5); SELECT id, department_name FROM departments ORDER BY department_name; SELECT employee_name, email, phone, salary FROM employees WHERE department_id = $P{DEPARTMENT_ID} ORDER BY employee_name;