Jaspersoft Studio-6.6.0用户指南-创建报表，Crosstab表和汇总表

川长思鸟来 2022-03-15 07:46 252阅读 0赞

**目录**

创建项目文件夹

创建新报告

添加和删除报告元素

将字段添加到报表

删除字段

添加其他元素

预览报告

创建Crosstab表

创建汇总表

--------------------

# 创建项目文件夹 #

项目文件夹可帮助您整理报告。

**要创建项目文件夹：**

将出现“ **选择向导”**对话框。

<table> 
 <tfoot> 
  <tr> 
   <td> <p style="margin-left:0px;"><span style="color:#000000;"><span style="color:#556677;">选择一个向导</span></span></p> </td> 
  </tr> 
 </tfoot> 
 <tbody> 
  <tr> 
   <td> <p style="margin-left:0px;"><img alt="" height="333" src="https://img-blog.csdnimg.cn/20190305180639253.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r,size_16,color_FFFFFF,t_70" width="397"></p> </td> 
  </tr> 
 </tbody> 
</table>

<table> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;">&nbsp;</td> 
   <td style="vertical-align:top;width:1px;"><span style="color:#000000;"><span style="color:#556677;">2。</span></span></td> 
   <td style="vertical-align:top;"><span style="color:#000000;"><span style="color:#556677;">在向导栏中输入<strong>Jasper</strong>以过滤所有操作。仅显示与Jaspersoft Studio相关的内容</span></span></td> 
  </tr> 
 </tbody> 
</table>

<table> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;">&nbsp;</td> 
   <td style="vertical-align:top;width:2px;"><span style="color:#000000;"><span style="color:#556677;">3。</span></span></td> 
   <td style="vertical-align:top;"><span style="color:#000000;"><span style="color:#556677;">选择<strong>JasperReports项目</strong>。单击<strong>下一步</strong>。</span></span></td> 
  </tr> 
 </tbody> 
</table>

在**新的JasperReports项目**出现向导。

<table> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;">&nbsp;</td> 
   <td style="vertical-align:top;width:1.8px;"><span style="color:#000000;"><span style="color:#556677;">4。</span></span></td> 
   <td style="vertical-align:top;"><span style="color:#000000;"><span style="color:#556677;">输入项目的名称，然后单击“&nbsp;<strong>完成”</strong>。</span></span></td> 
  </tr> 
 </tbody> 
</table>

在**项目资源管理器**将显示您的项目。

# 创建新报告 #

Jaspersoft Studio提供了从头开始创建报表，添加自己的模板或使用提供的模板之一的选项。所有这些选项都允许您指定数据源。您有三个数据源选项：

<table style="width:645.6px;"> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;"><span style="color:#000000;"><span style="color:#556677;"><strong>一个空记录 - 空行</strong>：这是用于创建没有任何数据的报告的默认数据适配器。在将报表连接到数据源之前，它可用于定义报表的布局。在创建报告之后，可以在以后添加或更改数据源。</span></span></td> 
  </tr> 
 </tbody> 
</table>

<table style="width:645.6px;"> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;"><span style="color:#000000;"><span style="color:#556677;"><strong>示例DB - 数据库JBDC连接</strong>：这是随Jaspersoft Studio安装提供的SQL数据库。</span></span></td> 
  </tr> 
 </tbody> 
</table>

<table style="width:645.6px;"> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;"><span style="color:#000000;"><span style="color:#556677;"><strong>创建新的数据适配器</strong>：Jaspersoft Studio支持各种数据源。使用“&nbsp;<strong>新建”</strong>按钮可以浏览并连接到现有数据源。</span></span></td> 
  </tr> 
 </tbody> 
</table>

**要创建新报告：**

<table style="width:645.6px;"> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;">&nbsp;</td> 
   <td style="vertical-align:top;width:1px;"><span style="color:#000000;"><span style="color:#556677;">1。</span></span></td> 
   <td style="vertical-align:top;width:618.4px;"><span style="color:#000000;"><span style="color:#556677;">打开“&nbsp;<strong>文件”</strong>菜单，选择“&nbsp;<strong>新建”</strong>，然后单击“&nbsp;<strong>Jasper报告”</strong>。</span></span></td> 
  </tr> 
 </tbody> 
</table>

将出现“ **新建报告向导”>“报告模板”**窗口

<table> 
 <tfoot> 
  <tr> 
   <td> <p style="margin-left:0px;"><span style="color:#000000;"><span style="color:#556677;">新报告向导</span></span></p> </td> 
  </tr> 
 </tfoot> 
 <tbody> 
  <tr> 
   <td> <p style="margin-left:0px;"><img alt="" height="399" src="https://img-blog.csdnimg.cn/20190305171855477.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r,size_16,color_FFFFFF,t_70" width="497"></p> </td> 
  </tr> 
 </tbody> 
