How to Deleting the Empty columns in Crystal reports using Formulafield?

Question

Hito all I have written one Formulafield for combination of NameaddressStateDistrict using camas(). Ex:AmitHyderabadApHyderabad my requirement is when i am not enter the name i will get following way HyderabadApHyderabad Help me thanks inadvance

Prabhu Raja · Answer

Use if Control Statement in formula field as if IsNull(your name column) then //Check your name is null or not // If null Do not add your address state etc else // If else Add your concatenation here --------------------------------------------------------------------------------- If this post helps you then mark as Correct Answer Thank You