首页 > 代码库 > 开发报表时需要一个0到23的下拉列表
开发报表时需要一个0到23的下拉列表
1.New一个dataset名为Hours
2.
SELECT 0 AS HOUR UNION
SELECT 1 AS HOUR UNION
SELECT 2 AS HOUR UNION
SELECT 3 AS HOUR UNION
SELECT 4 AS HOUR UNION
SELECT 5 AS HOUR UNION
SELECT 6 AS HOUR UNION
SELECT 7 AS HOUR UNION
SELECT 8 AS HOUR UNION
SELECT 9 AS HOUR UNION
SELECT 10 AS HOUR UNION
SELECT 11 AS HOUR UNION
SELECT 12 AS HOUR UNION
SELECT 13 AS HOUR UNION
SELECT 14 AS HOUR UNION
SELECT 15 AS HOUR UNION
SELECT 16 AS HOUR UNION
SELECT 17 AS HOUR UNION
SELECT 18 AS HOUR UNION
SELECT 19 AS HOUR UNION
SELECT 20 AS HOUR UNION
SELECT 21 AS HOUR UNION
SELECT 22 AS HOUR UNION
SELECT 23 AS HOUR
3.选Layout->选Report->选Report Paramenters
available values选From Query,Dataset选Hours
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。