</table>

<table style="width:645.6px;"> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;">&nbsp;</td> 
   <td style="vertical-align:top;width:1.40001px;"><span style="color:#000000;"><span style="color:#556677;">2。</span></span></td> 
   <td style="vertical-align:top;width:600.6px;"><span style="color:#000000;"><span style="color:#556677;">选择Coffee，然后单击<strong>Next</strong>。</span></span></td> 
  </tr> 
 </tbody> 
</table>

出现“ **新建报告向导”>“报告文件”**窗口。

<table> 
 <tfoot> 
  <tr> 
   <td> <p style="margin-left:0px;"><span style="color:#000000;"><span style="color:#556677;">新报告向导&gt;报告文件</span></span></p> </td> 
  </tr> 
 </tfoot> 
 <tbody> 
  <tr> 
   <td> <p style="margin-left:0px;"><img alt="" height="397" src="https://img-blog.csdnimg.cn/20190305171936289.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r,size_16,color_FFFFFF,t_70" width="497"></p> </td> 
  </tr> 
 </tbody> 
</table>

<table style="width:645.6px;"> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;">&nbsp;</td> 
   <td style="vertical-align:top;width:2.60001px;"><span style="color:#000000;"><span style="color:#556677;">3。</span></span></td> 
   <td style="vertical-align:top;width:616.4px;"><span style="color:#000000;"><span style="color:#556677;">在工作区中选择要放置报告的文件夹，然后命名新报告。</span></span></td> 
  </tr> 
 </tbody> 
</table>

您可以使用默认文件夹**MyReports**，将报告命名为Example example。

如果要为报告创建新项目文件夹，请参阅[创建项目文件夹][Link 1]。

将出现“ **新建报告向导”>“数据源”**窗口。

<table style="width:645.6px;"> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;">&nbsp;</td> 
   <td style="vertical-align:top;width:1px;"><span style="color:#000000;"><span style="color:#556677;">5。</span></span></td> 
   <td style="vertical-align:top;width:615.2px;"><span style="color:#000000;"><span style="color:#556677;">选择<strong>Sample DB - Database JDBC Connection</strong>。</span></span></td> 
  </tr> 
 </tbody> 
</table>

输入查询select \* from orders，然后单击**Next**。

<table> 
 <tfoot> 
  <tr> 
   <td> <p style="margin-left:0px;"><span style="color:#000000;"><span style="color:#556677;">新报告向导&gt;数据源</span></span></p> </td> 
  </tr> 
 </tfoot> 
 <tbody> 
  <tr> 
   <td> <p style="margin-left:0px;"><img alt="" height="398" src="https://img-blog.csdnimg.cn/20190305172024112.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r,size_16,color_FFFFFF,t_70" width="497"></p> </td> 
  </tr> 
 </tbody> 
</table>

将出现“ **新建报告向导”>“域”**窗口。

<table> 
 <tfoot> 
  <tr> 
   <td> <p style="margin-left:0px;"><span style="color:#000000;"><span style="color:#556677;">新报告向导&gt;字段</span></span></p> </td> 
  </tr> 
 </tfoot> 
 <tbody> 
  <tr> 
   <td> <p style="margin-left:0px;"><img alt="" height="400" src="https://img-blog.csdnimg.cn/20190305172151314.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r,size_16,color_FFFFFF,t_70" width="497"></p> </td> 
  </tr> 
 </tbody> 
</table>

<table style="width:645.6px;"> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;">&nbsp;</td> 
   <td style="vertical-align:top;width:7px;"><span style="color:#000000;"><span style="color:#556677;">6。</span></span></td> 
   <td style="vertical-align:top;width:620px;"><span style="color:#000000;"><span style="color:#556677;">左侧列表显示了所有已发现的字段;&nbsp;右侧列表显示将添加到报告中的那些。选择以下字段，然后单击向右箭头将其添加到报表中。</span></span></td> 
  </tr> 
 </tbody> 
</table>

<table style="width:645.6px;"> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;width:22px;">&nbsp;</td> 
   <td style="vertical-align:top;width:2.60001px;"><span style="color:#000000;"><span style="color:#556677;">•&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span></td> 
   <td style="vertical-align:top;width:620.4px;"><span style="color:#000000;"><span style="color:#556677;">ORDERID</span></span></td> 
  </tr> 
 </tbody> 
</table>

