Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Tags:
Former Member
replied

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

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question