随笔分类 -  报表

解决Sql Server Reporting Service在Chrome下无法显示的问题
摘要： 阅读全文
posted @ 2017-07-01 09:43 emmaKang 阅读(595) 评论(0) 推荐(0)
开发报表时将已有User做成下拉列表，第一项为label为ALL，value为null
摘要：SELECT 'All' AS LABLE_NAME, NULL AS USER_NAMEUNION ALLSELECT USER_NAME AS LABLE_NAME, USER_NAME from dbo.USERS将ALL作为下拉列表的默认值这样判断User的时候可用USERNAME=ISNU... 阅读全文
posted @ 2014-07-21 15:20 emmaKang 阅读(147) 评论(0) 推荐(0)
开发报表是将选择的日期与选择的时间拼成一个表里的时间做比较
摘要：DATE_ENTERED >= dateAdd(hour,CONVERT(INT,@HOUR_FROM),dbo.fnDateOnly(@DATE)) AND DATE_ENTERED <= dateAdd(hour,CONVERT(INT,@HOUR_TO),dbo.fnDateOnly(@DAT... 阅读全文
posted @ 2014-07-21 15:13 emmaKang 阅读(149) 评论(0) 推荐(0)
开发报表时需要一个0到23的下拉列表
摘要：1.New一个dataset名为Hours2.SELECT 0 AS HOUR UNIONSELECT 1 AS HOUR UNIONSELECT 2 AS HOUR UNIONSELECT 3 AS HOUR UNIONSELECT 4 AS HOUR UNIONSELECT 5 AS HOUR ... 阅读全文
posted @ 2014-07-21 15:10 emmaKang 阅读(184) 评论(0) 推荐(0)