<table style="width:645.6px;"> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;width:20px;">&nbsp;</td> 
   <td style="vertical-align:top;width:2px;"><span style="color:#000000;"><span style="color:#556677;">•&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span></td> 
   <td style="vertical-align:top;width:623px;">SHIPNAME</td> 
  </tr> 
 </tbody> 
</table>

<table style="width:645.6px;"> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;">&nbsp;</td> 
   <td style="vertical-align:top;width:1px;"><span style="color:#000000;"><span style="color:#556677;">•&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span></td> 
   <td style="vertical-align:top;width:626.4px;"><span style="color:#000000;"><span style="color:#556677;">SHIPADDRESS</span></span></td> 
  </tr> 
 </tbody> 
</table>

<table style="width:645.6px;"> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;">&nbsp;</td> 
   <td style="vertical-align:top;width:1px;"><span style="color:#000000;"><span style="color:#556677;">•&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span></td> 
   <td style="vertical-align:top;width:599.2px;">SHIPCITY</td> 
  </tr> 
 </tbody> 
</table>

<table style="width:645.6px;"> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;">&nbsp;</td> 
   <td style="vertical-align:top;width:10px;"><span style="color:#000000;"><span style="color:#556677;">•&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span></td> 
   <td style="vertical-align:top;width:607px;"><span style="color:#000000;"><span style="color:#556677;">SHIPREGION</span></span></td> 
  </tr> 
 </tbody> 
</table>

<table style="width:645.6px;"> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;">&nbsp;</td> 
   <td style="vertical-align:top;width:10px;"><span style="color:#000000;"><span style="color:#556677;">7。</span></span></td> 
   <td style="vertical-align:top;width:592px;"><span style="color:#000000;"><span style="color:#556677;">选择字段后，单击“&nbsp;<strong>下一步”</strong>。</span></span></td> 
  </tr> 
 </tbody> 
</table>

将出现“ **新建报告向导”>“分组”**窗口。

<table> 
 <tfoot> 
  <tr> 
   <td> <p style="margin-left:0px;"><span style="color:#000000;"><span style="color:#556677;">新报告向导&gt;分组</span></span></p> </td> 
  </tr> 
 </tfoot> 
 <tbody> 
  <tr> 
   <td> <p style="margin-left:0px;"><img alt="" height="402" src="https://img-blog.csdnimg.cn/20190305173842734.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r,size_16,color_FFFFFF,t_70" width="497"></p> </td> 
  </tr> 
 </tbody> 
</table>

Jaspersoft Studio现在构建包含所选字段的报表布局，如[“设计视图中的新报表”所示][Link 2]：

<table> 
 <tfoot> 
  <tr> 
   <td> <p style="margin-left:0px;"><span style="color:#000000;"><span style="color:#556677;">设计视图中的新报告</span></span></p> </td> 
  </tr> 
 </tfoot> 
 <tbody> 
  <tr> 
   <td> <p style="margin-left:0px;"><img alt="" height="282" src="https://img-blog.csdnimg.cn/2019030517400625.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r,size_16,color_FFFFFF,t_70" width="497"></p> </td> 
  </tr> 
 </tbody> 
</table>

# 添加和删除报告元素 #

创建报告后，您可以添加和删除字段和其他元素，而无需创建新报告。

### 将字段添加到报表 ###

**要向已创建的报告添加字段：**

<table> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;">&nbsp;</td> 
   <td style="vertical-align:top;width:1.8px;"><span style="color:#000000;"><span style="color:#556677;">1。</span></span></td> 
   <td style="vertical-align:top;"><span style="color:#000000;"><span style="color:#556677;">从“&nbsp;<strong>大纲”</strong>视图中选择报告的主节点。</span></span></td> 
  </tr> 
 </tbody> 
</table>

<table> 
 <tfoot> 
  <tr> 
   <td> <p style="margin-left:0px;"><span style="color:#000000;"><span style="color:#556677;">属性选项卡</span></span></p> </td> 
  </tr> 
 </tfoot> 
 <tbody> 
  <tr> 
   <td> <p style="margin-left:0px;"><img alt="" height="379" src="https://img-blog.csdnimg.cn/20190305174251565.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r,size_16,color_FFFFFF,t_70" width="472"></p> </td> 
  </tr> 
 </tbody> 
</table>

<table> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;">&nbsp;</td> 
   <td style="vertical-align:top;width:1.6px;"><span style="color:#000000;"><span style="color:#556677;">3。</span></span></td> 
   <td style="vertical-align:top;"><span style="color:#000000;"><span style="color:#556677;">在<strong>Properties</strong>选项卡上，单击<strong>Report</strong>按钮。</span></span></td> 
  </tr> 
 </tbody> 
