Crystal reports 2011, cascading parameter based on a value
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.
Abhilash Kumar replied
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.