locked
Geting two value in Formula field RRS feed

  • Question

  • User1867929564 posted

    Hi,

    Suppose,(simple example)
    ID    Name
    1-xyz
    2-abc
    3-pqr

    From query i get three rows but in crystal report i want to print where id=2
    for this i wrote formula

    if({id})=2 then {name}

    I hvn't written else part,i want only and only to get where id=2.
    But i always get value in browse data.
    one is null and anothewr one is abc

    null is first one and abc is second one as a result null get printed.
    I do not want null.

    what is wrong in my formula ?

    Thanks

    Wednesday, May 23, 2012 7:25 AM

All replies

  • User1867929564 posted

    out of three rows that i am getting i want it get print in 3 seperate rows of crystal reports.
    I am not using details section.
    so for first row,i wrote if(id)=1 then name

    or second row,i wrote if(id)=2 then name
    or second row,i wrote if(id)=3 then name

    but for seond row formula field's browse data it shows 2 value one is blank and the other one abc.because of it getting blank because blank is among first.

    whats wrong ?

    Wednesday, May 23, 2012 8:38 AM