</table>

<table> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;">&nbsp;</td> 
   <td style="vertical-align:top;width:1px;"><span style="color:#000000;"><span style="color:#556677;">4。</span></span></td> 
   <td style="vertical-align:top;"><span style="color:#000000;"><span style="color:#556677;">按“&nbsp;<strong>编辑查询，筛选和排序”选项</strong>按钮。</span></span></td> 
  </tr> 
 </tbody> 
</table>

“ **数据集和查询”**对话框将打开。

<table> 
 <tfoot> 
  <tr> 
   <td> <p style="margin-left:0px;"><span style="color:#000000;"><span style="color:#556677;">数据集和查询对话框</span></span></p> </td> 
  </tr> 
 </tfoot> 
 <tbody> 
  <tr> 
   <td> <p style="margin-left:0px;"><img alt="" height="471" src="https://img-blog.csdnimg.cn/20190305175239800.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r,size_16,color_FFFFFF,t_70" width="497"></p> </td> 
  </tr> 
 </tbody> 
</table>

<table> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;">&nbsp;</td> 
   <td style="vertical-align:top;width:2.8px;"><span style="color:#000000;"><span style="color:#556677;">5。</span></span></td> 
   <td style="vertical-align:top;"><span style="color:#000000;"><span style="color:#556677;">单击“&nbsp;<strong>读取字段”</strong>按钮添加更多字段。</span></span></td> 
  </tr> 
 </tbody> 
</table>

发现的所有字段都将作为新字段添加到报表中。

<table> 
 <tbody> 
  <tr> 
   <td> <p style="margin-left:0px;"><span style="color:#000000;"><span style="color:#556677;"><img alt="" src="https://community.jaspersoft.com/Resources/Images/note-icon-ns_28x28.png"></span></span></p> </td> 
   <td> <p style="margin-left:0px;"><span style="color:#000000;"><span style="color:#556677;">您还可以在同一对话框中编辑或更改查询。如果新查询发现的字段少于现有报表中使用的字段，则会从报表中删除未包含在新查询中的字段。</span></span></p> </td> 
  </tr> 
 </tbody> 
</table>

您将返回“ **设计”**视图。

<table> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;">&nbsp;</td> 
   <td style="vertical-align:top;width:3px;"><span style="color:#000000;"><span style="color:#556677;">7。</span></span></td> 
   <td style="vertical-align:top;"><span style="color:#000000;"><span style="color:#556677;">扩展<strong>字段</strong>在<strong>大纲</strong>视图中看到所有的字段现在可用于报表。</span></span></td> 
  </tr> 
 </tbody> 
</table>

<table> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;">&nbsp;</td> 
   <td style="vertical-align:top;width:3px;"><span style="color:#000000;"><span style="color:#556677;">8。</span></span></td> 
   <td style="vertical-align:top;"><span style="color:#000000;"><span style="color:#556677;">要向报表添加字段，请单击“&nbsp;<strong>大纲”</strong>视图中的字段并将其拖到“&nbsp;<strong>设计”</strong>视图中。</span></span></td> 
  </tr> 
 </tbody> 
</table>

在详细信息区域内拖动字段对象时，Jaspersoft Studio会创建一个文本字段元素并设置该元素的文本字段表达式。

### 删除字段 ###

要从报表中删除字段，请执行以下操作：在“ **设计”**视图中，右键单击要删除的字段，然后选择“ **删除”**。

### 添加其他元素 ###

要添加其他元素（如线条，图像或图表），请从调色板中拖动元素 如下图所示进入“ **设计”**视图，然后根据需要调整大小并进行排列。

<table> 
 <tfoot> 
  <tr> 
   <td> <p style="margin-left:0px;"><span style="color:#000000;"><span style="color:#556677;">元素调色板</span></span></p> </td> 
  </tr> 
 </tfoot> 
 <tbody> 
  <tr> 
   <td> <p style="margin-left:0px;"><img alt="" height="565" src="https://img-blog.csdnimg.cn/20190305175808578.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r,size_16,color_FFFFFF,t_70" width="397"></p> </td> 
  </tr> 
 </tbody> 
</table>

# 预览报告 #

要预览报告，请单击“ **预览”**选项卡（在“ **设计”**视图中朝向屏幕底部）切换到“预览”模式。预览在后台编译报表，并通过JDBC连接填充查询检索的数据。如“报告预览”中所示，详细信息带会针对查询结果中的每一行重复，从而创建一个简单的表格报告：

# 创建Crosstab表 #

