问题描述
我有一个包含参数 StartDate 和 EndDate 的报告.当从下拉列表中选择时，我希望 EndDate 参数的时间部分默认为一天结束.
I have a report that has parameters StartDate and EndDate. I would like the EndDate parameter's time part to default to the end of the day when selected from the drop down.
例如，如果用户从下拉列表中选择 5/15/2008，则框中显示的值应为5/15/2008 23:59:59em>' 不是 '5/15/2008 12:00:00'
For instance, if a user selects 5/15/2008 from the dropdown, the value shown in the box should be '5/15/2008 23:59:59' not '5/15/2008 12:00:00'
在 .Net 中使用事件模型和一行代码很容易做到这一点，但在 Report Builder 2.0 中，我需要做什么?
Its pretty easy to do this in .Net using the event model and a line of code but in Report Builder 2.0, what would I need to do?
是否有我需要为此编写的代码，或者我是否错过了一些可以处理此问题的时髦表达式?
谢谢.
关于开发
推荐答案
我已经有一段时间没有使用 SSRS，所以请耐心等待.你需要做一些翻译，但这是我过去所做的.
It's been awhile since I've used SSRS, so bear with me. You'll have to do a little translation, but here's what I've done in the past.
当您定义 EndDate 参数时，请在参数列表中的 EndDate 之后创建一个名为 EndDateEOD 的附加参数.将此参数设为隐藏值，并设置为当天的最后时刻，类似于 Jeremy 的计算方式.
When you define your EndDate parameter, create an additional parameter named EndDateEOD, after EndDate in your list of parameters. Make this parameter a hidden value, and set it to the last moment of the day, similar to the way that Jeremy calculates it.
然后您可以在您现在拥有@EndDate 的报表查询中使用@EndDateEOD.
Then you can use @EndDateEOD in your report query where you have @EndDate now.
选择 StartDate 时，您可以将 EndDate 默认为其值，以便 EndDateEOD 将自动设置为开始日期的结束.
When StartDate is selected, you could have EndDate default to its value, so that EndDateEOD will automatically be set to the end of the start date.
这篇关于报表生成器 - 设置日期时间参数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！