Skip to Content

How do I use a formula, where I changed the data type of a field, in my filter in version 2016 pk2?

We recently upgraded to Crystal 2016 from 2013 and ran into an issue. When creating a formula to change the data type of a field, for example totext({datefield}) and then try to use that formula in the filter, it returns 0 results even though there should be results and it works in 2013. It does not say there is an error in the formula in the filter or the new formula I created. I tested with different fields and changed to different data types and they all did the same thing.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 15, 2017 at 07:51 AM

    As you are converting to text you need to check format of both your formula and field, they need to be exactly the same.

    Make a simple report without filter and place field and formula alongside. You may need to add a formatting argument in totext()

    See Crystal help for these.

    Ian

    Add comment
    10|10000 characters needed characters exceeded