当前博客:打印报表中两个表格数据如何展示

79 次浏览【转载需注明来源】

博客作者:【1580****8581】

个性签名:寒窗苦读十年,一朝凤舞九天

打印报表中有两个表格,一个在上边,另外一个在下边,表格数据动态获取,如何定位保证两个表格的数据不受影响?请大佬解答

例如:第一张表有200条数据,而第二张表应该显示在第一张表的后面

默认排序
Generic placeholder image
Generic placeholder image
快码FOF编程 Time: 2024-01-29 15:52:08

重新启动一下IDE,刚推送更新了两个表格的自定义CSS属性,分别是:

"上级组件ID间隔": "10",

 "上级组件ID": "reportFormsTable_1"

其中"上级组件ID"是上面表格的ID,

"上级组件ID间隔": "10", 是下面表格离上面表格的间距。

下面是案例:

案例文件:

双表打印.zip

设计器代码:

{
  "version": "1.0.0",
  "formName": "表单示例",
  "Author": "快码编程UI设计器",
  "formId": "formPreviewForm",
  "generateId": 3,
  "data": [
    {
      "id": "reportFormsTable_1",
      "index": 0,
      "tag": "reportFormsTable",
      "tagIcon": "layui-icon layui-icon-picture",
      "title": "打印表格",
      "width": "100%",
      "height": "250",
      "margin": "",
      "padding": "",
      "left": 0,
      "top": 1,
      "zIndex": 1,
      "reportFormsColumn": 1,
      "reportFormsRow": false,
      "reportFormsColumnMargin": 5,
      "reportFormsSqlType": "普通数据模式",
      "reportFormsDataType": "不跟随数据库变动",
      "reportFormsTableType": false,
      "reportFormsTableRowsSize": "默认尺寸",
      "reportFormsTableLine": "",
      "reportFormsTableHead": "[{\"数据\": [{ \"内容\": \"姓名\",\"宽度\":100 },{ \"内容\": \"年龄\" }]}]",
      "reportFormsTableHeadToolJson": {
        "宽度": 100,
        "高度": 100,
        "内容": "",
        "字体": "微软雅黑",
        "字体尺寸": 14,
        "背景色": "#FFFFFF",
        "文本色": "#000000",
        "元素ID": "",
        "允许输入": true,
        "合并行": 0,
        "合并列": 0,
        "垂直对齐-居中": "居中对齐",
        "垂直对齐-顶部": "顶部对齐",
        "垂直对齐-底部": "底部对齐",
        "水平对齐-居中": "居中对齐",
        "水平对齐-左侧": "左侧对齐",
        "水平对齐-右侧": "右侧对齐",
        "字体类型-加粗": "粗体",
        "字体类型-正常": "正常",
        "边框颜色": "#000",
        "边框粗细": 1,
        "上边框颜色": "#000",
        "上边框粗细": 1,
        "右边框颜色": "#000",
        "右边框粗细": 1,
        "下边框颜色": "#000",
        "下边框粗细": 1,
        "左边框颜色": "#000",
        "左边框粗细": 1,
        "自定义CSS": ""
      },
      "reportFormsTableData": "[{\"数据\": [{ \"内容\": \"张三\" },{ \"内容\": \"24\" }]},{\"数据\": [{ \"内容\": \"李四\" },{ \"内容\": \"25\" }]}]",
      "reportFormsTableDataToolJson": {
        "宽度": 100,
        "高度": 100,
        "内容": "",
        "字体": "微软雅黑",
        "字体尺寸": 14,
        "背景色": "#FFFFFF",
        "文本色": "#000000",
        "元素ID": "",
        "允许输入": true,
        "合并行": 0,
        "合并列": 0,
        "垂直对齐-居中": "居中对齐",
        "垂直对齐-顶部": "顶部对齐",
        "垂直对齐-底部": "底部对齐",
        "水平对齐-居中": "居中对齐",
        "水平对齐-左侧": "左侧对齐",
        "水平对齐-右侧": "右侧对齐",
        "字体类型-加粗": "粗体",
        "字体类型-正常": "正常",
        "边框颜色": "#000",
        "边框粗细": 1,
        "上边框颜色": "#000",
        "上边框粗细": 1,
        "右边框颜色": "#000",
        "右边框粗细": 1,
        "下边框颜色": "#000",
        "下边框粗细": 1,
        "左边框颜色": "#000",
        "左边框粗细": 1,
        "自定义CSS": ""
      },
      "reportFormsStyle": "{\"边框颜色\": \"#eee\"}",
      "reportFormsStyleToolJson": {
        "宽度": 100,
        "高度": 100,
        "字体": "微软雅黑",
        "字体尺寸": 14,
        "背景色": "#FFFFFF",
        "文本色": "#000000",
        "水平对齐-居中": "居中对齐",
        "水平对齐-左侧": "左侧对齐",
        "水平对齐-右侧": "右侧对齐",
        "字体类型-加粗": "粗体",
        "字体类型-正常": "正常",
        "边框颜色": "#000",
        "上边框颜色": "#000",
        "右边框颜色": "#000",
        "下边框颜色": "#000",
        "左边框颜色": "#000",
        "自定义CSS": "",
        "上级组件ID": "",
        "上级组件ID间隔": "10"
      },
      "reportFormsSqlCode_NoBut": "",
      "reportFormsSqlDataName": "[]",
      "reportFormsCode_NoBut": "",
      "grid": false
    },
    {
      "id": "reportFormsTable_2",
      "index": 1,
      "tag": "reportFormsTable",
      "tagIcon": "layui-icon layui-icon-picture",
      "title": "打印表格",
      "width": "100%",
      "height": "250",
      "margin": "",
      "padding": "",
      "left": 0,
      "top": 290,
      "zIndex": 2,
      "reportFormsColumn": 1,
      "reportFormsRow": false,
      "reportFormsColumnMargin": 5,
      "reportFormsSqlType": "普通数据模式",
      "reportFormsDataType": "不跟随数据库变动",
      "reportFormsTableType": false,
      "reportFormsTableRowsSize": "默认尺寸",
      "reportFormsTableLine": "",
      "reportFormsTableHead": "[{\"数据\": [{ \"内容\": \"姓名\",\"宽度\":100 },{ \"内容\": \"年龄\" }]}]",
      "reportFormsTableHeadToolJson": {
        "宽度": 100,
        "高度": 100,
        "内容": "",
        "字体": "微软雅黑",
        "字体尺寸": 14,
        "背景色": "#FFFFFF",
        "文本色": "#000000",
        "元素ID": "",
        "允许输入": true,
        "合并行": 0,
        "合并列": 0,
        "垂直对齐-居中": "居中对齐",
        "垂直对齐-顶部": "顶部对齐",
        "垂直对齐-底部": "底部对齐",
        "水平对齐-居中": "居中对齐",
        "水平对齐-左侧": "左侧对齐",
        "水平对齐-右侧": "右侧对齐",
        "字体类型-加粗": "粗体",
        "字体类型-正常": "正常",
        "边框颜色": "#000",
        "边框粗细": 1,
        "上边框颜色": "#000",
        "上边框粗细": 1,
        "右边框颜色": "#000",
        "右边框粗细": 1,
        "下边框颜色": "#000",
        "下边框粗细": 1,
        "左边框颜色": "#000",
        "左边框粗细": 1,
        "自定义CSS": ""
      },
      "reportFormsTableData": "[{\"数据\": [{ \"内容\": \"张三\" },{ \"内容\": \"24\" }]},{\"数据\": [{ \"内容\": \"李四\" },{ \"内容\": \"25\" }]}]",
      "reportFormsTableDataToolJson": {
        "宽度": 100,
        "高度": 100,
        "内容": "",
        "字体": "微软雅黑",
        "字体尺寸": 14,
        "背景色": "#FFFFFF",
        "文本色": "#000000",
        "元素ID": "",
        "允许输入": true,
        "合并行": 0,
        "合并列": 0,
        "垂直对齐-居中": "居中对齐",
        "垂直对齐-顶部": "顶部对齐",
        "垂直对齐-底部": "底部对齐",
        "水平对齐-居中": "居中对齐",
        "水平对齐-左侧": "左侧对齐",
        "水平对齐-右侧": "右侧对齐",
        "字体类型-加粗": "粗体",
        "字体类型-正常": "正常",
        "边框颜色": "#000",
        "边框粗细": 1,
        "上边框颜色": "#000",
        "上边框粗细": 1,
        "右边框颜色": "#000",
        "右边框粗细": 1,
        "下边框颜色": "#000",
        "下边框粗细": 1,
        "左边框颜色": "#000",
        "左边框粗细": 1,
        "自定义CSS": ""
      },
      "reportFormsStyle": "{\"边框颜色\":\"#eee\",\"上级组件ID间隔\":\"10\",\"上级组件ID\":\"reportFormsTable_1\"}",
      "reportFormsStyleToolJson": {
        "宽度": 100,
        "高度": 100,
        "字体": "微软雅黑",
        "字体尺寸": 14,
        "背景色": "#FFFFFF",
        "文本色": "#000000",
        "水平对齐-居中": "居中对齐",
        "水平对齐-左侧": "左侧对齐",
        "水平对齐-右侧": "右侧对齐",
        "字体类型-加粗": "粗体",
        "字体类型-正常": "正常",
        "边框颜色": "#000",
        "上边框颜色": "#000",
        "右边框颜色": "#000",
        "下边框颜色": "#000",
        "左边框颜色": "#000",
        "自定义CSS": "",
        "上级组件ID": "",
        "上级组件ID间隔": "10"
      },
      "reportFormsSqlCode_NoBut": "",
      "reportFormsSqlDataName": "[]",
      "reportFormsCode_NoBut": "",
      "grid": false
    }
  ],
  "optionsArray": [
    {
      "id": "reportFormsTable_1",
      "index": 0,
      "tag": "reportFormsTable",
      "tagIcon": "layui-icon layui-icon-picture",
      "title": "打印表格",
      "width": "100%",
      "height": "250",
      "margin": "",
      "padding": "",
      "left": 0,
      "top": 1,
      "zIndex": 1,
      "reportFormsColumn": 1,
      "reportFormsRow": false,
      "reportFormsColumnMargin": 5,
      "reportFormsSqlType": "普通数据模式",
      "reportFormsDataType": "不跟随数据库变动",
      "reportFormsTableType": false,
      "reportFormsTableRowsSize": "默认尺寸",
      "reportFormsTableLine": "",
      "reportFormsTableHead": "[{\"数据\": [{ \"内容\": \"姓名\",\"宽度\":100 },{ \"内容\": \"年龄\" }]}]",
      "reportFormsTableHeadToolJson": {
        "宽度": 100,
        "高度": 100,
        "内容": "",
        "字体": "微软雅黑",
        "字体尺寸": 14,
        "背景色": "#FFFFFF",
        "文本色": "#000000",
        "元素ID": "",
        "允许输入": true,
        "合并行": 0,
        "合并列": 0,
        "垂直对齐-居中": "居中对齐",
        "垂直对齐-顶部": "顶部对齐",
        "垂直对齐-底部": "底部对齐",
        "水平对齐-居中": "居中对齐",
        "水平对齐-左侧": "左侧对齐",
        "水平对齐-右侧": "右侧对齐",
        "字体类型-加粗": "粗体",
        "字体类型-正常": "正常",
        "边框颜色": "#000",
        "边框粗细": 1,
        "上边框颜色": "#000",
        "上边框粗细": 1,
        "右边框颜色": "#000",
        "右边框粗细": 1,
        "下边框颜色": "#000",
        "下边框粗细": 1,
        "左边框颜色": "#000",
        "左边框粗细": 1,
        "自定义CSS": ""
      },
      "reportFormsTableData": "[{\"数据\": [{ \"内容\": \"张三\" },{ \"内容\": \"24\" }]},{\"数据\": [{ \"内容\": \"李四\" },{ \"内容\": \"25\" }]}]",
      "reportFormsTableDataToolJson": {
        "宽度": 100,
        "高度": 100,
        "内容": "",
        "字体": "微软雅黑",
        "字体尺寸": 14,
        "背景色": "#FFFFFF",
        "文本色": "#000000",
        "元素ID": "",
        "允许输入": true,
        "合并行": 0,
        "合并列": 0,
        "垂直对齐-居中": "居中对齐",
        "垂直对齐-顶部": "顶部对齐",
        "垂直对齐-底部": "底部对齐",
        "水平对齐-居中": "居中对齐",
        "水平对齐-左侧": "左侧对齐",
        "水平对齐-右侧": "右侧对齐",
        "字体类型-加粗": "粗体",
        "字体类型-正常": "正常",
        "边框颜色": "#000",
        "边框粗细": 1,
        "上边框颜色": "#000",
        "上边框粗细": 1,
        "右边框颜色": "#000",
        "右边框粗细": 1,
        "下边框颜色": "#000",
        "下边框粗细": 1,
        "左边框颜色": "#000",
        "左边框粗细": 1,
        "自定义CSS": ""
      },
      "reportFormsStyle": "{\"边框颜色\": \"#eee\"}",
      "reportFormsStyleToolJson": {
        "宽度": 100,
        "高度": 100,
        "字体": "微软雅黑",
        "字体尺寸": 14,
        "背景色": "#FFFFFF",
        "文本色": "#000000",
        "水平对齐-居中": "居中对齐",
        "水平对齐-左侧": "左侧对齐",
        "水平对齐-右侧": "右侧对齐",
        "字体类型-加粗": "粗体",
        "字体类型-正常": "正常",
        "边框颜色": "#000",
        "上边框颜色": "#000",
        "右边框颜色": "#000",
        "下边框颜色": "#000",
        "左边框颜色": "#000",
        "自定义CSS": "",
        "上级组件ID": "",
        "上级组件ID间隔": "10"
      },
      "reportFormsSqlCode_NoBut": "",
      "reportFormsSqlDataName": "[]",
      "reportFormsCode_NoBut": "",
      "grid": false
    },
    {
      "id": "reportFormsTable_2",
      "index": 1,
      "tag": "reportFormsTable",
      "tagIcon": "layui-icon layui-icon-picture",
      "title": "打印表格",
      "width": "100%",
      "height": "250",
      "margin": "",
      "padding": "",
      "left": 0,
      "top": 290,
      "zIndex": 2,
      "reportFormsColumn": 1,
      "reportFormsRow": false,
      "reportFormsColumnMargin": 5,
      "reportFormsSqlType": "普通数据模式",
      "reportFormsDataType": "不跟随数据库变动",
      "reportFormsTableType": false,
      "reportFormsTableRowsSize": "默认尺寸",
      "reportFormsTableLine": "",
      "reportFormsTableHead": "[{\"数据\": [{ \"内容\": \"姓名\",\"宽度\":100 },{ \"内容\": \"年龄\" }]}]",
      "reportFormsTableHeadToolJson": {
        "宽度": 100,
        "高度": 100,
        "内容": "",
        "字体": "微软雅黑",
        "字体尺寸": 14,
        "背景色": "#FFFFFF",
        "文本色": "#000000",
        "元素ID": "",
        "允许输入": true,
        "合并行": 0,
        "合并列": 0,
        "垂直对齐-居中": "居中对齐",
        "垂直对齐-顶部": "顶部对齐",
        "垂直对齐-底部": "底部对齐",
        "水平对齐-居中": "居中对齐",
        "水平对齐-左侧": "左侧对齐",
        "水平对齐-右侧": "右侧对齐",
        "字体类型-加粗": "粗体",
        "字体类型-正常": "正常",
        "边框颜色": "#000",
        "边框粗细": 1,
        "上边框颜色": "#000",
        "上边框粗细": 1,
        "右边框颜色": "#000",
        "右边框粗细": 1,
        "下边框颜色": "#000",
        "下边框粗细": 1,
        "左边框颜色": "#000",
        "左边框粗细": 1,
        "自定义CSS": ""
      },
      "reportFormsTableData": "[{\"数据\": [{ \"内容\": \"张三\" },{ \"内容\": \"24\" }]},{\"数据\": [{ \"内容\": \"李四\" },{ \"内容\": \"25\" }]}]",
      "reportFormsTableDataToolJson": {
        "宽度": 100,
        "高度": 100,
        "内容": "",
        "字体": "微软雅黑",
        "字体尺寸": 14,
        "背景色": "#FFFFFF",
        "文本色": "#000000",
        "元素ID": "",
        "允许输入": true,
        "合并行": 0,
        "合并列": 0,
        "垂直对齐-居中": "居中对齐",
        "垂直对齐-顶部": "顶部对齐",
        "垂直对齐-底部": "底部对齐",
        "水平对齐-居中": "居中对齐",
        "水平对齐-左侧": "左侧对齐",
        "水平对齐-右侧": "右侧对齐",
        "字体类型-加粗": "粗体",
        "字体类型-正常": "正常",
        "边框颜色": "#000",
        "边框粗细": 1,
        "上边框颜色": "#000",
        "上边框粗细": 1,
        "右边框颜色": "#000",
        "右边框粗细": 1,
        "下边框颜色": "#000",
        "下边框粗细": 1,
        "左边框颜色": "#000",
        "左边框粗细": 1,
        "自定义CSS": ""
      },
      "reportFormsStyle": "{\"边框颜色\":\"#eee\",\"上级组件ID间隔\":\"10\",\"上级组件ID\":\"reportFormsTable_1\"}",
      "reportFormsStyleToolJson": {
        "宽度": 100,
        "高度": 100,
        "字体": "微软雅黑",
        "字体尺寸": 14,
        "背景色": "#FFFFFF",
        "文本色": "#000000",
        "水平对齐-居中": "居中对齐",
        "水平对齐-左侧": "左侧对齐",
        "水平对齐-右侧": "右侧对齐",
        "字体类型-加粗": "粗体",
        "字体类型-正常": "正常",
        "边框颜色": "#000",
        "上边框颜色": "#000",
        "右边框颜色": "#000",
        "下边框颜色": "#000",
        "左边框颜色": "#000",
        "自定义CSS": "",
        "上级组件ID": "",
        "上级组件ID间隔": "10"
      },
      "reportFormsSqlCode_NoBut": "",
      "reportFormsSqlDataName": "[]",
      "reportFormsCode_NoBut": "",
      "grid": false
    }
  ],
  "dataSource": {},
  "formData": {},
  "globalDisable": false,
  "viewOrDesign": true,
  "formDefaultButton": true,
  "formProperty": {},
  "selectItems": [],
  "model": "A4",
  "page": {
    "id": ""
  },
  "elem": {
    "0": {
      "sizzle1706509822161": {
        "undefined": {
          "parentNode": [
            8835,
            19,
            false
          ]
        }
      },
      "sizzle1706509822448": {
        "undefined": {
          "parentNode": [
            1131,
            34,
            true
          ]
        }
      }
    },
    "length": 1
  },
  "id": "formdesigner",
  "size": [
    "21cm",
    "29.7cm"
  ],
  "selectItem": {
    "id": "reportFormsTable_2",
    "index": 1,
    "tag": "reportFormsTable",
    "tagIcon": "layui-icon layui-icon-picture",
    "title": "打印表格",
    "width": "100%",
    "height": "250",
    "margin": "",
    "padding": "",
    "left": 0,
    "top": 290,
    "zIndex": 2,
    "reportFormsColumn": 1,
    "reportFormsRow": false,
    "reportFormsColumnMargin": 5,
    "reportFormsSqlType": "普通数据模式",
    "reportFormsDataType": "不跟随数据库变动",
    "reportFormsTableType": false,
    "reportFormsTableRowsSize": "默认尺寸",
    "reportFormsTableLine": "",
    "reportFormsTableHead": "[{\"数据\": [{ \"内容\": \"姓名\",\"宽度\":100 },{ \"内容\": \"年龄\" }]}]",
    "reportFormsTableHeadToolJson": {
      "宽度": 100,
      "高度": 100,
      "内容": "",
      "字体": "微软雅黑",
      "字体尺寸": 14,
      "背景色": "#FFFFFF",
      "文本色": "#000000",
      "元素ID": "",
      "允许输入": true,
      "合并行": 0,
      "合并列": 0,
      "垂直对齐-居中": "居中对齐",
      "垂直对齐-顶部": "顶部对齐",
      "垂直对齐-底部": "底部对齐",
      "水平对齐-居中": "居中对齐",
      "水平对齐-左侧": "左侧对齐",
      "水平对齐-右侧": "右侧对齐",
      "字体类型-加粗": "粗体",
      "字体类型-正常": "正常",
      "边框颜色": "#000",
      "边框粗细": 1,
      "上边框颜色": "#000",
      "上边框粗细": 1,
      "右边框颜色": "#000",
      "右边框粗细": 1,
      "下边框颜色": "#000",
      "下边框粗细": 1,
      "左边框颜色": "#000",
      "左边框粗细": 1,
      "自定义CSS": ""
    },
    "reportFormsTableData": "[{\"数据\": [{ \"内容\": \"张三\" },{ \"内容\": \"24\" }]},{\"数据\": [{ \"内容\": \"李四\" },{ \"内容\": \"25\" }]}]",
    "reportFormsTableDataToolJson": {
      "宽度": 100,
      "高度": 100,
      "内容": "",
      "字体": "微软雅黑",
      "字体尺寸": 14,
      "背景色": "#FFFFFF",
      "文本色": "#000000",
      "元素ID": "",
      "允许输入": true,
      "合并行": 0,
      "合并列": 0,
      "垂直对齐-居中": "居中对齐",
      "垂直对齐-顶部": "顶部对齐",
      "垂直对齐-底部": "底部对齐",
      "水平对齐-居中": "居中对齐",
      "水平对齐-左侧": "左侧对齐",
      "水平对齐-右侧": "右侧对齐",
      "字体类型-加粗": "粗体",
      "字体类型-正常": "正常",
      "边框颜色": "#000",
      "边框粗细": 1,
      "上边框颜色": "#000",
      "上边框粗细": 1,
      "右边框颜色": "#000",
      "右边框粗细": 1,
      "下边框颜色": "#000",
      "下边框粗细": 1,
      "左边框颜色": "#000",
      "左边框粗细": 1,
      "自定义CSS": ""
    },
    "reportFormsStyle": "{\"边框颜色\":\"#eee\",\"上级组件ID间隔\":\"10\",\"上级组件ID\":\"reportFormsTable_1\"}",
    "reportFormsStyleToolJson": {
      "宽度": 100,
      "高度": 100,
      "字体": "微软雅黑",
      "字体尺寸": 14,
      "背景色": "#FFFFFF",
      "文本色": "#000000",
      "水平对齐-居中": "居中对齐",
      "水平对齐-左侧": "左侧对齐",
      "水平对齐-右侧": "右侧对齐",
      "字体类型-加粗": "粗体",
      "字体类型-正常": "正常",
      "边框颜色": "#000",
      "上边框颜色": "#000",
      "右边框颜色": "#000",
      "下边框颜色": "#000",
      "左边框颜色": "#000",
      "自定义CSS": "",
      "上级组件ID": "",
      "上级组件ID间隔": "10"
    },
    "reportFormsSqlCode_NoBut": "",
    "reportFormsSqlDataName": "[]",
    "reportFormsCode_NoBut": "",
    "grid": false
  },
  "selectItemsAttr": false
}

打印报表中两个表格数据如何展示