显示行号序号
陈天禹 于2026/02/26 14:58:40创建
陈天禹 于2026/02/26 14:58:50修改
展开目录
## 概述 显示行号序号：在报表中显示行号。 ### 应用场景 如下图所示，简单演示数据。  ## 示例说明 ### 数据准备 在数据面板中添加数据集，可选择Json数据集和API服务数据集。Json数据集输入如下图所示： ```json [{"CustomerID":"HUNGC","CompanyName":"五金机械","ContactName":"苏先生","ContactTitle":"销售代表","Address":"德昌路甲 29 号","City":"大连","Region":"东北","PostalCode":"564576","Country":"中国","Phone":"(053) 5556874","Fax":"(053) 5552376"}, {"CustomerID":"CENTC","CompanyName":"三捷实业","ContactName":"王先生","ContactTitle":"市场经理","Address":"英雄山路 84 号","City":"大连","Region":"东北","PostalCode":"130083","Country":"中国","Phone":"(061) 15553392","Fax":"(061) 15557293"}, {"CustomerID":"CACTU","CompanyName":"威航货运有限公司","ContactName":"刘先生","ContactTitle":"销售代理","Address":"经七纬二路 13 号","City":"大连","Region":"东北","PostalCode":"120412","Country":"中国","Phone":"(061) 11355555","Fax":"(061) 11354892"}, {"CustomerID":"BLONP","CompanyName":"国皓","ContactName":"黄雅玲","ContactTitle":"市场经理","Address":"广发北路 10 号","City":"大连","Region":"东北","PostalCode":"565479","Country":"中国","Phone":"(0671) 88601531","Fax":"(0671) 88601532"}, {"CustomerID":"MEREP","CompanyName":"华科","ContactName":"吴小姐","ContactTitle":"市场助理","Address":"和光北路 952 号","City":"大连","Region":"东北","PostalCode":"280235","Country":"中国","Phone":"(0514) 5558054","Fax":"(0514) 5558055"}] ``` ### 报表设计 将数据字段拖入相应位置，并设置为分组及向下扩展。 在A2单元格输入公式=ROW()-1，效果为获取当前行号并-1 选中A1-D2单元格，点击上方工具栏-添加分组。 如下图所示  ### 效果预览 [显示行号序号.json](https://www.yuque.com/attachments/yuque/0/2023/json/25420404/1700647239706-828faf55-4ee5-4d5c-bafd-72ff232d6780.json) 