One of my report using cascading parameters for a searching function – one parameter takes input and pass the value to anther parameter for generating a drop-down list(by query).
I’m thinking about to add an option for turning off the search function at user’s need. What I did is setting the first parameter to allow NULL, so the NULL check-box can be checked or un-checked. The issue I have is since the second parameter
is based on a query, it always execute the query and ask for select a value from the list.
Is there a better way to do it?
Thanks a lot
View Complete Post