帆软FineReport实现下拉框控件多级联动查询模板 + SQL脚本

ds1： select * from 订单 where 1=1 ${if(len(地区) == 0,"","and 货主地区 = '" + 地区 + "'")} ${if(len(省份) == 0,"","and 货主省份 = '" + 省份 + "'")} ${if(len(城市) == 0,"","and 货主城市 = '" + 城市 + "'")} 地区： select distinct 货主地区 from 订单 省份： select 货主省份 from 订单 where 1=1 ${if(len(地区) == 0,"","and 货主地区 = '" + 地区 + "'")} 城市： select 货主城市 from 订单 where 1=1 ${if(len(地区) == 0,"","and 货主地区 = '" + 地区 + "'")} ${if(len(省份) == 0,"","and 货主省份 = '" + 省份 + "'")}