iReport+jasperreport创建子表的几种方式（1）
在制作报表的过程中，子表是必不可少的，今天就研究了一下制作子表的几种方式 一、连接数据库创建子表 以MySQL为例： 1）iReport 创建父表 这个就是创建一个新的表，不过记得数据源要选择mySQL ,其他的数据库数据源也一样的。 2）创建好之后，我们来创建子表
在制作报表的过程中，子表是必不可少的，今天就研究了一下制作子表的几种方式
一、连接数据库创建子表
以MySQL为例：
1）iReport 创建父表
这个就是创建一个新的表格，不过记得数据源要选择mySQL ,其他的数据库数据源也一样的。
2）创建好之后，我们来创建子表，在组件面板找到
拖动到父表当中的任意一个地方，我是放到detail里面的
它会产生一个向导
一路next下去，只是在最后一项选择use empty datasource，不过选其他的也行，待会我们还要修改
3）说一下原理：这种方式就是利用每张报表都有的Parameters属性，在iReport4.6中，点击子报表在右侧属性栏的最下面有两个属性
一个是Parameters属性，他可以用来向子表传递数据接下来我会说到，第二个是Return Values很明显这个可以用来将子表的数据返回，这个有时间再说。
下面子表属性进行设置：
有两个属性需要注意，一个是Subreport Expression用来指出子表的路径，这个新建之后一边不需要修改
另外一个是connect type，这个要选择Use a datasource express 创建子表时候选择默认值，就是父连接，这个现在不是重点，不过在之后的方式中，这个是很有用的
下面是重点：
设置点击Parameters打开这样一个窗口，点击add之后
这就是你自定义Parameters的地方，名字可以随便取，我的是如下设置：名字是id我要传递给子表的是数据库的ID字段，到此，我们对于主表这边的设置结束
4）下面设置子表这里有一个关键点，就是在子表左边栏Parameters属性这边要新建一个Parameters，右键-》新建名字要和上面我们创建的一样而字段的类型要和从主表传递过来的字段一样：我定义的是id同时在我的数据库中定义的ID字段是String类型的，所以是以下设置注意，Default Value Expection一定要设置为“”字符，不然会报错，折腾了我好几个小时
这个设置好之后打开数据连接窗口最左边的小按钮，打开后使用select语句不过要使用我们自定义的字段，如下图，
你会发现出现了一些属性字段选择添加，就ＯＫ啦
我的字段和子表设置
下面是预览结果
源码发过去，希望能共同学习
回家了，明天继续写
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
How to create a constant in Python?
Aug 29, 2023 pm 05:17 PM
Constants and variables are used to store data values in programming. A variable usually refers to a value that can change over time. A constant is a type of variable whose value cannot be changed during program execution. There are only six built-in constants available in Python, they are False, True, None, NotImplemented, Ellipsis(...) and __debug__. Apart from these constants, Python does not have any built-in data types to store constant values. Example An example of a constant is demonstrated below - False=100 outputs SyntaxError:cannotassigntoFalseFalse is a built-in constant in Python that is used to store boolean values
How to personalize your iPhone on the latest iOS 17
Sep 21, 2023 am 08:17 AM
How to Personalize Calls on iPhone Apple’s iOS 17 introduces a new feature called Contact Posters that allows you to personalize the look of your call screen on your iPhone. This feature allows you to design a poster using selected photos, colors, fonts, and Memoji as contact cards. So when you make a call, your custom image will appear on the recipient's iPhone exactly as you envisioned. You can choose to share your unique contact poster with all your saved contacts, or choose who can see it. Likewise, during a call exchange, you will also see other people's contact posters. Additionally, Apple lets you set specific contact photos for individual contacts, making calls from those contacts
How to create a folder on Realme Phone?
Mar 23, 2024 pm 02:30 PM
Title: Realme Phone Beginner’s Guide: How to Create Folders on Realme Phone? In today's society, mobile phones have become an indispensable tool in people's lives. As a popular smartphone brand, Realme Phone is loved by users for its simple and practical operating system. In the process of using Realme phones, many people may encounter situations where they need to organize files and applications on their phones, and creating folders is an effective way. This article will introduce how to create folders on Realme phones to help users better manage their phone content. No.
How to create pixel art in GIMP
Feb 19, 2024 pm 03:24 PM
This article will interest you if you are interested in using GIMP for pixel art creation on Windows. GIMP is a well-known graphics editing software that is not only free and open source, but also helps users create beautiful images and designs easily. In addition to being suitable for beginners and professional designers alike, GIMP can also be used to create pixel art, a form of digital art that utilizes pixels as the only building blocks for drawing and creating. How to Create Pixel Art in GIMP Here are the main steps to create pixel pictures using GIMP on a Windows PC: Download and install GIMP, then launch the application. Create a new image. Resize width and height. Select the pencil tool. Set the brush type to pixels. set up
How to create a family with Gree+
Mar 01, 2024 pm 12:40 PM
Many friends expressed that they want to know how to create a family in Gree+ software. Here is the operation method for you. Friends who want to know more, come and take a look with me. First, open the Gree+ software on your mobile phone and log in. Then, in the options bar at the bottom of the page, click the "My" option on the far right to enter the personal account page. 2. After coming to my page, there is a "Create Family" option under "Family". After finding it, click on it to enter. 3. Next jump to the page to create a family, enter the family name to be set in the input box according to the prompts, and click the "Save" button in the upper right corner after entering it. 4. Finally, a "save successfully" prompt will pop up at the bottom of the page, indicating that the family has been successfully created.
How to create a Gantt chart using Highcharts
Dec 17, 2023 pm 07:23 PM
How to use Highcharts to create a Gantt chart requires specific code examples. Introduction: The Gantt chart is a chart form commonly used to display project progress and time management. It can visually display the start time, end time and progress of the task. Highcharts is a powerful JavaScript chart library that provides rich chart types and flexible configuration options. This article will introduce how to use Highcharts to create a Gantt chart and give specific code examples. 1. Highchart
How to Create a Contact Poster for Your iPhone
Mar 02, 2024 am 11:30 AM
In iOS17, Apple has added a contact poster feature to its commonly used Phone and Contacts apps. This feature allows users to set personalized posters for each contact, making the address book more visual and personal. Contact posters can help users identify and locate specific contacts more quickly, improving user experience. Through this feature, users can add specific pictures or logos to each contact according to their preferences and needs, making the address book interface more vivid. Apple in iOS17 provides iPhone users with a novel way to express themselves, and added a personalizable contact poster. The Contact Poster feature allows you to display unique, personalized content when calling other iPhone users. you
How to create user interface via Python?
Aug 26, 2023 am 09:17 AM
In this article, we will learn how to create user interface using python. What is a graphical user interface? The term "graphical user interface" (or "GUI") refers to a set of visual element items that can be interacted with in computer software to display information and interact. In response to human input, objects may change appearance characteristics such as color, size, and visibility. Graphical components such as icons, cursors, and buttons can be enhanced with audio or visual effects (such as transparency) to create graphical user interfaces (GUIs). If you want more people to use your platform, you need to make sure it has a good user interface. This is because the combination of these factors can greatly affect the quality of service provided by your app or website. Python is widely used by developers because it provides