选择Blank\_A4\_Landscape报告模板

state.sql

-- ----------------------------
    -- Table structure for state
    -- ----------------------------
    DROP TABLE IF EXISTS `state`;
    CREATE TABLE `state` (
      `country` varchar(40) DEFAULT NULL COMMENT '国家',
      `city` varchar(40) DEFAULT NULL COMMENT '城市'
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    
    -- ----------------------------
    -- Records of state
    -- ----------------------------
    INSERT INTO `state` VALUES ('CHINA', 'Beijing');
    INSERT INTO `state` VALUES ('CHINA', 'Beijing');
    INSERT INTO `state` VALUES ('CHINA', 'Beijing');
    INSERT INTO `state` VALUES ('CHINA', 'Shanghai');
    INSERT INTO `state` VALUES ('USA', 'Chicago');
    INSERT INTO `state` VALUES ('USA', 'Chicago');
    INSERT INTO `state` VALUES ('USA', 'Alaska');
    INSERT INTO `state` VALUES ('USA', 'Alaska');
    INSERT INTO `state` VALUES ('USA', 'Alaska');

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70][]

删除无用列，拖拽Palette区域crosstab到Summary

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 1][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 2][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 3][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 4][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 5][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 6][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 7][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 8][]

# 创建汇总表 #

product.sql

-- ----------------------------
    -- Table structure for product
    -- ----------------------------
    DROP TABLE IF EXISTS `product`;
    CREATE TABLE `product` (
      `id` int(11) DEFAULT NULL,
      `name` varchar(255) DEFAULT NULL,
      `cost` decimal(10,0) DEFAULT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    
    -- ----------------------------
    -- Records of product
    -- ----------------------------
    INSERT INTO `product` VALUES ('1001', 'Iron Iron', '5');
    INSERT INTO `product` VALUES ('1001', 'Chair Shoe', '25');
    INSERT INTO `product` VALUES ('1001', 'Telephone Clock', '25');
    INSERT INTO `product` VALUES ('1001', 'Chair Chair', '25');
    INSERT INTO `product` VALUES ('1001', 'Ice Tea Shoe', '13');
    INSERT INTO `product` VALUES ('1001', 'Clock Clock', '24');
    INSERT INTO `product` VALUES ('1001', 'Ice Tea Chair', '10');
    INSERT INTO `product` VALUES ('1001', 'Telephone Shoe', '8');
    INSERT INTO `product` VALUES ('1001', 'Ice Tea Clock', '23');
    INSERT INTO `product` VALUES ('1001', 'Clock Telephone', '17');
    INSERT INTO `product` VALUES ('1001', 'Telephone Ice Tea', '20');
    INSERT INTO `product` VALUES ('1001', 'Telephone Iron', '9');
    INSERT INTO `product` VALUES ('1001', 'Clock Ice Tea', '17');
    INSERT INTO `product` VALUES ('1001', 'Telephone Clock', '18');
    INSERT INTO `product` VALUES ('1001', 'Telephone Iron', '12');
    INSERT INTO `product` VALUES ('1001', 'Ice Tea Chair', '9');
    INSERT INTO `product` VALUES ('1001', 'Ice Tea Shoe', '19');
    INSERT INTO `product` VALUES ('1001', 'Clock Ice Tea', '22');
    INSERT INTO `product` VALUES ('1001', 'Chair Clock', '17');
    INSERT INTO `product` VALUES ('1001', 'Ice Tea Ice Tea', '11');
    INSERT INTO `product` VALUES ('1001', 'Ice Tea Telephone', '20');
    INSERT INTO `product` VALUES ('1001', 'Chair Chair', '11');
    INSERT INTO `product` VALUES ('1001', 'Iron Iron', '7');
    INSERT INTO `product` VALUES ('1001', 'Shoe Chair', '8');
    INSERT INTO `product` VALUES ('1001', 'Chair Shoe', '7');
    INSERT INTO `product` VALUES ('1002', 'Shoe Shoe', '16');
    INSERT INTO `product` VALUES ('1002', 'Shoe Shoe', '25');
    INSERT INTO `product` VALUES ('1002', 'Telephone Iron', '23');
    INSERT INTO `product` VALUES ('1002', 'Clock Iron', '3');
    INSERT INTO `product` VALUES ('1002', 'Chair Telephone', '11');
    INSERT INTO `product` VALUES ('1002', 'Shoe Iron', '23');
    INSERT INTO `product` VALUES ('1002', 'Ice Tea Telephone', '5');
    INSERT INTO `product` VALUES ('1002', 'Clock Iron', '19');
    INSERT INTO `product` VALUES ('1002', 'Iron Chair', '18');
    INSERT INTO `product` VALUES ('1002', 'Chair Iron', '26');
    INSERT INTO `product` VALUES ('1002', 'Telephone Shoe', '8');
    INSERT INTO `product` VALUES ('1002', 'Ice Tea Iron', '3');
    INSERT INTO `product` VALUES ('1002', 'Clock Shoe', '9');
    INSERT INTO `product` VALUES ('1002', 'Clock Ice Tea', '22');
    INSERT INTO `product` VALUES ('1002', 'Ice Tea Shoe', '15');
    INSERT INTO `product` VALUES ('1002', 'Shoe Clock', '3');
    INSERT INTO `product` VALUES ('1002', 'Clock Ice Tea', '21');
    INSERT INTO `product` VALUES ('1002', 'Iron Chair', '20');
    INSERT INTO `product` VALUES ('1002', 'Telephone Clock', '9');
    INSERT INTO `product` VALUES ('1002', 'Ice Tea Ice Tea', '10');
    INSERT INTO `product` VALUES ('1002', 'Iron Ice Tea', '18');
    INSERT INTO `product` VALUES ('1002', 'Ice Tea Clock', '6');
    INSERT INTO `product` VALUES ('1002', 'Ice Tea Iron', '18');
    INSERT INTO `product` VALUES ('1002', 'Clock Clock', '21');
    INSERT INTO `product` VALUES ('1002', 'Iron Iron', '2');

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 9][]

