Skip to Content
Former Member
Sep 17, 2014 at 10:28 AM

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.