Skip to Content

Parameters - filter by second column in a combo box

In a crystal report, I have a dynamic parameter that has a value and a description field. How to apply the filter to my report based on the Description for the value selected?

E.G.

value1 Description1

value2 Description1

value3 Description1

value4 Description2

So If I choose value 2 from my combo box, that Description1 is applied to the report filter. Please note, the value fields don't appear in my report at all, they are simply being used as a means of filtering by Description.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Dec 13, 2018 at 03:19 PM

    Change the dynamic parameter to not include the value, just the description.

    -Dell

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 18, 2018 at 12:02 PM

    The user wants to select the value, then use the resulting description as the filter.

    This can be done using dynamic cascading parameters

    Add comment
    10|10000 characters needed characters exceeded