开发报表时需要一个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

posted @ 2014-07-21 15:10  emmaKang  阅读(178)  评论(0编辑  收藏  举报