修改属性，调整样式

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 10][]

添加变量total\_num和total\_sum

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 11][]

预览效果

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 12][]

添加参数whereSql

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 13][]

修改查询sql

SELECT
    	id,
    	`name`,
    	count(cost) num,
    	sum(cost) sum
    FROM
    	product
    WHERE
    	 $P!{whereSql}
    GROUP BY
    	id,
    	`name`

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 14][]

预览输入参数cost<15

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 15][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 16][]

最终product.jrxml

<?xml version="1.0" encoding="UTF-8"?>
    
    <jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="product" pageWidth="792" pageHeight="612" orientation="Landscape" columnWidth="752" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="9138ecee-c3d8-405d-b504-a3a317a83215">
    	<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
    	<property name="com.jaspersoft.studio.data.defaultdataadapter" value="mysql-test"/>
    	<parameter name="whereSql" class="java.lang.String"/>
    	<queryString language="SQL">
    		<![CDATA[SELECT
    	id,
    	`name`,
    	count(cost) num,
    	sum(cost) sum
    FROM
    	product
    WHERE
    	 $P!{whereSql}
    GROUP BY
    	id,
    	`name`]]>
    	</queryString>
    	<field name="id" class="java.lang.Integer">
    		<property name="com.jaspersoft.studio.field.label" value="id"/>
    		<property name="com.jaspersoft.studio.field.tree.path" value="product"/>
    	</field>
    	<field name="name" class="java.lang.String">
    		<property name="com.jaspersoft.studio.field.label" value="name"/>
    		<property name="com.jaspersoft.studio.field.tree.path" value="product"/>
    	</field>
    	<field name="num" class="java.lang.Long">
    		<property name="com.jaspersoft.studio.field.label" value="num"/>
    	</field>
    	<field name="sum" class="java.math.BigDecimal">
    		<property name="com.jaspersoft.studio.field.label" value="sum"/>
    	</field>
    	<variable name="total_sum" class="java.math.BigDecimal" calculation="Sum">
    		<variableExpression><![CDATA[$F{sum}]]></variableExpression>
    	</variable>
    	<variable name="total_num" class="java.lang.Integer" calculation="Sum">
    		<variableExpression><![CDATA[$F{num}]]></variableExpression>
    	</variable>
    	<group name="id">
    		<groupExpression><![CDATA[$F{id}]]></groupExpression>
    	</group>
    	<group name="name">
    		<groupExpression><![CDATA[$F{name}]]></groupExpression>
    	</group>
    	<background>
    		<band splitType="Stretch"/>
    	</background>
    	<title>
    		<band height="79" splitType="Stretch"/>
    	</title>
    	<pageHeader>
    		<band height="35" splitType="Stretch"/>
    	</pageHeader>
    	<columnHeader>
    		<band height="41" splitType="Stretch">
    			<property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.HorizontalRowLayout"/>
    			<staticText>
    				<reportElement stretchType="ContainerHeight" x="0" y="0" width="188" height="41" forecolor="#2838C9" backcolor="#F26B30" uuid="8d0fc348-ad9b-41de-b630-4feece4942d9">
    					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="f660a072-4c3b-4d9e-a045-ab75c05be0ed"/>
    				</reportElement>
    				<box>
    					<pen lineWidth="1.0" lineStyle="Solid"/>
    				</box>
    				<textElement textAlignment="Center">
    					<font fontName="myfont" size="20" isBold="true"/>
    					<paragraph lineSpacing="Double"/>
    				</textElement>
    				<text><![CDATA[订单编号]]></text>
    			</staticText>
    			<staticText>
    				<reportElement stretchType="ContainerHeight" x="188" y="0" width="188" height="41" forecolor="#2838C9" backcolor="#F26B30" uuid="4e5c394c-bcab-4b74-9083-c7833d67047d">
    					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="c87ead29-a587-4fd2-95db-cec89cda4eea"/>
    				</reportElement>
    				<box>
    					<pen lineWidth="1.0" lineStyle="Solid"/>
    				</box>
    				<textElement textAlignment="Center">
    					<font fontName="myfont" size="20" isBold="true"/>
    					<paragraph lineSpacing="Double"/>
    				</textElement>
    				<text><![CDATA[订单名称]]></text>
    			</staticText>
    			<staticText>
    				<reportElement stretchType="ContainerHeight" x="376" y="0" width="188" height="41" forecolor="#2838C9" backcolor="#F26B30" uuid="2de0c925-32f9-40a1-affa-9888d62543e4">
    					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="872c9ba9-efc3-4b73-9ed7-4058729eef27"/>
    				</reportElement>
    				<box>
    					<pen lineWidth="1.0" lineStyle="Solid"/>
    				</box>
    				<textElement textAlignment="Center">
    					<font fontName="myfont" size="20" isBold="true"/>
    					<paragraph lineSpacing="Double"/>
    				</textElement>
    				<text><![CDATA[订单数量]]></text>
    			</staticText>
    			<staticText>
    				<reportElement stretchType="ContainerHeight" x="564" y="0" width="188" height="41" forecolor="#2838C9" backcolor="#F26B30" uuid="6b1ea5d3-9614-4f38-b3c8-db70e5d46574">
    					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="d35e0dbd-5063-4434-9924-1b4526f24796"/>
    				</reportElement>
    				<box>
    					<pen lineWidth="1.0" lineStyle="Solid"/>
    				</box>
    				<textElement textAlignment="Center">
    					<font fontName="myfont" size="20" isBold="true"/>
    					<paragraph lineSpacing="Double"/>
    				</textElement>
    				<text><![CDATA[订单总价]]></text>
    			</staticText>
    		</band>
    	</columnHeader>
    	<detail>
    		<band height="35" splitType="Stretch">
    			<property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.HorizontalRowLayout"/>
    			<printWhenExpression><![CDATA[(($V{REPORT_COUNT}.intValue())%2)==0]]></printWhenExpression>
    			<textField>
    				<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="188" height="35" isPrintInFirstWholeBand="true" printWhenGroupChanges="id" forecolor="#9E2624" backcolor="#570D0C" uuid="cd28bc1c-9d2f-492b-ba41-8741f153063d">
    					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="f660a072-4c3b-4d9e-a045-ab75c05be0ed"/>
    					<printWhenExpression><![CDATA[(($V{REPORT_COUNT}.intValue())%2)==0]]></printWhenExpression>
    				</reportElement>
    				<box>
    					<pen lineWidth="1.0" lineStyle="Solid"/>
    				</box>
    				<textElement textAlignment="Center">
    					<font fontName="myfont" size="14"/>
    					<paragraph lineSpacing="AtLeast"/>
    				</textElement>
    				<textFieldExpression><![CDATA[$F{id}]]></textFieldExpression>
    			</textField>
    			<textField>
    				<reportElement x="188" y="0" width="188" height="35" uuid="faed5324-62af-4bba-98a5-bf1c22a8c2b7">
    					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="c87ead29-a587-4fd2-95db-cec89cda4eea"/>
    				</reportElement>
    				<box>
    					<pen lineWidth="1.0" lineStyle="Solid"/>
    				</box>
    				<textElement textAlignment="Center">
    					<font fontName="myfont" size="14"/>
    				</textElement>
    				<textFieldExpression><![CDATA[$F{name}]]></textFieldExpression>
    			</textField>
    			<textField>
    				<reportElement x="376" y="0" width="188" height="35" uuid="f3704ffb-042b-4ad9-9598-3b52661e9e91">
    					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="872c9ba9-efc3-4b73-9ed7-4058729eef27"/>
    				</reportElement>
    				<box>
    					<pen lineWidth="1.0" lineStyle="Solid"/>
    				</box>
    				<textElement textAlignment="Center">
    					<font fontName="myfont" size="14"/>
    				</textElement>
    				<textFieldExpression><![CDATA[$F{num}]]></textFieldExpression>
    			</textField>
    			<textField>
    				<reportElement x="564" y="0" width="188" height="35" uuid="1fe002b5-2e28-4b4d-823c-899c20e05d98">
    					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="d35e0dbd-5063-4434-9924-1b4526f24796"/>
    				</reportElement>
    				<box>
    					<pen lineWidth="1.0" lineStyle="Solid"/>
    				</box>
    				<textElement textAlignment="Center">
    					<font fontName="myfont" size="14"/>
    				</textElement>
    				<textFieldExpression><![CDATA[$F{sum}]]></textFieldExpression>
    			</textField>
    		</band>
    	</detail>
    	<columnFooter>
    		<band height="48" splitType="Stretch">
    			<staticText>
    				<reportElement x="0" y="0" width="376" height="30" isPrintInFirstWholeBand="true" printWhenGroupChanges="id" backcolor="#331110" uuid="d4400682-d80f-43fc-865d-c11697cbfdf2"/>
    				<box>
    					<pen lineWidth="1.0" lineStyle="Solid" lineColor="#070808"/>
    				</box>
    				<textElement textAlignment="Center">
    					<font fontName="myfont" size="20" isBold="true"/>
    				</textElement>
    				<text><![CDATA[合计]]></text>
    			</staticText>
    			<textField>
    				<reportElement x="376" y="0" width="188" height="30" isPrintInFirstWholeBand="true" printWhenGroupChanges="id" backcolor="#331110" uuid="f4dc9dad-a96f-4b21-a00e-2788e01b61ae"/>
    				<box>
    					<pen lineWidth="1.0" lineStyle="Solid"/>
    				</box>
    				<textElement textAlignment="Center">
    					<font fontName="myfont" size="14"/>
    				</textElement>
    				<textFieldExpression><![CDATA[$V{total_num}]]></textFieldExpression>
    			</textField>
    			<textField>
    				<reportElement x="564" y="0" width="188" height="30" isPrintInFirstWholeBand="true" printWhenGroupChanges="id" backcolor="#331110" uuid="f83f41bd-c283-4b16-8165-e552836e0a95"/>
    				<box>
    					<pen lineWidth="1.0" lineStyle="Solid"/>
    				</box>
    				<textElement textAlignment="Center">
    					<font fontName="myfont" size="14"/>
    				</textElement>
    				<textFieldExpression><![CDATA[$V{total_sum}]]></textFieldExpression>
    			</textField>
    		</band>
    	</columnFooter>
    	<pageFooter>
    		<band height="54" splitType="Stretch"/>
    	</pageFooter>
    	<summary>
    		<band height="42" splitType="Stretch"/>
    	</summary>
    </jasperReport>

