Home » SQL ServerRSS

Separate Date and Time report parameters in SSRS 2005

Hello,

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.

thanks.

 

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   |   Follow us on Twitter