December 7, 2011 at 9:01 am
Could someone tell me what is incorrect with the following
=iif(Fields!isYO.Value=0,'not YO','YO')
thank you
December 7, 2011 at 9:05 am
Looks correct (assuming SSRS).
What's the issue?
December 7, 2011 at 9:07 am
It's underlined with red
December 7, 2011 at 9:12 am
Try changing ' to ".
December 7, 2011 at 9:16 am
hit the nail on the head, I looked at it and thought, that syntax is right, then thought, doh its not T-SQL its SSRS so gotta use " (speach marks) not '
December 7, 2011 at 9:17 am
sorry but change what to 'to'
December 7, 2011 at 9:18 am
tony.aguanno (12/7/2011)
sorry but change what to 'to'
Change single quotes (') to double quotes (")
December 7, 2011 at 9:31 am
thank you problem solved
December 7, 2011 at 9:31 am
=iif(Fields!isYO.Value=0,"not YO","YO")
SSIS/SSRS/SSAS is a cobble together of different development teams using VB.Net and C# (from what I was told in various Microsoft instructor lead courses), so you need to change your mind set a little when doing expressions.
Strings need to be wrapped in speach marks not apostrophe
December 7, 2011 at 10:02 am
thank you I will keep that in mind from now on
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply