Home » SQL Server

Separate Date and Time report parameters in SSRS 2005


Is it possible to declare separate report parameters in SSRS 2005 as Date and Time?

I want the user to be able to enter a date and a time.

When I declare the parameters in my stored procedure as datetime, in SSRS the parameter just shows as a Date only.



1 Answer Found


Answer 1

There is no option to define a parameter with time  Datatype. Alternatively , you can have one another text parameter and parse it by concatenating with date  selected. To avoid the format issues of time being entered , you can add the all the time from "0" to 24 hours in the available value of the parameter so that user will select rather than enter.


<< Previous      Next >>

Microsoft   |   Windows   |   Visual Studio   |   Sharepoint   |   Azure