问题描述
在SSRS中为日期参数设置默认值公式时,例如:
When I set a default value formula for a date parameter in SSRS, such as:
=CDate("01/" & Month(Now) & "/" & Year(Now))
甚至:
=Now
日期参数控制变为禁用,没有任何内容。有谁知道什么简单的事情(我确定)我做错了?
the date parameter control becomes disabled with nothing in it. Does anyone know what simple thing (I am sure) I am doing wrong?
推荐答案
再打一些以后,我意识到当我从上一个没有默认值的下拉列表参数中选取一个值时,日期控件变为启用。显然,在非默认参数之后的控件被禁用,直到你选择某些东西,所以顺序很重要。
After playing some more, I realized that the date controls became enabled when I picked a value from a preceding dropdown parameter that did not have a default. Apparently, controls after non-default parameters are disabled until you pick something, so order matters.
从MDSN文章:
当您要向用户显示默认值时,参数顺序很重要一个参数选择其他参数的值
"parameter order is important when you want to show users the default value for one parameter before they choose values for other parameters"
这篇关于SSRS日期默认值为公式禁用参数的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!