数据源及SQL查询语句

连接FlowPortal演示云数据库:配置方法

数据库选择:DemoData

SQL查询语句:select Type as 类别, Northeast 东北,EastChina as 华东,CentralChina as 华中,NorthChina as 华北 ,SouthChina as 华南,NorthWest as 西北,SouthWest as 西南,SubTotal as 总计 from  Form

明细表基本配置:

1、添加数据源

    参考-基本用法

2、拖出明细表,选择数据源

 

3、配置列属性

4、点击报表空白处,配置报表属性

Created with the Personal Edition of HelpNDoc: Free Web Help generator