Skip to Content

Hide Records Based on Conditions between 2 columns (BEX sourced Crystal Report)

I am creating a Crystal Report off of a BEX Query. The Query has a condition that if the value of A+B is greater than A, then it is displayed and everything else is hidden. How do I go about getting a similar result in Crystal since calculated fields cannot be used as a query filter?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Mar 13, 2017 at 06:23 PM

    I think in Crystal Reports you can add the condition to Records Selection formula and it will filter the records locally.

    Locally means CR will bring all the records and display only those that meet the conditions. Local filtering may affect performance.

    Add comment
    10|10000 characters needed characters exceeded