361 Star 3.4K Fork 1.5K

JEECG / JimuReport

 / 详情

图形报表新建的SQL数据源,无法在报表中展现

已完成
创建于  
2021-10-27 22:08
版本号:

1.4.0beta,1.4.0

问题描述:

SQL多表联合查询时,数据预览不为空,报表打开是空数据

错误日志&截图:

输入图片说明
输入图片说明
输入图片说明

重现步骤:

增加SQL数据源,出现问题
不能上传附件:代码发下:

SELECT   c.OrderDate, CASE WHEN c.OrderType = '0' THEN '订单' WHEN c.OrderType = '1' THEN '补单' 
WHEN c.OrderType = '2' THEN'退货' WHEN c.OrderType = '3' THEN '索赔' ELSE '其他' END AS OrderType, b.custbm, a.Price,a.Money,  
a.MF, a.cpoutqty, ISNULL(a.cpoutqty, 0) * a.Price AS cpoutmoney, a.XMH,
 b.zyjb, (CASE a.hasTaxRate WHEN 0 THEN a.Money ELSE round((a.Money / (1 + a.sl / 100)), 2) END)
                   AS bwbmoney
FROM      dbo.xs_OrderDetail AS a LEFT OUTER JOIN
                   dbo.xs_OrderMaster AS c ON a.BillID = c.BillID LEFT OUTER JOIN
                   dbo.da_customer AS b ON b.ID = c.CustID

友情提示(为了提高issue处理效率):

  • 未按格式要求发帖,会被直接删掉;
  • 请针对问题提供报表设计SQL脚本或在官网制作报表示例并提供ID;
  • 针对不好重现的问题,请录制操作视频或详细的重现步骤;

评论 (17)

li 创建了任务
li 修改了描述
展开全部操作日志

导出报表配置和数据sql 直接贴就可以

