October 31, 2012 at 12:47 am
Hi all,
Is there a way to change an ssrs parameters' data type from the default list that are available in the drop down, which are (text, boolean, date/time, integer, float)?
My problem is that the date/time data type cuts off the time, when we need it to keep the time when it passes the parameter value to the query.
If anyone has come across this problem or knows of a solution any help would be greatly appreciated.
November 2, 2012 at 10:43 am
Hi,
How is the date/time being entered for the parameter & how is the time portion being lost?
You can use text, then convert/cast the parameter within the report code.
You'll have to make sure people know the correct format to enter the date/time in a text field though - just like you would with a date/time parameter.
(Alternatively, do individual parameters for year, month, day, hour, minute, second & build a datetime value from them in the code... :crazy:)
November 4, 2012 at 4:55 pm
Hi Gazareth,
I misunderstood the problem, this is no longer an issue. Thanks for your help though. 🙂
November 5, 2012 at 3:13 am
No worries mate 🙂
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply