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.