Last post Sep 01, 2014 03:12 AM by Michelle Ge - MSFT
Aug 30, 2014 01:59 AM|Furqaan Shaan|LINK
i am using RDLC reports in asp.net c#, i am using expressions like IIF conditions etc, i have used this condition
=iif(Fields!TimeFrame.Value <= 24 AND Fields!TimeFrame.Value >=0 , "Yes", "No")
it works but i just want to handle one another condition what if value returned is =-1 then ?
i want to put condition like if Value= -1 then "Not Yet Received" but it doesn't work like the way i am thinking, help in putting condition,
how to put another if condition or any way ?
Sep 01, 2014 01:07 AM|Ajay230784|LINK
Try Following statement,
=iif(Fields!TimeFrame.Value <= 24, Iif(Fields!TimeFrame.Value >=0 , "Yes", "No"))
For multiple if conditions in RDLC you can refer following link.
Sep 01, 2014 03:12 AM|Michelle Ge - MSFT|LINK
So far as I know, if you want to use if condition in SSRS, you can create a custom function, then call the custom code from the expression using : =Code.ConvertValue(Fields!strPhCell.Value).
For more information, please refer to the link below:
Hope it's useful for you.