[Link 1]: https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v60/creating-project-folder#jss-user-basicreport_293982575_1024125
[Link 2]: https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v60/creating-new-report#jss-user-basicreport_293982575_1024513
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70]: /images/20220315/6d20c131e910477787e165e587d0256b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 1]: /images/20220315/d86bd2f8bcd64e968d219675cf0f456f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 2]: /images/20220315/fddb413710cb4e96bf0dfdd81fb10fff.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 3]: /images/20220315/24c5c958c6c04943ab23e5b4d8829233.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 4]: /images/20220315/94cb290047a24aebaf78c6442b050013.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 5]: /images/20220315/6fbb2a96673f4442ada98f5e589bda5f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 6]: /images/20220315/75980693c6ae44fa9683d960edcb6278.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 7]: /images/20220315/4655dfed979d4571b5c36cf096d3a2d3.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 8]: /images/20220315/7b8ac6f487bc44b8a01d7ba4486066c2.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 9]: /images/20220315/9785d31e31614a41a716888b24ce2c5c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 10]: /images/20220315/956ab77b860947e7b377434f132b8709.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 11]: /images/20220315/fce00c63f5f742069d796b5afc493095.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 12]: /images/20220315/01e72c731c1e44268f1b79d19f3a3da6.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 13]: /images/20220315/64f54aab976f4b0b85fc933b933e5f58.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 14]: /images/20220315/1df1b3f2e5fc445a90f19b1e4b39c317.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 15]: /images/20220315/f543418963224cb48f43917a6e6fa8c2.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 16]: /images/20220315/d4265be53ffd4bea8a53538a0c419636.png