Last post Sep 30, 2011 09:43 AM by UstesG
Sep 30, 2011 07:25 AM|upamanyuroy|LINK
I am an ASP.net developer currently workin with a project where I have to use
active reports for reporting.
But the problem is that in a particular case I cannot use active report scripts as well as .net code to format the report output.
Here I have to implement a simple conditional formula using calculated field only.
The formula in Active Report 2.0 ---> =IIf(IsNull([City]),"",[City] & " " & [state] & " " & [Zip])
The case is if city is null then output will be null else it will be city + state + zip
For this I have tried this once in Active Report 3.0 --->
(RecipientCity == "" ? " " : RecipientCity + RecipientState + RecipientZip)
But it is showing the output of RecipientState + RecipientZip even if city is empty.
I have tried to test with the following
(RecipientCity == "" ? " " : RecipientCity)
It is working when there is no city there is no output but when city is there in the database it is showing in the result field.
But the (RecipientCity == "" ? " " : RecipientCity + RecipientState + RecipientZip) is not working.
Do you have any suggestions?
Sep 30, 2011 09:43 AM|UstesG|LINK