帆软V2练习题答案和常用案例.zip

资源内容介绍

帆软报表学习习题+经典案例1.基本原理理解2.多源报表3.动态隔间运算4.图表5,参数联动，6超级链接，8填报报表9.填报报表检验10.移动端预览分页、表头固定 还有一些常用美化报表、排序，占比，校验等报表的小案例

SET NAMES utf8mb4;SET FOREIGN_KEY_CHECKS = 0;-- ------------------------------ Table structure for coursegrage-- ----------------------------DROP TABLE IF EXISTS `coursegrage`;CREATE TABLE `coursegrage` ( `id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `studentno` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `course` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `grade` float(20, 0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ------------------------------ Records of coursegrage-- ----------------------------INSERT INTO `coursegrage` VALUES ('', '1702211017', 'math', 10);INSERT INTO `coursegrage` VALUES ('1', '1702211017', 'math', 90);-- ------------------------------ Table structure for studentinfo-- ----------------------------DROP TABLE IF EXISTS `studentinfo`;CREATE TABLE `studentinfo` ( `studentno` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `name` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `classno` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `age` int(12) NULL DEFAULT NULL, `sex` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `address` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `photo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`studentno`) USING BTREE) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ------------------------------ Records of studentinfo-- ----------------------------INSERT INTO `studentinfo` VALUES ('1702211001', 'wlm', 'class1', 10, '女', '深圳市 宝安区 ', '');INSERT INTO `studentinfo` VALUES ('1702211017', 'zll', 'class1', 10, '女', '深圳市 宝安区 ', 'https://ss0.bdstatic.com/70cFuHSh_Q1YnxGkpoWK1HF6hhy/it/u=2853553659,1775735885&fm=26&gp=0.jpg');INSERT INTO `studentinfo` VALUES ('1702211018', 'lo', 'class1', 10, '女', 'c ds sd sd', '');SET FOREIGN_KEY_CHECKS = 1;