Expressions in parameters are not handled correctly
Brought to you by:
bryantlikes
I use =" All Partner" as default parameters value, note
the space before 'All', in order to put this value at the top
of my list which comes from a query. But this
expression is not translated correctly when run through
rswebparts.
Example:
Parameter query:
(select distinct vchcompanyname
from dimpartner d)
union
select ' All Partner'
order by 1
default value is set to =" All Partner"
Runs fine in development environment and reportserver
site but not through rswebparts
Logged In: NO
Datetimes are not handled correctly either.
If it's just a date, it's fine.
If time is included as well, it gets truncated after the hours,
eg "12/12/2003 12:00:00 AM" gets turned into "12/12/2003
12" which is not recognised as a valid date.