报表公共参数使用问题

Bella.Yuan

{"Name":"Report","Width":"16cm","Layers":[{"Name":"default"}],"CustomProperties":[{"Name":"DisplayType","Value":"Page"},{"Name":"SizeType","Value":"Default"},{"Name":"PaperOrientation","Value":"Portrait"}],"Page":{"PageWidth":"21cm","PageHeight":"29.7cm","RightMargin":"2.5cm","LeftMargin":"2.5cm","TopMargin":"2.5cm","BottomMargin":"2.5cm","Columns":1,"ColumnSpacing":"0cm"},"DataSources":[{"Name":"DataSource","ConnectionProperties":{"DataProvider":"JSONEMBED","ConnectString":"jsondata=[{\\n "标题": "标题1",\\n "副标题": "副标题1",\\n "日期": "2012-05-06",\\n "签名人": "老王",\\n "图片": "http://nacos.pj1.paas.dhc.com.cn:30000/nacos/img/logo-2000-390.svg"\\n}]"}},{"Name":"DataSource1","ConnectionProperties":{"DataProvider":"JSONEMBED","ConnectString":"jsondata=[{\\n "订单ID": 11074,\\n "客户ID": "SIMOB",\\n "订购日期": "2012-05-06",\\n "产品名称": "饼干",\\n "数量": 14,\\n "单价": 17.45,\\n "折扣": 0.05,\\n "货主城市": "温州",\\n "货主地址": "巩东路 3 号",\\n "货主名称": "何先生",\\n "货主邮政编码": "173400",\\n\\t"图片": "http://nacos.pj1.paas.dhc.com.cn:30000/nacos/img/logo-2000-390.svg",\\n "电话": "(030) 31123456"\\n}, {\\n "订单ID": 11075,\\n "客户ID": "RICSU",\\n "订购日期": "2012-05-06",\\n "产品名称": "牛奶",\\n "数量": 10,\\n "单价": 19,\\n "折扣": 0.15,\\n "货主城市": "常州",\\n "货主地址": "成昆路 524 号",\\n "货主名称": "方先生",\\n "货主邮政编码": "120400",\\n\\t"图片": "http://nacos.pj1.paas.dhc.com.cn:30000/nacos/img/logo-2000-390.svg",\\n "电话": "(089) 7034214"\\n}, {\\n "订单ID": 11075,\\n "客户ID": "RICSU",\\n "订购日期": "2012-05-06",\\n "产品名称": "蚵",\\n "数量": 30,\\n "单价": 12,\\n "折扣": 0.15,\\n "货主城市": "常州",\\n "货主地址": "成昆路 524 号",\\n "货主名称": "方先生",\\n "货主邮政编码": "120400",\\n\\t"图片": "http://nacos.pj1.paas.dhc.com.cn:30000/nacos/img/logo-2000-390.svg",\\n "电话": "(089) 7034214"\\n}, {\\n "订单ID": 11075,\\n "客户ID": "RICSU",\\n "订购日期": "2012-05-06",\\n "产品名称": "柠檬汁",\\n "数量": 2,\\n "单价": 18,\\n "折扣": 0.15,\\n "货主城市": "常州",\\n "货主地址": "成昆路 524 号",\\n "货主名称": "方先生",\\n "货主邮政编码": "120400",\\n\\t"图片": "http://nacos.pj1.paas.dhc.com.cn:30000/nacos/img/logo-2000-390.svg",\\n "电话": "(089) 7034214"\\n}, {\\n "订单ID": 11076,\\n "客户ID": "BONAP",\\n "订购日期": "2012-05-06",\\n "产品名称": "酱油",\\n "数量": 20,\\n "单价": 25,\\n "折扣": 0.25,\\n "货主城市": "常州",\\n "货主地址": "季源南路 25 号",\\n "货主名称": "谢小姐",\\n "货主邮政编码": "130080",\\n\\t"图片": "http://nacos.pj1.paas.dhc.com.cn:30000/nacos/img/logo-2000-390.svg",\\n "电话": "(078) 91244540"\\n}, {\\n "订单ID": 11076,\\n "客户ID": "BONAP",\\n "订购日期": "2012-05-06",\\n "产品名称": "沙茶",\\n "数量": 20,\\n "单价": 23.25,\\n "折扣": 0.25,\\n "货主城市": "常州",\\n "货主地址": "季源南路 25 号",\\n "货主名称": "谢小姐",\\n "货主邮政编码": "130080",\\n\\t"图片": "http://nacos.pj1.paas.dhc.com.cn:30000/nacos/img/logo-2000-390.svg",\\n "电话": "(078) 91244540"\\n}, {\\n "订单ID": 11076,\\n "客户ID": "BONAP",\\n "订购日期": "2012-05-06",\\n "产品名称": "糖果",\\n "数量": 10,\\n "单价": 9.2,\\n "折扣": 0.25,\\n "货主城市": "常州",\\n "货主地址": "季源南路 25 号",\\n "货主名称": "谢小姐",\\n "货主邮政编码": "130080",\\n\\t"图片": "http://nacos.pj1.paas.dhc.com.cn:30000/nacos/img/logo-2000-390.svg",\\n "电话": "(078) 91244540"\\n}, {\\n "订单ID": 11077,\\n "客户ID": "RATTC",\\n "订购日期": "2012-05-06",\\n "产品名称": "牛奶",\\n "数量": 24,\\n "单价": 19,\\n "折扣": 0.2,\\n "货主城市": "深圳",\\n "货主地址": "宽石西路 37 号",\\n "货主名称": "王先生",\\n "货主邮政编码": "871100",\\n\\t"图片": "http://nacos.pj1.paas.dhc.com.cn:30000/nacos/img/logo-2000-390.svg",\\n "电话": "(055) 5555939"\\n}, {\\n "订单ID": 11077,\\n "客户ID": "RATTC",\\n "订购日期": "2012-05-06",\\n "产品名称": "蕃茄酱",\\n "数量": 4,\\n "单价": 10,\\n "折扣": 0,\\n "货主城市": "深圳",\\n "货主地址": "宽石西路 37 号",\\n "货主名称": "王先生",\\n "货主邮政编码": "871100",\\n\\t"图片": "http://nacos.pj1.paas.dhc.com.cn:30000/nacos/img/logo-2000-390.svg",\\n "电话": "(055) 5555939"\\n}, {\\n "订单ID": 11077,\\n "客户ID": "RATTC",\\n "订购日期": "2012-05-06",\\n "产品名称": "盐",\\n "数量": 1,\\n "单价": 22,\\n "折扣": 0,\\n "货主城市": "深圳",\\n "货主地址": "宽石西路 37 号",\\n "货主名称": "王先生",\\n "货主邮政编码": "871100",\\n\\t"图片": "http://nacos.pj1.paas.dhc.com.cn:30000/nacos/img/logo-2000-390.svg",\\n "电话": "(055) 5555939"\\n},\\n{\\n "订单ID": 11074,\\n "客户ID": "SIMOB",\\n "订购日期": "2012-05-06",\\n "产品名称": "饼干",\\n "数量": 14,\\n "单价": 17.45,\\n "折扣": 0.05,\\n "货主城市": "温州",\\n "货主地址": "巩东路 3 号",\\n "货主名称": "何先生",\\n "货主邮政编码": "173400",\\n\\t"图片": "http://nacos.pj1.paas.dhc.com.cn:30000/nacos/img/logo-2000-390.svg",\\n "电话": "(030) 31123456"\\n}, {\\n "订单ID": 11075,\\n "客户ID": "RICSU",\\n "订购日期": "2012-05-06",\\n "产品名称": "牛奶",\\n "数量": 10,\\n "单价": 19,\\n "折扣": 0.15,\\n "货主城市": "常州",\\n "货主地址": "成昆路 524 号",\\n "货主名称": "方先生",\\n "货主邮政编码": "120400",\\n\\t"图片": "http://nacos.pj1.paas.dhc.com.cn:30000/nacos/img/logo-2000-390.svg",\\n "电话": "(089) 7034214"\\n}, {\\n "订单ID": 11075,\\n "客户ID": "RICSU",\\n "订购日期": "2012-05-06",\\n "产品名称": "蚵",\\n "数量": 30,\\n "单价": 12,\\n "折扣": 0.15,\\n "货主城市": "常州",\\n "货主地址": "成昆路 524 号",\\n "货主名称": "方先生",\\n "货主邮政编码": "120400",\\n\\t"图片": "http://nacos.pj1.paas.dhc.com.cn:30000/nacos/img/logo-2000-390.svg",\\n "电话": "(089) 7034214"\\n}, {\\n "订单ID": 11075,\\n "客户ID": "RICSU",\\n "订购日期": "2012-05-06",\\n "产品名称": "柠檬汁",\\n "数量": 2,\\n "单价": 18,\\n "折扣": 0.15,\\n "货主城市": "常州",\\n "货主地址": "成昆路 524 号",\\n "货主名称": "方先生",\\n "货主邮政编码": "120400",\\n\\t"图片": "http://nacos.pj1.paas.dhc.com.cn:30000/nacos/img/logo-2000-390.svg",\\n "电话": "(089) 7034214"\\n}, {\\n "订单ID": 11076,\\n "客户ID": "BONAP",\\n "订购日期": "2012-05-06",\\n "产品名称": "酱油",\\n "数量": 20,\\n "单价": 25,\\n "折扣": 0.25,\\n "货主城市": "常州",\\n "货主地址": "季源南路 25 号",\\n "货主名称": "谢小姐",\\n "货主邮政编码": "130080",\\n\\t"图片": "http://nacos.pj1.paas.dhc.com.cn:30000/nacos/img/logo-2000-390.svg",\\n "电话": "(078) 91244540"\\n}, {\\n "订单ID": 11076,\\n "客户ID": "BONAP",\\n "订购日期": "2012-05-06",\\n "产品名称": "沙茶",\\n "数量": 20,\\n "单价": 23.25,\\n "折扣": 0.25,\\n "货主城市": "常州",\\n "货主地址": "季源南路 25 号",\\n "货主名称": "谢小姐",\\n "货主邮政编码": "130080",\\n\\t"图片": "http://nacos.pj1.paas.dhc.com.cn:30000/nacos/img/logo-2000-390.svg",\\n "电话": "(078) 91244540"\\n}, {\\n "订单ID": 11076,\\n "客户ID": "BONAP",\\n "订购日期": "2012-05-06",\\n "产品名称": "糖果",\\n "数量": 10,\\n "单价": 9.2,\\n "折扣": 0.25,\\n "货主城市": "常州",\\n "货主地址": "季源南路 25 号",\\n "货主名称": "谢小姐",\\n "货主邮政编码": "130080",\\n\\t"图片": "http://nacos.pj1.paas.dhc.com.cn:30000/nacos/img/logo-2000-390.svg",\\n "电话": "(078) 91244540"\\n}, {\\n "订单ID": 11077,\\n "客户ID": "RATTC",\\n "订购日期": "2012-05-06",\\n "产品名称": "牛奶",\\n "数量": 24,\\n "单价": 19,\\n "折扣": 0.2,\\n "货主城市": "深圳",\\n "货主地址": "宽石西路 37 号",\\n "货主名称": "王先生",\\n "货主邮政编码": "871100",\\n\\t"图片": "http://nacos.pj1.paas.dhc.com.cn:30000/nacos/img/logo-2000-390.svg",\\n "电话": "(055) 5555939"\\n}, {\\n "订单ID": 11077,\\n "客户ID": "RATTC",\\n "订购日期": "2012-05-06",\\n "产品名称": "蕃茄酱",\\n "数量": 4,\\n "单价": 10,\\n "折扣": 0,\\n "货主城市": "深圳",\\n "货主地址": "宽石西路 37 号",\\n "货主名称": "王先生",\\n "货主邮政编码": "871100",\\n\\t"图片": "http://nacos.pj1.paas.dhc.com.cn:30000/nacos/img/logo-2000-390.svg",\\n "电话": "(055) 5555939"\\n}, {\\n "订单ID": 11077,\\n "客户ID": "RATTC",\\n "订购日期": "2012-05-06",\\n "产品名称": "盐",\\n "数量": 1,\\n "单价": 22,\\n "折扣": 0,\\n "货主城市": "深圳",\\n "货主地址": "宽石西路 37 号",\\n "货主名称": "王先生",\\n "货主邮政编码": "871100",\\n\\t"图片": "http://nacos.pj1.paas.dhc.com.cn:30000/nacos/img/logo-2000-390.svg",\\n "电话": "(055) 5555939"\\n},\\n{\\n "订单ID": 11074,\\n "客户ID": "SIMOB",\\n "订购日期": "2012-05-06",\\n "产品名称": "饼干",\\n "数量": 14,\\n "单价": 17.45,\\n "折扣": 0.05,\\n "货主城市": "温州",\\n "货主地址": "巩东路 3 号",\\n "货主名称": "何先生",\\n "货主邮政编码": "173400",\\n\\t"图片": "http://nacos.pj1.paas.dhc.com.cn:30000/nacos/img/logo-2000-390.svg",\\n "电话": "(030) 31123456"\\n}, {\\n "订单ID": 11075,\\n "客户ID": "RICSU",\\n "订购日期": "2012-05-06",\\n "产品名称": "牛奶",\\n "数量": 10,\\n "单价": 19,\\n "折扣": 0.15,\\n "货主城市": "常州",\\n "货主地址": "成昆路 524 号",\\n "货主名称": "方先生",\\n "货主邮政编码": "120400",\\n\\t"图片": "http://nacos.pj1.paas.dhc.com.cn:30000/nacos/img/logo-2000-390.svg",\\n "电话": "(089) 7034214"\\n}, {\\n "订单ID": 11075,\\n "客户ID": "RICSU",\\n "订购日期": "2012-05-06",\\n "产品名称": "蚵",\\n "数量": 30,\\n "单价": 12,\\n "折扣": 0.15,\\n "货主城市": "常州",\\n "货主地址": "成昆路 524 号",\\n "货主名称": "方先生",\\n "货主邮政编码": "120400",\\n\\t"图片": "http://nacos.pj1.paas.dhc.com.cn:30000/nacos/img/logo-2000-390.svg",\\n "电话": "(089) 7034214"\\n}, {\\n "订单ID": 11075,\\n "客户ID": "RICSU",\\n "订购日期": "2012-05-06",\\n "产品名称": "柠檬汁",\\n "数量": 2,\\n "单价": 18,\\n "折扣": 0.15,\\n "货主城市": "常州",\\n "货主地址": "成昆路 524 号",\\n "货主名称": "方先生",\\n "货主邮政编码": "120400",\\n\\t"图片": "http://nacos.pj1.paas.dhc.com.cn:30000/nacos/img/logo-2000-390.svg",\\n "电话": "(089) 7034214"\\n}, {\\n "订单ID": 11076,\\n "客户ID": "BONAP",\\n "订购日期": "2012-05-06",\\n "产品名称": "酱油",\\n "数量": 20,\\n "单价": 25,\\n "折扣": 0.25,\\n "货主城市": "常州",\\n "货主地址": "季源南路 25 号",\\n "货主名称": "谢小姐",\\n "货主邮政编码": "130080",\\n\\t"图片": "http://nacos.pj1.paas.dhc.com.cn:30000/nacos/img/logo-2000-390.svg",\\n "电话": "(078) 91244540"\\n}, {\\n "订单ID": 11076,\\n "客户ID": "BONAP",\\n "订购日期": "2012-05-06",\\n "产品名称": "沙茶",\\n "数量": 20,\\n "单价": 23.25,\\n "折扣": 0.25,\\n "货主城市": "常州",\\n "货主地址": "季源南路 25 号",\\n "货主名称": "谢小姐",\\n "货主邮政编码": "130080",\\n\\t"图片": "http://nacos.pj1.paas.dhc.com.cn:30000/nacos/img/logo-2000-390.svg",\\n "电话": "(078) 91244540"\\n}, {\\n "订单ID": 11076,\\n "客户ID": "BONAP",\\n "订购日期": "2012-05-06",\\n "产品名称": "糖果",\\n "数量": 10,\\n "单价": 9.2,\\n "折扣": 0.25,\\n "货主城市": "常州",\\n "货主地址": "季源南路 25 号",\\n "货主名称": "谢小姐",\\n "货主邮政编码": "130080",\\n\\t"图片": "http://nacos.pj1.paas.dhc.com.cn:30000/nacos/img/logo-2000-390.svg",\\n "电话": "(078) 91244540"\\n}, {\\n "订单ID": 11077,\\n "客户ID": "RATTC",\\n "订购日期": "2012-05-06",\\n "产品名称": "牛奶",\\n "数量": 24,\\n "单价": 19,\\n "折扣": 0.2,\\n "货主城市": "深圳",\\n "货主地址": "宽石西路 37 号",\\n "货主名称": "王先生",\\n "货主邮政编码": "871100",\\n\\t"图片": "http://nacos.pj1.paas.dhc.com.cn:30000/nacos/img/logo-2000-390.svg",\\n "电话": "(055) 5555939"\\n}, {\\n "订单ID": 11077,\\n "客户ID": "RATTC",\\n "订购日期": "2012-05-06",\\n "产品名称": "蕃茄酱",\\n "数量": 4,\\n "单价": 10,\\n "折扣": 0,\\n "货主城市": "深圳",\\n "货主地址": "宽石西路 37 号",\\n "货主名称": "王先生",\\n "货主邮政编码": "871100",\\n\\t"图片": "http://nacos.pj1.paas.dhc.com.cn:30000/nacos/img/logo-2000-390.svg",\\n "电话": "(055) 5555939"\\n}, {\\n "订单ID": 11077,\\n "客户ID": "RATTC",\\n "订购日期": "2012-05-06",\\n "产品名称": "盐",\\n "数量": 1,\\n "单价": 22,\\n "折扣": 0,\\n "货主城市": "深圳",\\n "货主地址": "宽石西路 37 号",\\n "货主名称": "王先生",\\n "货主邮政编码": "871100",\\n\\t"图片": "http://nacos.pj1.paas.dhc.com.cn:30000/nacos/img/logo-2000-390.svg",\\n "电话": "(055) 5555939"\\n},\\n{\\n "订单ID": 11074,\\n "客户ID": "SIMOB",\\n "订购日期": "2012-05-06",\\n "产品名称": "饼干",\\n "数量": 14,\\n "单价": 17.45,\\n "折扣": 0.05,\\n "货主城市": "温州",\\n "货主地址": "巩东路 3 号",\\n "货主名称": "何先生",\\n "货主邮政编码": "173400",\\n\\t"图片": "http://nacos.pj1.paas.dhc.com.cn:30000/nacos/img/logo-2000-390.svg",\\n "电话": "(030) 31123456"\\n}, {\\n "订单ID": 11075,\\n "客户ID": "RICSU",\\n "订购日期": "2012-05-06",\\n "产品名称": "牛奶",\\n "数量": 10,\\n "单价": 19,\\n "折扣": 0.15,\\n "货主城市": "常州",\\n "货主地址": "成昆路 524 号",\\n "货主名称": "方先生",\\n "货主邮政编码": "120400",\\n\\t"图片": "http://nacos.pj1.paas.dhc.com.cn:30000/nacos/img/logo-2000-390.svg",\\n "电话": "(089) 7034214"\\n}, {\\n "订单ID": 11075,\\n "客户ID": "RICSU",\\n "订购日期": "2012-05-06",\\n "产品名称": "蚵",\\n "数量": 30,\\n "单价": 12,\\n "折扣": 0.15,\\n "货主城市": "常州",\\n "货主地址": "成昆路 524 号",\\n "货主名称": "方先生",\\n "货主邮政编码": "120400",\\n\\t"图片": "http://nacos.pj1.paas.dhc.com.cn:30000/nacos/img/logo-2000-390.svg",\\n "电话": "(089) 7034214"\\n}, {\\n "订单ID": 11075,\\n "客户ID": "RICSU",\\n "订购日期": "2012-05-06",\\n "产品名称": "柠檬汁",\\n "数量": 2,\\n "单价": 18,\\n "折扣": 0.15,\\n "货主城市": "常州",\\n "货主地址": "成昆路 524 号",\\n "货主名称": "方先生",\\n "货主邮政编码": "120400",\\n\\t"图片": "http://nacos.pj1.paas.dhc.com.cn:30000/nacos/img/logo-2000-390.svg",\\n "电话": "(089) 7034214"\\n}, {\\n "订单ID": 11076,\\n "客户ID": "BONAP",\\n "订购日期": "2012-05-06",\\n "产品名称": "酱油",\\n "数量": 20,\\n "单价": 25,\\n "折扣": 0.25,\\n "货主城市": "常州",\\n "货主地址": "季源南路 25 号",\\n "货主名称": "谢小姐",\\n "货主邮政编码": "130080",\\n\\t"图片": "http://nacos.pj1.paas.dhc.com.cn:30000/nacos/img/logo-2000-390.svg",\\n "电话": "(078) 91244540"\\n}, {\\n "订单ID": 11076,\\n "客户ID": "BONAP",\\n "订购日期": "2012-05-06",\\n "产品名称": "沙茶",\\n "数量": 20,\\n "单价": 23.25,\\n "折扣": 0.25,\\n "货主城市": "常州",\\n "货主地址": "季源南路 25 号",\\n "货主名称": "谢小姐",\\n "货主邮政编码": "130080",\\n\\t"图片": "http://nacos.pj1.paas.dhc.com.cn:30000/nacos/img/logo-2000-390.svg",\\n "电话": "(078) 91244540"\\n}, {\\n "订单ID": 11076,\\n "客户ID": "BONAP",\\n "订购日期": "2012-05-06",\\n "产品名称": "糖果",\\n "数量": 10,\\n "单价": 9.2,\\n "折扣": 0.25,\\n "货主城市": "常州",\\n "货主地址": "季源南路 25 号",\\n "货主名称": "谢小姐",\\n "货主邮政编码": "130080",\\n\\t"图片": "http://nacos.pj1.paas.dhc.com.cn:30000/nacos/img/logo-2000-390.svg",\\n "电话": "(078) 91244540"\\n}, {\\n "订单ID": 11077,\\n "客户ID": "RATTC",\\n "订购日期": "2012-05-06",\\n "产品名称": "牛奶",\\n "数量": 24,\\n "单价": 19,\\n "折扣": 0.2,\\n "货主城市": "深圳",\\n "货主地址": "宽石西路 37 号",\\n "货主名称": "王先生",\\n "货主邮政编码": "871100",\\n\\t"图片": "http://nacos.pj1.paas.dhc.com.cn:30000/nacos/img/logo-2000-390.svg",\\n "电话": "(055) 5555939"\\n}, {\\n "订单ID": 11077,\\n "客户ID": "RATTC",\\n "订购日期": "2012-05-06",\\n "产品名称": "蕃茄酱",\\n "数量": 4,\\n "单价": 10,\\n "折扣": 0,\\n "货主城市": "深圳",\\n "货主地址": "宽石西路 37 号",\\n "货主名称": "王先生",\\n "货主邮政编码": "871100",\\n\\t"图片": "http://nacos.pj1.paas.dhc.com.cn:30000/nacos/img/logo-2000-390.svg",\\n "电话": "(055) 5555939"\\n}, {\\n "订单ID": 11077,\\n "客户ID": "RATTC",\\n "订购日期": "2012-05-06",\\n "产品名称": "盐",\\n "数量": 1,\\n "单价": 22,\\n "折扣": 0,\\n "货主城市": "深圳",\\n "货主地址": "宽石西路 37 号",\\n "货主名称": "王先生",\\n "货主邮政编码": "871100",\\n\\t"图片": "http://nacos.pj1.paas.dhc.com.cn:30000/nacos/img/logo-2000-390.svg",\\n "电话": "(055) 5555939"\\n}]\\n"}}],"Body":{"Height":"3.75cm","ReportItems":[{"Type":"table","Name":"表格1","DataSetName":"DataSet","TableColumns":[{"Width":"2.667cm"},{"Width":"2.667cm"},{"Width":"2.667cm"},{"Width":"2.667cm"},{"Width":"2.667cm"},{"Width":"2.665cm"}],"Header":{"TableRows":[{"Height":"0.75cm","TableCells":[{"Item":{"Type":"textbox","Name":"文本框1","DataElementName":"TextBox2","CanGrow":true,"KeepTogether":true,"Style":{"PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt"},"Width":"2.667cm","Height":"0.75cm"}},{"Item":{"Type":"textbox","Name":"文本框5","DataElementName":"TextBox1","CanGrow":true,"KeepTogether":true,"Style":{"PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt"},"Left":"0cm","Top":"0cm","Width":"2.667cm","Height":"0.75cm"}},{"Item":{"Type":"textbox","Name":"文本框13","DataElementName":"标题","CanGrow":true,"KeepTogether":true,"Value":"=Fields!标题.Value","Style":{"PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center"},"Left":"0cm","Top":"0cm","Width":"5.334cm","Height":"0.75cm"},"ColSpan":2},null,{"Item":{"Type":"textbox","Name":"文本框2","DataElementName":"TextBox3","CanGrow":true,"KeepTogether":true,"Style":{"PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt"},"Width":"2.667cm","Height":"0.75cm"}},{"Item":{"Type":"textbox","Name":"文本框3","DataElementName":"日期","CanGrow":true,"KeepTogether":true,"Value":"=Fields!日期.Value","Style":{"PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Right"},"Width":"2.665cm","Height":"0.75cm"}}]}],"RepeatOnNewPage":true},"Details":{"TableRows":[{"Height":"0.75cm","TableCells":[{"Item":{"Type":"textbox","Name":"文本框4","DataElementName":"TextBox5","CanGrow":true,"KeepTogether":true,"Style":{"PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt"},"Width":"2.667cm","Height":"0.75cm"}},{"Item":{"Type":"textbox","Name":"文本框17","DataElementName":"副标题","CanGrow":true,"KeepTogether":true,"Value":"=Fields!副标题.Value","Style":{"PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center"},"Left":"0cm","Top":"0cm","Width":"10.668cm","Height":"0.75cm"},"ColSpan":4},null,null,null,{"Item":{"Type":"textbox","Name":"文本框6","DataElementName":"TextBox7","CanGrow":true,"KeepTogether":true,"Style":{"PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt"},"Width":"2.665cm","Height":"0.75cm"}}]}],"Group":{"PageBreakDisabled":"false"}},"Footer":{"TableRows":[{"Height":"0.75cm","TableCells":[{"Item":{"Type":"textbox","Name":"文本框7","DataElementName":"TextBox8","CanGrow":true,"KeepTogether":true,"Value":"占位1","Style":{"PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt"},"Width":"2.667cm","Height":"0.75cm"}},{"Item":{"Type":"textbox","Name":"文本框18","DataElementName":"TextBox1","CanGrow":true,"KeepTogether":true,"Value":"占位2","Style":{"PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt"},"Left":"0cm","Top":"0cm","Width":"2.667cm","Height":"0.75cm"}},{"Item":{"Type":"textbox","Name":"文本框15","DataElementName":"TextBox1","CanGrow":true,"KeepTogether":true,"Value":"占位3","Style":{"PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt"},"Left":"0cm","Top":"0cm","Width":"2.667cm","Height":"0.75cm"}},{"Item":{"Type":"textbox","Name":"文本框12","DataElementName":"TextBox1","CanGrow":true,"KeepTogether":true,"Value":"占位4","Style":{"PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt"},"Left":"0cm","Top":"0cm","Width":"2.667cm","Height":"0.75cm"}},{"Item":{"Type":"textbox","Name":"文本框8","DataElementName":"TextBox9","CanGrow":true,"KeepTogether":true,"Value":"占位5","Style":{"PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt"},"Width":"2.667cm","Height":"0.75cm"}},{"Item":{"Type":"textbox","Name":"文本框9","DataElementName":"TextBox10","CanGrow":true,"KeepTogether":true,"Value":"占位6","Style":{"PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt"},"Width":"2.665cm","Height":"0.75cm"}}]}]},"Left":"0cm","Top":"0cm","Width":"16cm","Height":"2.25cm"},{"Type":"table","Name":"表格2","ZIndex":1,"DataSetName":"DataSet1","TableColumns":[{"Width":"2.666cm"},{"Width":"2.666cm"},{"Width":"2.666cm"},{"Width":"2.666cm"},{"Width":"2.666cm"},{"Width":"2.665cm"}],"Header":{"TableRows":[{"Height":"0.75cm","TableCells":[{"Item":{"Type":"textbox","Name":"文本框19","DataElementName":"TextBox2","CanGrow":true,"KeepTogether":true,"Value":"编号","Style":{"Border":{"Style":"Solid"},"PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center"},"Width":"2.666cm","Height":"0.75cm"}},{"Item":{"Type":"textbox","Name":"文本框28","DataElementName":"TextBox1","CanGrow":true,"KeepTogether":true,"Value":"产品名称","Style":{"Border":{"Style":"Solid"},"PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center"},"Left":"0cm","Top":"0cm","Width":"2.666cm","Height":"0.75cm"}},{"Item":{"Type":"textbox","Name":"文本框29","DataElementName":"TextBox1","CanGrow":true,"KeepTogether":true,"Value":"数量","Style":{"Border":{"Style":"Solid"},"PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center"},"Left":"0cm","Top":"0cm","Width":"2.666cm","Height":"0.75cm"}},{"Item":{"Type":"textbox","Name":"文本框30","DataElementName":"TextBox1","CanGrow":true,"KeepTogether":true,"Value":"单价","Style":{"Border":{"Style":"Solid"},"PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Right"},"Left":"0cm","Top":"0cm","Width":"2.666cm","Height":"0.75cm"}},{"Item":{"Type":"textbox","Name":"文本框20","DataElementName":"TextBox3","CanGrow":true,"KeepTogether":true,"Value":"折扣","Style":{"Border":{"Style":"Solid"},"PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Right"},"Width":"2.666cm","Height":"0.75cm"}},{"Item":{"Type":"textbox","Name":"文本框21","DataElementName":"TextBox4","CanGrow":true,"KeepTogether":true,"Value":"总价","Style":{"Border":{"Style":"Solid"},"PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Right"},"Width":"2.665cm","Height":"0.75cm"}}]}],"RepeatOnNewPage":true},"Details":{"TableRows":[{"Height":"0.75cm","TableCells":[{"Item":{"Type":"textbox","Name":"文本框22","DataElementName":"TextBox1","CanGrow":true,"KeepTogether":true,"Style":{"PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt"},"Left":"0cm","Top":"0cm","Width":"2.666cm","Height":"0.75cm"}},{"Item":{"Type":"textbox","Name":"文本框31","DataElementName":"产品名称","CanGrow":true,"KeepTogether":true,"Value":"=Fields!产品名称.Value","Style":{"Border":{"Style":"Solid"},"PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt"},"Left":"0cm","Top":"0cm","Width":"2.666cm","Height":"0.75cm"}},{"Item":{"Type":"textbox","Name":"文本框32","DataElementName":"数量","CanGrow":true,"KeepTogether":true,"Value":"=Fields!数量.Value","Style":{"Border":{"Style":"Solid"},"PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt"},"Left":"0cm","Top":"0cm","Width":"2.666cm","Height":"0.75cm"}},{"Item":{"Type":"textbox","Name":"文本框33","DataElementName":"单价","CanGrow":true,"KeepTogether":true,"Value":"=Fields!单价.Value","Style":{"Border":{"Style":"Solid"},"PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt"},"Left":"0cm","Top":"0cm","Width":"2.666cm","Height":"0.75cm"}},{"Item":{"Type":"textbox","Name":"文本框23","DataElementName":"折扣","CanGrow":true,"KeepTogether":true,"Value":"=Fields!折扣.Value","Style":{"Border":{"Style":"Solid"},"PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt"},"Width":"2.666cm","Height":"0.75cm"}},{"Item":{"Type":"textbox","Name":"文本框24","DataElementName":"TextBox7","CanGrow":true,"KeepTogether":true,"Style":{"Border":{"Style":"Solid"},"PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt"},"Width":"2.665cm","Height":"0.75cm"}}]}],"Group":{"PageBreakDisabled":"false"}},"Left":"0.005cm","Top":"2.25cm","Width":"15.995cm","Height":"1.5cm"}]},"DataSets":[{"Name":"DataSet","Fields":[{"Name":"标题","DataField":"标题"},{"Name":"副标题","DataField":"副标题"},{"Name":"日期","DataField":"日期"},{"Name":"签名人","DataField":"签名人"},{"Name":"图片","DataField":"图片"}],"Query":{"DataSourceName":"DataSource","CommandText":"jpath=$.[*]"},"CaseSensitivity":"Auto","KanatypeSensitivity":"Auto","AccentSensitivity":"Auto","WidthSensitivity":"Auto"},{"Name":"DataSet1","Fields":[{"Name":"订单ID","DataField":"订单ID"},{"Name":"客户ID","DataField":"客户ID"},{"Name":"订购日期","DataField":"订购日期"},{"Name":"产品名称","DataField":"产品名称"},{"Name":"数量","DataField":"数量"},{"Name":"单价","DataField":"单价"},{"Name":"折扣","DataField":"折扣"},{"Name":"货主城市","DataField":"货主城市"},{"Name":"货主地址","DataField":"货主地址"},{"Name":"货主名称","DataField":"货主名称"},{"Name":"货主邮政编码","DataField":"货主邮政编码"},{"Name":"图片","DataField":"图片"},{"Name":"电话","DataField":"电话"}],"Query":{"DataSourceName":"DataSource1","CommandText":"jpath=$.[*]"},"CaseSensitivity":"Auto","KanatypeSensitivity":"Auto","AccentSensitivity":"Auto","WidthSensitivity":"Auto"}]}

复制代码

Bella.Yuan · Bella.Yuan

加油加油发表于 2022-11-2 08:48
比如编号列，我想用行号，能根据展示数据自动从1开始递增。总价列，我想根据数量、单据、折扣运算出来一 ...

您好，表格的行号是RowNumber函数，矩表的是RunningValue函数，您根据您的组件选择对应的函数就可以，总价列，您可以使用表达式去进行计算，表达式中也有对应的运算符合，将您的公式写到"{}"里面就可以了，如下图示：

表格行号：https://help.grapecity.com.cn/pages/viewpage.action?pageId=50727386
矩表行号：https://help.grapecity.com.cn/pages/viewpage.action?pageId=50727633