Time instead of date in Reporting Services

Question

I need to have a parameter for the time, but when I select the date / time in the parameter properties and set the default value for 08:00:00, it gives me 9. November 2011 08:00:00, and I need time for any date.

Any thoughts?

Answer 1

SSRS does not have a good built-in parameter for this.

So the options are:

• create your own shell interface to collect parameters = a lot of work, but a lot of flexibility.
• Create a drop-down list with all the possible options.
• Use a string or int (if you can get by with just a few hours.) And convert this as needed to your report or query. (Be careful: the Time data type was introduced only in SQL 2008, so it may not work in some environments.)