March 19, 2015 at 9:41 am
Hi,
I want to print the address information and country info in the text box(not tablix) when IsAccount field from Account dataset = 0
=IIF(Sum(Fields!Isaccount.Value, "Account") = 0,First(Fields!Primary_Address.Value, "Account"), " , " , First(Fields!Country.Value, "Account"))
This expression is only printing the address and not the country . It should display in the following format :
Address,Country
March 19, 2015 at 12:00 pm
I need this urgently . If anyone could help me out that would be great .
Thanks,
PSB
March 20, 2015 at 9:25 am
PSB (3/19/2015)
Hi,I want to print the address information and country info in the text box(not tablix) when IsAccount field from Account dataset = 0
=IIF(Sum(Fields!Isaccount.Value, "Account") = 0,First(Fields!Primary_Address.Value, "Account"), " , " , First(Fields!Country.Value, "Account"))
This expression is only printing the address and not the country . It should display in the following format :
Address,Country
The IIF statement first evaluates a statement and then if true does the action after the first comma but if false does the action after the second comma.
I don't know how the statement above even runs without giving an error that there are too many arguments...
Here is a suggestion:
=IIF(Sum(Fields!Isaccount.Value, "Account") = 0,First(Fields!Primary_Address.Value, "Account") + " , " + First(Fields!Country.Value, "Account"),"")
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply