Skip to Content
avatar image
Former Member

Crystal reports

Hi All,

Suppose x table

Colorside Color

1 pink

2 orange black

2 green yellow

Here I want to write the condition in crystal reports

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Oct 25, 2017 at 11:48 AM

    Could you post a screenshot of the formula editor with the error message please?

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 25, 2017 at 09:43 AM

    Hi Ram,

    Could you please elaborate?

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 25, 2017 at 11:40 AM

    Hi Abhilash,

    I want to pic first word if the condition is 1 otherwise it has to be display total field here I have written condition

    if {item_coating.coat-side} = 1

    then split({item_coating.CoatColour}, ",")[1] ---------------- This condition will pick first word in the column

    else

    {item_coating.CoatColour} ------------------ This has to display total field

    But it but is getting error Boolean is required

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 26, 2017 at 11:49 AM

    Hi All,

    For Eg:- Colors! Colors side1! Colors reverse

    2 Black pink

    1 Red

    I want o/p like this But I have only Two fields Colors, Colors side1 or Colors reverse (Both are same fields) Below is the logic I have written

    if {item_coating.coat-side} = 1

    then split({item_coating.CoatColour}, ",")[1] ---------------- This condition will pick first word in the column

    else

    {item_coating.CoatColour} ------------------ This has to display total field

    But it but is getting error Boolean is required

    Could you please resolve the issue.

    Ramesh

    Add comment
    10|10000 characters needed characters exceeded