insert into jimu_report(api_code,create_time,name,template,del_flag,id,view_count,note,status,thumb,update_time,create_by,api_url,type,css_str,update_by,js_str,code,json_str,api_method) values (null,'2021-10-26 15:19:19','企业实时报表副本1966',0,0,'612876517707534336','6',null,null,'https://static.jeecg.com/designreport/images/QQ截图20201218200943_1608293404719.png','2021-10-27 18:20:38','admin',null,'chartinfo',null,'admin',null,'202012171553131966','{"loopBlockList":[],"chartList":[{"row":4,"col":1,"colspan":3,"rowspan":14,"width":"288","height":"337","config":"{"yAxis":{"axisLabel":{"rotate":0,"interval":0,"textStyle":{"color":"#FFFFFF","fontSize":"10"}},"data":["C级客户","B级客户","A级客户"],"axisLine":{"lineStyle":{"color":"#FFFFFF"}},"show":true,"splitLine":{"lineStyle":{"color":"red","width":1,"type":"solid"},"show":false},"type":"category"},"xAxis":{"splitLine":{"lineStyle":{"color":"red","width":1,"type":"solid"},"show":false},"axisLabel":{"textStyle":{"color":"#333:折柱图,折线可以设置不显示数值,柱形图就不可以控制数值的显示","fontSize":12}},"axisLine":{"lineStyle":{"color":"#333:折柱图,折线可以设置不显示数值,柱形图就不可以控制数值的显示"}},"show":true,"type ":"value"},"legend":{"padding":[25,20,25,10],"data":["undefined"],"top":"top","orient":"horizontal","left":"center","show":false,"textStyle":{"color":"#333:折柱图,折线可以设置不显示数值,柱形图就不可以控制数值的显示","fontSize":12}},"grid":{"top":20,"left":45,"bottom":16,"right":46},"series":[{"barWidth":13,"data":[0,0,0],"name":"undefined","itemStyle":{"barBorderRadius":5,"color":""},"label":{"show":true,"position":"right","textStyle":{"color":"#689AFB:Web Project工程如何集成积木表报","fontSize":"10","fontWeight":"normal"}},"type":"bar","barMinHeight":2,"typeData":[],"textStyle":{"color":"black","fontWeight":"bolder"}}],"tooltip":{"show":true,"axisPointer":{"type":"shadow"},"trigger":"axis","textStyle":{"color":"#fff","fontSize":"10"}},"title":{"show":false,"top":5,"text":"销售额省份排名","textStyle":{"color":"#FFFFFF","fontWeight":"normal","fontSize":"14"},"left":"left","padding":[5,20,5,20]}}","url":"","extData":{"dataType":"sql","dataId":"612876517770448896","axisX":"zyjb","axisY":"money","series":"","yText":"money","xText":"zyjb","dbCode":"KD001","dataId1":"","source":"","target":"","isTiming":true,"intervalTime":"30","chartType":"bar.multi.horizontal","chartId":"IFj1lg5S5aNG1wPx","apiStatus":"","apiUrl":""},"layer_id":"IFj1lg5S5aNG1wPx","offsetX":0,"offsetY":0,"backgroud":{"enabled":"","color":"#fff","image":"","repeat":"repeat"},"virtualCellRange":[[4,1],[4,2],[4,3]]},{"row":6,"col":10,"colspan":0,"rowspan":0,"width":"247","height":"124","config":"{"legend":{"padding":[25,20,25,10],"data":["销售额","其他"],"top":"top","orient":"horizontal","left":"center","show":false,"textStyle":{"color":"#333:折柱图,折线可以设置不显示数值,柱形图就不可以控制数值的显示","fontSize":12}},"series":[{"isRose":false,"data":[{"name":"销售额","value":6000000,"itemStyle":{"color":"rgba(43,193,254,1)"}},{"name":"其他","value":3400879,"itemStyle":{"color":"rgba(42,45,76,0.59)"}}],"isRadius":true,"roseType":"","notCount":false,"name":"访问来源","minAngle":0,"label":{"show":false,"position":"outside","textStyle":{"color":"","fontSize":16,"fontWeight":"bolder"}},"type":"pie","radius":["45%","55%"],"autoSort":false}],"tooltip":{"formatter":"{b} : {c}","show":true,"textStyle":{"color":"#fff","fontSize":"10"}},"title":{"show":false,"top":5,"text":"销售进度","textStyle":{"color":"#FFFFFF","fontWeight":"normal","fontSize":"14"},"left":"left","padding":[5,20,5,10]}}","url":"","extData":{"dataType":"api","apiStatus":"1","dataId":"1339498906765000705","axisX":"name","axisY":"value","series":"type","yText":"","xText":"","dbCode":"xsjd","dataId1":"","source":"","target":"","isTiming":true,"intervalTime":"5","chartType":"pie.doughnut","chartId":"pie.doughnut"},"layer_id":"Yb2TIGEAxnvN9ITx","offsetX":0,"offsetY":0,"backgroud":{"enabled":false,"color":"#fff","image":""},"virtualCellRange":[[6,10],[6,11]]},{"row":6,"col":12,"colspan":0,"rowspan":0,"width":"244","height":"128","config":"{"yAxis":{"axisLabel":{"rotate":0,"interval":0,"textStyle":{"color":"#FFFFFF","fontSize":"10"}},"data":["北京","青岛","合肥","深圳","石家庄","重庆","保定","邯郸"],"axisLine":{"lineStyle":{"color":"#FFFFFF"}},"show":true,"splitLine":{"lineStyle":{"color":"red","width":1,"type":"solid"},"show":false},"type":"category"},"xAxis":{"axisLabel":{"textStyle":{"color":"#333:折柱图,折线可以设置不显示数值,柱形图就不可以控制数值的显示","fontSize":12}},"axisLine":{"lineStyle":{"color":"#333:折柱图,折线可以设置不显示数值,柱形图就不可以控制数值的显示"}},"show":false,"splitLine":{"lineStyle":{"color":"red","width":1,"type":"solid"},"show":false},"type ":"value"},"legend":{"padding":[25,20,25,10],"data":["销售额"],"top":"top","orient":"horizontal","left":"center","show":false,"textStyle":{"color":"#333:折柱图,折线可以设置不显示数值,柱形图就不可以控制数值的显示","fontSize":12}},"grid":{"top":10,"left":49,"bottom":16,"right":45},"series":[{"barWidth":9,"data":[80,500,800,1000,1200,1500,1600,2000],"name":"销售额","itemStyle":{"barBorderRadius":0,"color":"rgba(146,119,252,1)"},"label":{"show":true,"position":"right","textStyle":{"color":"#689AFB:Web Project工程如何集成积木表报","fontSize":"10","fontWeight":"normal"}},"type":"bar","barMinHeight":2,"typeData":[],"textStyle":{"color":"black","fontWeight":"bolder"}}],"tooltip":{"show":true,"axisPointer":{"type":"shadow"},"trigger":"axis","textStyle":{"color":"#fff","fontSize":"10"}},"title":{"show":false,"top":5,"text":"销售额城市排名","textStyle":{"color":"#FFFFFF","fontWeight":"normal","fontSize":"14"},"left":"left","padding":[5,20,5,20]}}","url":"","extData":{"dataType":"api","apiStatus":"1","dataId":"1339495346077728770","axisX":"name","axisY":"value","series":"type","yText":"","xText":"","dbCode":"chengshi","dataId1":"","source":"","target":"","isTiming":true,"intervalTime":"5","chartType":"bar.multi.horizontal","chartId":"bar.multi.horizontal"},"layer_id":"qQHpevWlqElpRQUl","offsetX":0,"offsetY":0,"backgroud":{"enabled":false,"color":"#fff","image":""},"virtualCellRange":[[6,12],[6,13],[6,14]]},{"row":6,"col":15,"colspan":0,"rowspan":0,"width":"230","height":"127","config":"{"yAxis":{"axisLabel":{"rotate":0,"interval":0,"textStyle":{"color":"#FFFFFF","fontSize":"10"}},"data":["北京","青岛","合肥","深圳","石家庄","重庆","保定","邯郸"],"axisLine":{"lineStyle":{"color":"#FFFFFF"}},"show":true,"splitLine":{"lineStyle":{"color":"red","width":1,"type":"solid"},"show":false},"type":"category"},"xAxis":{"axisLabel":{"textStyle":{"color":"#333:折柱图,折线可以设置不显示数值,柱形图就不可以控制数值的显示","fontSize":12}},"axisLine":{"lineStyle":{"color":"#333:折柱图,折线可以设置不显示数值,柱形图就不可以控制数值的显示"}},"show":false,"splitLine":{"lineStyle":{"color":"red","width":1,"type":"solid"},"show":false},"type ":"value"},"legend":{"padding":[25,20,25,10],"data":["销售额"],"top":"top","orient":"horizontal","left":"center","show":false,"textStyle":{"color":"#333:折柱图,折线可以设置不显示数值,柱形图就不可以控制数值的显示","fontSize":12}},"grid":{"top":10,"left":49,"bottom":20,"right":48},"series":[{"barWidth":9,"data":[80,500,800,1000,1200,1500,1600,2000],"name":"销售额","itemStyle":{"barBorderRadius":0,"color":"rgba(146,119,252,1)"},"label":{"show":true,"position":"right","textStyle":{"color":"#689AFB:Web Project工程如何集成积木表报","fontSize":"10","fontWeight":"normal"}},"type":"bar","barMinHeight":2,"typeData":[],"textStyle":{"color":"black","fontWeight":"bolder"}}],"tooltip":{"show":true,"axisPointer":{"type":"shadow"},"trigger":"axis","textStyle":{"color":"#fff","fontSize":"10"}},"title":{"show":false,"top":5,"text":"某站点用户访问来源","textStyle":{"color":"#c23531","fontWeight":"bolder","fontSize":18},"left":"left","padding":[5,20,5,20]}}","url":"","extData":{"dataType":"api","apiStatus":"1","dataId":"1339495346077728770","axisX":"name","axisY":"value","series":"type","yText":"","xText":"","dbCode":"chengshi","dataId1":"","source":"","target":"","isTiming":true,"intervalTime":"5","chartType":"bar.multi.horizontal","chartId":"bar.multi.horizontal"},"layer_id":"phTmhkjHLebYlOEQ","offsetX":0,"offsetY":0,"backgroud":{"enabled":false,"color":"#fff","image":""},"virtualCellRange":[[6,15],[6,16],[6,17],[6,18]]},{"row":7,"col":5,"colspan":0,"rowspan":0,"width":"430","height":"293","config":"{"geo":{"map":"china","zoom":0.5,"label":{"color":"#FFFFFF","fontSize":"8","show":true},"itemStyle":{"borderWidth":0.5,"areaColor":"#8284FB","borderColor":"#000"},"emphasis":{"label":{"color":"#fff"},"itemStyle":{"areaColor":"#4195EF"}},"regions":[],"layoutSize":600,"roam":true,"layoutCenter":["50%","50%"]},"series":[{"encode":{"value":[2]},"data":[{"name":"河北","value":[114.502461,38.045474,279]},{"name":"海南","value":[110.33119,20.031971,273]},{"name":"山东","value":[117.000923,36.675807,229]},{"name":"甘肃","value":[103.823557,36.058039,194]},{"name":"宁夏","value":[106.278179,38.46637,193]},{"name":"浙江","value":[120.153576,30.287459,177]},{"name":"湖南","value":[112.982279,28.19409,119]},{"name":"湖北","value":[114.298572,30.584355,79]},{"name":"河南","value":[113.665412,34.757975,67]},{"name":"北京","value":[116.405285,39.904989,58]},{"name":"天津","value":[117.190182,39.125596,59]},{"name":"上海","value":[121.472644,31.231706,63]}],"name":"","emphasis":{"label":{"show":true}},"itemStyle":{"color":"#FF1205"},"coordinateSystem":"geo","label":{"formatter":"{b}","show":false,"position":"right"},"type":"scatter","symbolSize":5}],"chartType":"map","tooltip":{"show":true,"textStyle":{"color":"#fff","fontSize":"10"}},"title":{"show":false,"top":5,"text":"主要城市空气质量","textStyle":{"color":"#c23531","fontWeight":"normal","fontSize":"14"},"left":"left","padding":[5,20,5,10]}}","url":"","extData":{"chartType":"map.scatter"},"layer_id":"YTri6J59av4gj1CY","offsetX":0,"offsetY":0,"backgroud":{"enabled":false,"color":"#fff","image":""},"virtualCellRange":[[7,5],[7,6],[7,7],[7,8]]},{"row":14,"col":12,"colspan":0,"rowspan":0,"width":"244","height":"138","config":"{"legend":{"padding":[25,20,25,10],"data":["销售额","其他"],"top":"top","orient":"horizontal","left":"center","show":false,"textStyle":{"color":"#333:折柱图,折线可以设置不显示数值,柱形图就不可以控制数值的显示","fontSize":12}},"series":[{"isRose":false,"data":[{"name":"销售额","value":6000000,"itemStyle":{"color":"rgba(43,193,254,1)"}},{"name":"其他","value":3400879,"itemStyle":{"color":"rgba(42,45,76,0.59)"}}],"isRadius":true,"roseType":"","notCount":false,"name":"访问来源","minAngle":0,"label":{"show":false,"position":"outside","textStyle":{"color":"","fontSize":16,"fontWeight":"bolder"}},"type":"pie","radius":["50%","60%"],"autoSort":false}],"tooltip":{"formatter":"{b} : {c}","show":true,"textStyle":{"color":"#fff","fontSize":"10"}},"title":{"show":false,"top":5,"text":"","textStyle":{"color":"#c23531","fontWeight":"bolder","fontSize":18},"left":"left","padding":[5,20,5,10]}}","url":"","extData":{"dataType":"api","apiStatus":"1","dataId":"1339498906765000705","axisX":"name","axisY":"value","series":"type","yText":"","xText":"","dbCode":"xsjd","dataId1":"","source":"","target":"","isTiming":true,"intervalTime":"5","chartType":"pie.doughnut","chartId":"pie.doughnut"},"layer_id":"ARuuHLfjqV9l1tQD","offsetX":0,"offsetY":0,"backgroud":{"enabled":false,"color":"#fff","image":""},"virtualCellRange":[[14,12],[14,13],[14,14]]},{"row":14,"col":15,"colspan":0,"rowspan":0,"width":"230","height":"139","config":"{"legend":{"padding":[25,20,25,10],"data":["销售额","其他"],"top":"top","orient":"horizontal","left":"center","show":false,"textStyle":{"color":"#333:折柱图,折线可以设置不显示数值,柱形图就不可以控制数值的显示","fontSize":12}},"series":[{"isRose":false,"data":[{"name":"销售额","value":6000000,"itemStyle":{"color":"rgba(43,193,254,1)"}},{"name":"其他","value":3400879,"itemStyle":{"color":"rgba(42,45,76,0.59)"}}],"isRadius":true,"roseType":"","notCount":false,"name":"访问来源","minAngle":0,"label":{"show":false,"position":"outside","textStyle":{"color":"","fontSize":16,"fontWeight":"bolder"}},"type":"pie","radius":["45%","55%"],"autoSort":false}],"tooltip":{"formatter":"{b} : {c}","show":true,"textStyle":{"color":"#fff","fontSize":"10"}},"title":{"show":false,"top":5,"text":"某站点用户访问来源","textStyle":{"color":"#c23531","fontWeight":"bolder","fontSize":18},"left":"left","padding":[5,20,5,10]}}","url":"","extData":{"dataType":"api","apiStatus":"1","dataId":"1339498906765000705","axisX":"name","axisY":"value","series":"type","yText":"","xText":"","dbCode":"xsjd","dataId1":"","source":"","target":"","isTiming":true,"intervalTime":"5","chartType":"pie.doughnut","chartId":""},"layer_id":"bcrMtWqTd2AJIjLd","offsetX":0,"offsetY":0,"backgroud":{"enabled":false,"color":"#fff","image":""},"virtualCellRange":[[14,15],[14,16],[14,17],[14,18]]},{"row":14,"col":10,"colspan":0,"rowspan":0,"width":"244","height":"138","config":"{"yAxis":{"axisLabel":{"rotate":0,"interval":0,"textStyle":{"color":"#FFFFFF","fontSize":"10"}},"data":["北京","青岛","合肥","深圳","石家庄","重庆","保定","邯郸"],"axisLine":{"lineStyle":{"color":"#FFFFFF"}},"show":true,"splitLine":{"lineStyle":{"color":"red","width":1,"type":"solid"},"show":false},"type":"category"},"xAxis":{"axisLabel":{"textStyle":{"color":"#333:折柱图,折线可以设置不显示数值,柱形图就不可以控制数值的显示","fontSize":12}},"axisLine":{"lineStyle":{"color":"#333:折柱图,折线可以设置不显示数值,柱形图就不可以控制数值的显示"}},"show":false,"splitLine":{"lineStyle":{"color":"red","width":1,"type":"solid"},"show":false},"type ":"value"},"legend":{"padding":[25,20,25,10],"data":["销售额"],"top":"top","orient":"horizontal","left":"center","show":false,"textStyle":{"color":"#333:折柱图,折线可以设置不显示数值,柱形图就不可以控制数值的显示","fontSize":12}},"grid":{"top":10,"left":49,"bottom":15,"right":45},"series":[{"barWidth":9,"data":[80,500,800,1000,1200,1500,1600,2000],"name":"销售额","itemStyle":{"barBorderRadius":0,"color":"rgba(146,119,252,1)"},"label":{"show":true,"position":"right","textStyle":{"color":"#698AFB:动态sql的if判断没有生效","fontSize":"10","fontWeight":"normal"}},"type":"bar","barMinHeight":2,"typeData":[],"textStyle":{"color":"black","fontWeight":"bolder"}}],"tooltip":{"show":true,"axisPointer":{"type":"shadow"},"trigger":"axis","textStyle":{"color":"#fff","fontSize":"10"}},"title":{"show":false,"top":5,"text":"某站点用户访问来源","textStyle":{"color":"#c23531","fontWeight":"bolder","fontSize":18},"left":"left","padding":[5,20,5,20]}}","url":"","extData":{"dataType":"api","apiStatus":"1","dataId":"1339495346077728770","axisX":"name","axisY":"value","series":"type","yText":"","xText":"","dbCode":"chengshi","dataId1":"","source":"","target":"","isTiming":true,"intervalTime":"5","chartType":"bar.multi.horizontal","chartId":"bar.multi.horizontal"},"layer_id":"Y1kgYOWBHIVQdSN5","offsetX":0,"offsetY":0,"backgroud":{"enabled":false,"color":"#fff","image":""},"virtualCellRange":[[14,10],[14,11]]},{"row":20,"col":1,"colspan":0,"rowspan":0,"width":"743","height":"150","config":"{"yAxis":{"axisLabel":{"textStyle":{"color":"#FFFFFF","fontSize":"10"}},"axisLine":{"lineStyle":{"color":"#FFFFFF"}},"show":true,"name":"","splitLine":{"lineStyle":{"color":"red","width":1,"type":"solid"},"show":false}},"xAxis":{"axisLabel":{"rotate":0,"interval":0,"textStyle":{"color":"#FEFEFE","fontSize":"10"}},"data":["2020-01-09","2020-01-12","2020-01-14","2020-01-16","2020-01-18"],"axisLine":{"lineStyle":{"color":"#FFFFFF"}},"show":true,"name":"","splitLine":{"lineStyle":{"color":"red","width":1,"type":"solid"},"show":false}},"grid":{"top":53,"left":22,"bottom":37,"right":20},"series":[{"areaStyle":{"color":"#43B8FB:自动换行高度无法自适应","opacity":0.7},"data":[2,6,7,5,6],"showSymbol":true,"lineStyle":{"width":2},"symbolSize":5,"isArea":true,"name":"销量","itemStyle":{"color":"#43B8FB:自动换行高度无法自适应"},"step":false,"label":{"show":false,"position":"top","textStyle":{"color":"black","fontSize":16,"fontWeight":"bolder"}},"type":"line","smooth":false}],"tooltip":{"formatter":"{b} : {c}","show":true,"textStyle":{"color":"#fff","fontSize":"10"}},"title":{"show":true,"top":14,"text":"销售额增速","textStyle":{"color":"#FFFFFF","fontWeight":"normal","fontSize":"14"},"left":"left","padding":[5,20,5,10]}}","url":"","extData":{"dataType":"api","apiStatus":"1","dataId":"1339538388453195777","axisX":"name","axisY":"value","series":"type","yText":"","xText":"","dbCode":"zhexian","dataId1":"","source":"","target":"","isTiming":true,"intervalTime":"5","chartType":"line.area","chartId":""},"layer_id":"uChrZaHYoV04MQpT","offsetX":0,"offsetY":0,"backgroud":{"enabled":false,"color":"#fff","image":""},"virtualCellRange":[[20,1],[20,2],[20,3],[20,4],[20,5],[20,6],[20,7],[20,8],[20,9]]}],"area":{"sri":8,"sci":1,"eri":8,"eci":1,"width":100,"height":25},"excel_config_id":"612876517707534336","printConfig":{"paper":"A3","width":297,"height":420,"definition":1,"isBackend":false,"marginX":10,"marginY":10,"layout":"landscape"},"zonedEditionList":[],"rows":{"0":{"cells":{}},"2":{"cells":{"1":{"merge":[0,17],"text":"企业实时销售数据","style":3}}},"3":{"cells":{},"height":35},"4":{"cells":{"1":{"text":" 销售额省份排名","style":32,"merge":[0,1],"virtual":"IFj1lg5S5aNG1wPx"},"2":{"text":" ","virtual":"IFj1lg5S5aNG1wPx"},"3":{"text":" ","virtual":"IFj1lg5S5aNG1wPx"},"5":{"text":" 销售总额","style":69},"10":{"text":" 销售进度","style":43},"11":{"text":" ","style":43},"13":{"text":" 销售额城市排名","style":32,"merge":[0,1]},"15":{"text":" 个人业绩排名","style":32,"merge":[0,1]},"17":{"text":" ","style":32,"merge":[0,1]}},"height":38},"5":{"cells":{"1":{"text":" Sales ranking points","style":62,"merge":[0,1]},"5":{"text":"12436025","style":52,"merge":[1,0]},"6":{"merge":[1,0],"text":"元","style":22},"10":{"text":" Sales progress","style":33},"11":{"text":" ","virtual":"Yb2TIGEAxnvN9ITx","style":33},"13":{"text":" Sales ranking","virtual":"qQHpevWlqElpRQUl","style":31},"15":{"text":" Personal ranking","style":62,"merge":[0,1]},"17":{"text":" ","style":62,"merge":[0,1]}},"height":24},"6":{"cells":{"10":{"text":" ","virtual":"Yb2TIGEAxnvN9ITx"},"11":{"text":" ","style":33,"virtual":"Yb2TIGEAxnvN9ITx"},"12":{"text":" ","virtual":"qQHpevWlqElpRQUl"},"13":{"text":" ","virtual":"qQHpevWlqElpRQUl","style":31},"14":{"text":" ","virtual":"qQHpevWlqElpRQUl"},"15":{"text":" ","virtual":"phTmhkjHLebYlOEQ"},"16":{"text":" ","virtual":"phTmhkjHLebYlOEQ"},"17":{"text":" ","style":31,"virtual":"phTmhkjHLebYlOEQ"},"18":{"text":" ","virtual":"phTmhkjHLebYlOEQ"}}},"7":{"cells":{"5":{"style":53,"virtual":"YTri6J59av4gj1CY","text":" "},"6":{"style":22,"virtual":"YTri6J59av4gj1CY","text":" "},"7":{"text":" ","virtual":"YTri6J59av4gj1CY"},"8":{"text":" ","virtual":"YTri6J59av4gj1CY"}}},"8":{"cells":{"5":{"style":18,"text":" ","virtual":"YTri6J59av4gj1CY"}}},"9":{"cells":{"5":{"style":21,"text":" "}}},"10":{"cells":{"5":{"text":" ","style":17}}},"12":{"cells":{"10":{"text":" 品类销售排名","style":43},"11":{"text":" ","style":43},"13":{"text":" 品类销售额占比","style":43,"merge":[0,1]},"15":{"text":" 一季度销售季度","style":43,"merge":[0,1]},"17":{"text":" ","style":43,"merge":[0,1]}}},"13":{"cells":{"10":{"text":" Category Sales ranking","style":31},"11":{"text":" ","style":31},"13":{"text":" Type of Sales ","style":31},"15":{"text":" Quarterly sales progree","style":58,"merge":[0,1]},"17":{"text":" ","style":58,"merge":[0,1]}}},"14":{"cells":{"10":{"text":" ","virtual":"Y1kgYOWBHIVQdSN5"},"11":{"text":" ","virtual":"Y1kgYOWBHIVQdSN5"},"12":{"text":" ","virtual":"ARuuHLfjqV9l1tQD"},"13":{"text":" ","virtual":"ARuuHLfjqV9l1tQD"},"14":{"text":" ","virtual":"ARuuHLfjqV9l1tQD"},"15":{"text":" ","virtual":"bcrMtWqTd2AJIjLd"},"16":{"text":" ","virtual":"bcrMtWqTd2AJIjLd"},"17":{"text":" ","virtual":"bcrMtWqTd2AJIjLd"},"18":{"text":" ","virtual":"bcrMtWqTd2AJIjLd"}}},"15":{"cells":{},"height":15},"16":{"cells":{"11":{"text":" ","style":43},"13":{"text":" ","style":43,"merge":[0,1]},"17":{"text":" ","style":43,"merge":[0,1]}}},"17":{"cells":{"11":{"text":" ","style":31},"13":{"text":" ","style":31},"17":{"text":" ","merge":[0,1],"style":58}}},"18":{"cells":{}},"20":{"cells":{"1":{"text":" ","virtual":"uChrZaHYoV04MQpT"},"2":{"text":" ","virtual":"uChrZaHYoV04MQpT"},"3":{"text":" ","virtual":"uChrZaHYoV04MQpT"},"4":{"text":" ","virtual":"uChrZaHYoV04MQpT"},"5":{"text":" ","virtual":"uChrZaHYoV04MQpT"},"6":{"text":" ","virtual":"uChrZaHYoV04MQpT"},"7":{"text":" ","virtual":"uChrZaHYoV04MQpT"},"8":{"text":" ","virtual":"uChrZaHYoV04MQpT"},"9":{"text":" ","virtual":"uChrZaHYoV04MQpT"}},"height":39},"22":{"cells":{"10":{"text":"企业经营指标","style":74},"11":{"text":"1201043元","style":73},"13":{"text":"企业经营指标","style":74},"14":{"text":"1201043元","style":73},"16":{"text":"企业经营指标","style":74},"17":{"text":"1201043元","style":73}}},"23":{"cells":{"10":{"text":"企业经营指标1","style":74},"11":{"text":"1201043元","style":73},"13":{"text":"企业经营指标1","style":74},"14":{"text":"1201043元","style":73},"16":{"text":"企业经营指标1","style":74},"17":{"text":"1201043元","style":73}}},"26":{"cells":{},"height":33},"len":100},"dbexps":[],"toolPrintSizeObj":{"printType":"A4","widthPx":794,"heightPx":1047},"dicts":[],"rpbar":{"show":true,"pageSize":"","btnList":[]},"freeze":"A1","dataRectWidth":1584,"displayConfig":{},"background":{"path":"https://static.jeecg.com/designreport/images/bg55_1608205385382.png","repeat":"no-repeat","width":"1525","height":"700"},"name":"sheet1","autofilter":{},"styles":[{"color":"#ffffff"},{"color":"#ffffff","font":{"size":16}},{"color":"#ffffff","font":{"size":16},"align":"center"},{"color":"#ffffff","font":{"size":18},"align":"center"},{"font":{"size":18}},{"color":"#67b1ee"},{"color":"#67b1ee","font":{"size":14}},{"color":"#67b1ee","font":{"size":12}},{"font":{"size":14}},{"font":{"size":18},"bgcolor":"#ffffff"},{"font":{"size":18},"bgcolor":"#ffffff","color":"#ffffff"},{"font":{"size":16},"bgcolor":"#ffffff","color":"#ffffff"},{"color":"#67b1ee","font":{"size":12},"align":"right"},{"font":{"size":16},"bgcolor":"#ffffff","color":"#ffffff","align":"right"},{"color":"#67b1ee","font":{"size":12},"align":"center"},{"font":{"size":16}},{"font":{"size":16},"color":"#fe0000"},{"font":{"size":16},"color":"#fe0000","align":"center"},{"color":"#67b1ee","font":{"size":12},"align":"left"},{"align":"left"},{"align":"left","font":{"size":14}},{"align":"left","font":{"size":14},"color":"#ffffff"},{"font":{"size":14},"color":"#ffffff"},{"font":{"size":12},"color":"#ffffff"},{"font":{"size":12,"bold":true},"color":"#ffffff"},{"font":{"size":12,"bold":false},"color":"#ffffff"},{"font":{"size":11,"bold":false},"color":"#ffffff"},{"font":{"size":8}},{"font":{"size":9}},{"font":{"size":9},"color":"#67b1ee"},{"font":{"size":9},"color":"#67b1ee","valign":"top"},{"font":{"size":8},"color":"#67b1ee","valign":"top"},{"font":{"size":11,"bold":false},"color":"#ffffff","valign":"bottom"},{"font":{"size":8},"color":"#67b1ee"},{"color":"#67b1ee","font":{"size":12},"align":"left","valign":"bottom"},{"align":"left","valign":"bottom"},{"color":"#67b1ee","font":{"size":12},"align":"center","valign":"bottom"},{"align":"center","valign":"bottom"},{"color":"#67b1ee","font":{"size":12},"align":"left","valign":"middle"},{"align":"left","valign":"middle"},{"font":{"size":11}},{"font":{"size":11},"color":"#ffffff"},{"font":{"size":11},"color":"#ffffff","valign":"middle"},{"font":{"size":11},"color":"#ffffff","valign":"bottom"},{"color":"#ffffff","font":{"size":12},"align":"left","valign":"middle"},{"align":"left","valign":"middle","color":"#ffffff"},{"color":"#67b1ee","font":{"size":16}},{"color":"#ffff01","font":{"size":16}},{"color":"#ffffff","font":{"size":11},"align":"left","valign":"middle"},{"color":"#ffffff","font":{"size":14},"align":"left","valign":"middle"},{"color":"#ffff01","font":{"size":14},"align":"left","valign":"middle"},{"font":{"size":14},"color":"#ffff01"},{"color":"#ffff01","font":{"size":14},"align":"right","valign":"middle"},{"font":{"size":14},"color":"#ffff01","align":"right"},{"color":"#ffffff","valign":"bottom"},{"font":{"size":8},"bgcolor":"#67b1ee"},{"font":{"size":8},"bgcolor":"#ffffff"},{"font":{"size":8},"bgcolor":"#ffffff","color":"#67b1ee"},{"font":{"size":8},"bgcolor":"#ffffff","color":"#67b1ee","valign":"top"},{"font":{"size":8,"bold":false},"color":"#ffffff","valign":"bottom"},{"font":{"size":8,"bold":false},"color":"#ffffff","valign":"top"},{"font":{"size":8},"valign":"top"},{"font":{"size":8,"bold":false},"color":"#67b1ee","valign":"top"},{"color":"#ffffff","font":{"size":11},"align":"center","valign":"middle"},{"align":"center"},{"color":"#ffffff","font":{"size":11},"align":"right","valign":"middle"},{"align":"right"},{"color":"#ffffff","font":{"size":14},"align":"right","valign":"middle"},{"align":"right","font":{"size":14}},{"color":"#ffffff","font":{"size":11},"align":"left","valign":"bottom"},{"color":"#67b1ee","font":{"size":11}},{"color":"#67b1ee","font":{"size":11},"align":"center"},{"font":{"size":12}},{"font":{"size":12},"color":"#ffff01"},{"color":"#67b1ee","font":{"size":11},"align":"right"}],"validations":[],"cols":{"0":{"width":10},"3":{"width":102},"4":{"width":9},"5":{"width":105},"6":{"width":102},"8":{"width":124},"9":{"width":14},"10":{"width":136},"11":{"width":114},"12":{"width":15},"13":{"width":113},"14":{"width":129},"15":{"width":11},"len":50},"merges":["B3:S3","B5:C5","N5:O5","P5:Q5","R5:S5","B6:C6","F6:F7","G6:G7","P6:Q6","R6:S6","N13:O13","P13:Q13","R13:S13","P14:Q14","R14:S14","N17:O17","R17:S17","R18:S18"]}',null);
insert into jimu_report_db(db_code,db_ch_name,is_list,create_time,db_type,db_key,db_source,id,jimu_report_id,db_dyn_sql,is_page,update_time,tb_db_table_name,create_by,api_url,json_data,db_table_name,update_by,tb_db_key,java_type,java_value,api_method,api_convert,db_source_type) values ('KD001','销售额1','0','2021-10-27 21:09:09','0',null,'612852902949736448','612876517770448896','612876517707534336','SELECT c.OrderDate, CASE WHEN c.OrderType = '0' THEN 'HS客户订单' WHEN c.OrderType = '1' THEN 'SC客户补单'
WHEN c.OrderType = '2' THEN'PS退货补数' WHEN c.OrderType = '3' THEN 'SP客户索赔' WHEN c.OrderType = '4' THEN 'BL公司备单'
WHEN c.OrderType = '5' THEN 'KC库存订单' WHEN c.OrderType = '6' THEN 'YP样品订单' WHEN c.OrderType = '8' THEN 'MF客户索取'
ELSE '其他' END AS OrderType, b.custbm, a.Price,a.Money,
a.MF, a.cpoutqty, ISNULL(a.cpoutqty, 0) * a.Price AS cpoutmoney, a.XMH,
b.zyjb, (CASE a.hasTaxRate WHEN 0 THEN a.Money ELSE round((a.Money / (1 + a.sl / 100)), 2) END)
AS bwbmoney
FROM dbo.xs_OrderDetail AS a LEFT OUTER JOIN
dbo.xs_OrderMaster AS c ON a.BillID = c.BillID LEFT OUTER JOIN
dbo.da_customer AS b ON b.ID = c.CustID','0','2021-10-27 21:09:09',null,'admin',null,'',null,'admin',null,null,null,null,null,'sqlserver');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2021-10-27 21:09:09','date',0,2,'orderdate','订单日期','612876517795614720',1,null,'admin','612876517770448896',null,'=concat(string.substring(dateStr('yyyy-MM-dd'),0, 8), '01')|=dateStr('yyyy-MM-dd')',null,'orderdate','yyyy-MM-dd','');

insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2021-10-27 21:09:09','number',1,null,'money',null,'612876517816586240',null,null,'admin','612876517770448896',null,null,null,'money',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2021-10-27 21:09:09','string',2,null,'zyjb',null,'612876517820780544',null,null,'admin','612876517770448896',null,null,null,'zyjb',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2021-10-27 21:09:09','String',3,null,'ordertype',null,'612876517824974848',null,null,'admin','612876517770448896',null,null,null,'ordertype',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2021-10-27 21:09:09','String',6,null,'custbm',null,'612876517841752064',null,null,'admin','612876517770448896',null,null,null,'custbm',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2021-10-27 21:09:09','String',7,null,'price',null,'612876517850140672',null,null,'admin','612876517770448896',null,null,null,'price',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2021-10-27 21:09:09','String',8,null,'mf',null,'612876517854334976',null,null,'admin','612876517770448896',null,null,null,'mf',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2021-10-27 21:09:09','String',9,null,'cpoutqty',null,'612876517858529280',null,null,'admin','612876517770448896',null,null,null,'cpoutqty',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2021-10-27 21:09:09','String',10,null,'cpoutmoney',null,'612876517866917888',null,null,'admin','612876517770448896',null,null,null,'cpoutmoney',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2021-10-27 21:09:09','String',11,null,'xmh',null,'612876517875306496',null,null,'admin','612876517770448896',null,null,null,'xmh',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2021-10-27 21:09:09','String',12,null,'bwbmoney',null,'612876517883695104',null,null,'admin','612876517770448896',null,null,null,'bwbmoney',null,'');
insert into jimu_report_db(db_code,db_ch_name,is_list,create_time,db_type,db_key,db_source,id,jimu_report_id,db_dyn_sql,is_page,update_time,tb_db_table_name,create_by,api_url,json_data,db_table_name,update_by,tb_db_key,java_type,java_value,api_method,api_convert,db_source_type) values ('xiaoshoue','销售额','0','2021-10-26 15:19:19','1',null,'','612876517896278016','612876517707534336',null,'0','2020-12-18 03:50:14',null,'admin','http://api.jeecg.com/mock/26/xiaoshoue',null,null,null,null,null,null,'0',null,null);
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2021-10-26 15:19:19','String',1,null,'name',null,'612876517904666624',0,null,'admin','612876517896278016',null,null,null,'name',null,null);
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2021-10-26 15:19:19','String',2,null,'value',null,'612876517908860928',0,null,'admin','612876517896278016',null,null,null,'value',null,null);
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2021-10-26 15:19:19','String',3,null,'type',null,'612876517917249536',0,null,'admin','612876517896278016',null,null,null,'type',null,null);
insert into jimu_report_db(db_code,db_ch_name,is_list,create_time,db_type,db_key,db_source,id,jimu_report_id,db_dyn_sql,is_page,update_time,tb_db_table_name,create_by,api_url,json_data,db_table_name,update_by,tb_db_key,java_type,java_value,api_method,api_convert,db_source_type) values ('chengshi','城市','0','2021-10-26 15:19:19','1',null,'','612876517925638144','612876517707534336',null,'0','2020-12-18 03:50:14',null,'admin','http://api.jeecg.com/mock/26/chengshi',null,null,null,null,null,null,'0',null,null);
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2021-10-26 15:19:19','String',1,null,'name',null,'612876517934026752',0,null,'admin','612876517925638144',null,null,null,'name',null,null);
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2021-10-26 15:19:19','String',2,null,'value',null,'612876517942415360',0,null,'admin','612876517925638144',null,null,null,'value',null,null);
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2021-10-26 15:19:19','String',3,null,'type',null,'612876517950803968',0,null,'admin','612876517925638144',null,null,null,'type',null,null);
insert into jimu_report_db(db_code,db_ch_name,is_list,create_time,db_type,db_key,db_source,id,jimu_report_id,db_dyn_sql,is_page,update_time,tb_db_table_name,create_by,api_url,json_data,db_table_name,update_by,tb_db_key,java_type,java_value,api_method,api_convert,db_source_type) values ('xsjd','销售进度','0','2021-10-26 15:19:19','1',null,'','612876517959192576','612876517707534336',null,'0','2020-12-18 03:50:14',null,'admin','http://api.jeecg.com/mock/26/xsjd',null,null,null,null,null,null,'0',null,null);
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2021-10-26 15:19:19','String',1,null,'name',null,'612876517971775488',0,null,'admin','612876517959192576',null,null,null,'name',null,null);
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2021-10-26 15:19:19','String',2,null,'value',null,'612876517975969792',0,null,'admin','612876517959192576',null,null,null,'value',null,null);
insert into jimu_report_db(db_code,db_ch_name,is_list,create_time,db_type,db_key,db_source,id,jimu_report_id,db_dyn_sql,is_page,update_time,tb_db_table_name,create_by,api_url,json_data,db_table_name,update_by,tb_db_key,java_type,java_value,api_method,api_convert,db_source_type) values ('zhexian','zhexian','1','2021-10-26 15:19:19','1',null,'','612876517984358400','612876517707534336',null,'1','2020-12-18 03:50:14',null,'admin','http://api.jeecg.com/mock/26/zhexian',null,null,null,null,null,null,'0',null,null);
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2021-10-26 15:19:19','String',1,null,'name',null,'612876517996941312',0,null,'admin','612876517984358400',null,null,null,'name',null,null);
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2021-10-26 15:19:19','String',2,null,'value',null,'612876518001135616',0,null,'admin','612876517984358400',null,null,null,'value',null,null);

