• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 66
  • Last Modified:

display n/a in column

hi there
i am on crystal reports in vs
if the column is empty i want to set n/a string
i need a formula

i try do this :
if({CocDet.GelemMet}="")
then
"N/A"



how can i set it ?

thanks
0
Tech_Men
Asked:
Tech_Men
1 Solution
 
mlmccCommented:
Try it this way
Create a formula and put it on the report

if({CocDet.GelemMet}="")  then
    "N/A"
Else
    {CocDet.GelemMet}

Open in new window


mlmcc
0
 
Tech_MenAuthor Commented:
A++
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now