软件开发商业智能
FineReport使用SQL数据集参数
在SQL中查询加时间条件查询没有问题，SQL语句如下select convert(decimal(18,2),sum(expense)) as yhje from membersale where dt>='2015-05-09 07:37:00:396' and dt='${starttime}' and dt在SQL中查询加时间条件查询没有问题，SQL语句如下
select convert(decimal(18,2),sum(expense)) as yhje from membersale where dt>='2015-05-09 07:37:00:396' and dt<='2015-05-10 07:37:00:396';
在finereport数据集中增加参数不是查不出数来，参数类型设置为日期型，设置如下图
select convert(decimal(18,2),sum(expense)) as yhje from membersale where dt>='${starttime}' and dt<='${endtime}'
收起
select convert(decimal(18,2),sum(expense)) as yhje from membersale where dt>='2015-05-09 07:37:00:396' and dt<='2015-05-10 07:37:00:396';
在finereport数据集中增加参数不是查不出数来，参数类型设置为日期型，设置如下图
select convert(decimal(18,2),sum(expense)) as yhje from membersale where dt>='${starttime}' and dt<='${endtime}'
收起