导出的报表数据sql如上
报表配置很简单,复制的是企业实时销售数据,在【销售额省份排名】这儿实现的效果, 修改【销售额省份排名】的数据源为SQL的销售额1,并定义好分类和值

什么时候能更新lssues,谢谢

你是不是没有type属性,文档地址:http://report.jeecg.com/2062201
输入图片说明
多数据源需要type属性的,你可以这样子写:
输入图片说明
需要type属性,有了之后先把静态api数据删掉,再点击运行即可
输入图片说明
设计页面有type之后的效果
输入图片说明

type值是动态的,按上面你的写法不是变成静态的?

那你这里面有type属性吗
输入图片说明

你字段都没有type,没办法解析,得传一个type,我那个只是个参考示例

为什么需要type,数据配置里没有type项(系列)

SELECT    sum(a.Money)money, b.zyjb
FROM      dbo.xs_OrderDetail AS a LEFT OUTER JOIN
                   dbo.xs_OrderMaster AS c ON a.BillID = c.BillID LEFT OUTER JOIN
                   dbo.da_customer AS b ON b.ID = c.CustID
				   GROUP BY b.zyjb

sql整理了一下,这样柱形图有数据了,但是原来的图形还是没有
如图所示输入图片说明

这两个图表数据类型不一样,可以看一下API数据源-静态数据有返回数据类型,和它一致就可以正常显示。

输入图片说明
输入图片说明
我把旧数据源和新数据源贴上来了,数据类型怎么修改才能一致呢?

li 修改了描述

但是你用的柱形图的组件不一样,虽然是用一个数据源,但是传递的参数是不一样的

怎么个不一样?

lvdandan 任务状态待办的 修改为已完成

已经找到问题了,新建图表时,可以选择系列项,保存关闭再打开已经没有系列项,导致不能修改

JEECG 任务状态已完成 修改为待办的

已修复,待新版本发布

lvdandan 任务状态待办的 修改为已完成

登录 后才可以发表评论

状态
负责人
里程碑
Pull Requests
关联的 Pull Requests 被合并后可能会关闭此 issue
分支
开始日期   -   截止日期
-
置顶选项
优先级
参与者(3)
Java
1
https://gitee.com/jeecg/JimuReport.git
git@gitee.com:jeecg/JimuReport.git
jeecg
JimuReport
JimuReport

搜索帮助

14c37bed 8189591 565d56ea 8189591