Skip to Content
avatar image
Former Member

Crystal reports 2011, cascading parameter based on a value

Hi Friends,

So far I have a command object in a main report and based on that a cascading parameter has got the filtered values displayed in it. Now I want to get rid of the command object query and bring the data straight from the table.

Here comes the issue I need to filter the data shown in cascading parameter based on a filter. Please let me know what are all the possibilities.

Also is it possible to pass the value as a default value for a parameter from which the cascading parameter values got filtered and hide it in the parameter window.

So whenever I refresh I am not seeing the default value parameter and the cascading parameter is filtered based on the hidden parameter.

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 17, 2014 at 11:30 AM

    Hi Gokul,

    To filter the LOVs, you would need to build another command object and point the dynamic prompt to the field in this command object.

    Go to the Database Expert > Click Add Command > Type in the SQL Query > Click OK

    DON'T join this command object to the existing table/s. You'll receive a warning when you click OK but that can just be ignored.

    Go to the Field Explorer > Create a new Dynamic Prompt > Choose the field from the command object under the 'Value Fields'.

    The default value cannot be sourced from a field though. It always has to be static and typed in manually.

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Abhilash Kumar

      Yes Got it on How Show on Viewer panel works.

      I will work on other options and let u know my luck on those.

      Thanks

      -Gokulkumar