JasperReport制作⾏内容合并的表格效果图: 交叉表
另⼀个思路:中国矿业114网
br710
普通表格
准备⼯作
⼀、数据准备
DROP TABLE IF EXISTS `address_item_sex_value`;
CREATE TABLE `address_item_sex_value` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`address` varchar(255) DEFAULT NULL,
`sex` varchar(255) DEFAULT NULL,
`item` varchar(255) DEFAULT NULL,
`value` int(11) DEFAULT NULL,
`proportion` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of address_item_sex_value
-- ----------------------------
INSERT INTO `address_item_sex_value` VALUES ('1', '城区', '男⽣', '指标1', '2', '50');
INSERT INTO `address_item_sex_value` VALUES ('2', '远郊', '男⽣', '指标1', '3', '40');
INSERT INTO `address_item_sex_value` VALUES ('3', '近郊', '男⽣', '指标1', '1', '60');
INSERT INTO `address_item_sex_value` VALUES ('9', '城区', '⼥⽣', '指标1', '3', '40');
INSERT INTO `address_item_sex_value` VALUES ('10', '远郊', '⼥⽣', '指标1', '5', '50');
INSERT INTO `address_item_sex_value` VALUES ('11', '近郊', '⼥⽣', '指标1', '4', '60');
INSERT INTO `address_item_sex_value` VALUES ('15', '城区', '男⽣', '指标2', '6', '70');
INSERT INTO `address_item_sex_value` VALUES ('16', '远郊', '男⽣', '指标2', '3', '50');
INSERT INTO `address_item_sex_value` VALUES ('17', '近郊', '男⽣', '指标2', '5', '30');
抗弯强度INSERT INTO `address_item_sex_value` VALUES ('18', '城区', '⼥⽣', '指标2', '7', '20');
INSERT INTO `address_item_sex_value` VALUES ('19', '远郊', '⼥⽣', '指标2', '3', '10');
INSERT INTO `address_item_sex_value` VALUES ('20', '近郊', '⼥⽣', '指标2', '6', '50');
INSERT INTO `address_item_sex_value` VALUES ('21', '城区', '男⽣', '指标3', '2', '50');
INSERT INTO `address_item_sex_value` VALUES ('22', '远郊', '男⽣', '指标3', '3', '40');
INSERT INTO `address_item_sex_value` VALUES ('23', '近郊', '男⽣', '指标3', '1', '60');
INSERT INTO `address_item_sex_value` VALUES ('25', '城区', '⼥⽣', '指标3', '3', '40');
INSERT INTO `address_item_sex_value` VALUES ('26', '远郊', '⼥⽣', '指标3', '5', '50');
INSERT INTO `address_item_sex_value` VALUES ('27', '近郊', '⼥⽣', '指标3', '4', '60');
原子能INSERT INTO `address_item_sex_value` VALUES ('28', '城区', '男⽣', '指标4', '6', '70');
INSERT INTO `address_item_sex_value` VALUES ('29', '远郊', '男⽣', '指标4', '3', '50');
INSERT INTO `address_item_sex_value` VALUES ('30', '近郊', '男⽣', '指标4', '5', '30');
INSERT INTO `address_item_sex_value` VALUES ('31', '城区', '⼥⽣', '指标4', '7', '20');
INSERT INTO `address_item_sex_value` VALUES ('32', '远郊', '⼥⽣', '指标4', '3', '10');
INSERT INTO `address_item_sex_value` VALUES ('33', '近郊', '⼥⽣', '指标4', '6', '50');甲壳素壳聚糖
SELECT report.address_item_sex_value.id,
report.address_item_sex_value.address,
report.address_item_sex_value.sex,
report.address_item_sex_value.item,
report.address_item_sex_value.value,
1 a
FROM report.address_item_sex_value order by report.address_item_sex_value.address
卡西族SQL中有⼀个空闲的字段a、有⼀个默认值。很重要、是为了X轴的交叉表做考虑三、设计列表
设置横列
1、选择字段a
2、设置total(按需要、这⾥不需要汇总列)
设置竖列
设置交叉值
四、设计显⽰
删除横列值
设置Column groups⾼度
设置⾼度为 0px
效果图
设置⽔平居中、垂直居中
表头放在ColumnHeader⾥⾯,按需⾃⼰组装即可。
最终效果图