SM_SSRS


When I go to Report > Report Parameters... in VS, I create date parameters and specify the type as datetime. I then add the parameters to my SQL statement. I then go back to look at the parameters and they have changed to string. This happens every time I make a modification to the SQL statement. Is this a bug, or am I missing a step I thought someone would have asked this before, but I can't find a post for it in this forum.

Thanks in advance,

Scott




Re: Datetime Parameters reset to String

Lev Semenets - MSFT


Parameter's type can change to string, but it should only happen once. What version are you using







Re: Datetime Parameters reset to String

SM_SSRS

I'm using 2005. I'm not 100% sure but I'm fairly certain that it happens every time I change the SQL statement.




Re: Datetime Parameters reset to String

Roy mm

Its Not a bug, Its a Feature :)))

But yes - I don belive its a bug.
It happened to me a few time that when I played with the dataset its changed my parameter type from dateTime to string.

If this will be your only problem with the dateTime parameter you should be happy.
Its also have some problems with some localization sometimes....