skgudi2009
SSC Eights!
Points: 890
More actions
January 21, 2013 at 2:06 am
#267133
How to add this Function in SSRS 2008 R2
if {Reportname.Fieldname}='yes'
then
{reportname.Amount1}
else
{reportname.amount2}
This is added in Crystal Report but i wan to add this in ssrs 2008r2 please help me
Koen Verbeeck
SSC Guru
Points: 259085
January 21, 2013 at 2:26 am
#1579145
You need to use the IIF function.
Expression Examples (Report Builder and SSRS)
Need an answer? No, you need a questionMy blog at https://sqlkover.com.MCSE Business Intelligence - Microsoft Data Platform MVP
abdulkalam.m
SSC Enthusiast
Points: 168
January 21, 2013 at 4:18 am
#1579178
=IIF(Reportname.Fieldname="yes",reportname.Amount1,reportname.amount2)
January 21, 2013 at 10:17 am
#1579323
Thank You very much it is working fine
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply