數據源配置 · JimuReport 積木報表

### **折柱圖支持3種數據形式：** ### **1. SQL數據** 使用SQL形式，可直接連接數據庫，將SQl種的數據篩選并顯示在圖表上。點擊報表編輯器右側的操作欄，點擊“數據”，選擇"數據類型"為“SQL數據集”，按步驟操作即可，下邊講解一下各個參數的意思： * 綁定數據集：是左側綁定過的數據集，可選擇任意一個SQL類型的數據集； * 分類屬性：是X軸綁定數據庫的字段； * 值屬性：是Y軸綁定數據庫的字段； * 系列類型：用戶數據跟那個系列綁定，比如下圖中iPhone、huawei、xiaomi、vivo為系列，讓這些系列跟柱子和折線綁定，就知道這些系列對應的是柱子還是折線；如下圖中，讓“小米”跟“折線圖‘綁定，就可知道，折線代表小米，其他的系列表示柱子； #### **數據庫配置字段如下：** ![](https://img.kancloud.cn/58/1e/581e73233847e21988f2ff23391959a2_385x561.png) ![](https://img.kancloud.cn/20/7b/207b4217b7b9345fa49a568d0a654262_1374x718.png) ![](https://img.kancloud.cn/3c/dc/3cdc333649d9d3d0d0c0c068d9ef6fd9_804x24.png) ![](https://img.kancloud.cn/c1/c5/c1c55bf8a2798a1ccd17d58f234c3b03_1354x749.png) ![](https://img.kancloud.cn/3c/dc/3cdc333649d9d3d0d0c0c068d9ef6fd9_804x24.png) ### **2. 靜態API數據** 報表綁定的數據可以是靜態API的形式。點擊報表編輯器右側的操作欄，點擊“數據”，選擇"數據類型"為“Api數據集”，“Api類型”選擇“靜態數據”，點擊“數據值”，輸入靜態類型即可，如： ``` [ {"name":"周一","value":1000,"type":"iphone"}, {"name":"周二","value":1300,"type":"iphone"}, {"name":"周三","value":1400,"type":"iphone"}, {"name":"周四","value":1080,"type":"iphone"}, {"name":"周五","value":2000,"type":"iphone"}, {"name":"周一","value":1300,"type":"huawei"}, {"name":"周二","value":1600,"type":"huawei"}, {"name":"周三","value":1800,"type":"huawei"}, {"name":"周四","value":2000,"type":"huawei"}, {"name":"周五","value":3000,"type":"huawei"}, {"name":"周一","value":1100,"type":"xiaomi"}, {"name":"周二","value":1200,"type":"xiaomi"}, {"name":"周三","value":1300,"type":"xiaomi"}, {"name":"周四","value":1400,"type":"xiaomi"}, {"name":"周五","value":1500,"type":"xiaomi"}, {"name":"周一","value":1000,"type":"vivo"}, {"name":"周二","value":1000,"type":"vivo"}, {"name":"周三","value":1000,"type":"vivo"}, {"name":"周四","value":1000,"type":"vivo"}, {"name":"周五","value":1000,"type":"vivo"} ] ``` 備注：代碼格式按上邊格式寫，才可渲染效果； ![](https://img.kancloud.cn/9c/be/9cbecb75855d9d978a1465040406807f_1371x499.png) ![](https://img.kancloud.cn/3c/dc/3cdc333649d9d3d0d0c0c068d9ef6fd9_804x24.png) ### **3. 動態API數據** 綁定的數據也可以是動態API的形式。點擊報表編輯器右側的操作欄，點擊“數據”，選擇"數據類型"為“Api數據集”，“Api類型”選擇“動態數據”，選擇“綁定數據集”，點擊“運行”，就可以將數據渲染過來。 **名詞解釋：** 系列類型：用戶數據跟那個系列綁定，比如下圖中iPhone、huawei、xiaomi、vivo為系列，讓這些系列跟柱子和折線綁定，就知道這些系列對應的是柱子還是折線；如下圖中，讓“iPhone”跟“折線圖‘綁定，就可知道，折線代表iPhone，其他的系列表示柱子； ![](https://img.kancloud.cn/e8/17/e8179c13f1af07fb147c588159f8bc76_1385x579.png) ![](https://img.kancloud.cn/3c/dc/3cdc333649d9d3d0d0c0c068d9ef6fd9_804x24.png) 代碼如： ``` { "data": [ { "name": "周一", "value": 1000, "type": "iphone" }, { "name": "周二", "value": 1300, "type": "iphone" }, { "name": "周三", "value": 1400, "type": "iphone" }, { "name": "周四", "value": 1080, "type": "iphone" }, { "name": "周五", "value": 2000, "type": "iphone" }, { "name": "周一", "value": 1300, "type": "huawei" }, { "name": "周二", "value": 1600, "type": "huawei" }, { "name": "周三", "value": 1800, "type": "huawei" }, { "name": "周四", "value": 2000, "type": "huawei" }, { "name": "周五", "value": 3000, "type": "huawei" }, { "name": "周一", "value": 1100, "type": "xiaomi" }, { "name": "周二", "value": 1200, "type": "xiaomi" }, { "name": "周三", "value": 1300, "type": "xiaomi" }, { "name": "周四", "value": 1400, "type": "xiaomi" }, { "name": "周五", "value": 1500, "type": "xiaomi" }, { "name": "周一", "value": 1000, "type": "vivo" }, { "name": "周二", "value": 1000, "type": "vivo" }, { "name": "周三", "value": 1000, "type": "vivo" }, { "name": "周四", "value": 1000, "type": "vivo" }, { "name": "周五", "value": 1000, "type": "vivo" } ] } ``` 備注：代碼格式按上邊格式寫，才可渲染效果； ![](https://img.kancloud.cn/00/40/0040d4148e5bd2b57243a2ff288ded25_1351x559.png)