How do I add a select time parameter to reporting services

Question

I need to create a report that allows the user to give date and time range to report. I can set up the startdate and enddate but I can't seem to figure out how to add starttime and endtime. This is a report where they want to view what was processed between a certain date and time.

Answer 1

In SSRS, there is only one Parameter data type that allows you to enter date and time values - DateTime, which is a combined date and time type.

You could set up separate parameters for each of the date and time values of the start and end of your selection range, but I recommend that you use one parameter for start datetime, and one parameter for end datetime. You should specify your record selection criteria so that the dataset date and time value is between the start and end datetime parameter values.

Answer 2

as far as i am aware they shoudl be able to type in a time after the date part in the datetime parameter.

Answer 3

i have the same problem, need to add 4 parameter that two for date and two for time i.e start date and start time, end date and end time i got only two i.e start and end date i could not find out how to add time parameter with date one option is put date and time manually but need the user to add input date and time separate and get result. i sorted out in Asp.net 3.5 in vb & C# language web report but not figure out in VS 2008 sql reporting services if any one has some concept pls write. i have checked a lot of reviews but could not find out any answer for it. thanks in advance. eric <> [email protected]

If you need solution in C# or in Vb web report i have that.......... can post on here if u sorted then its ok but if you got this solution pls update as well.