Once you cleared then report will show blank right. how your report stays older one.
Please attach workbook.
Thanks for your reply.
I am using mysql. I have written custom sql query with parameters.
I will get the list of records while running the query with parameters if i change anything in the parameter section report gets refreshed based on the modified parameter.
Is there way to get the existing record based on clearing the parameter value (like clearing the current value of parameter)
I am able to get the existing records by clearing the current value (edit parameter->clear current value) but do not able to do the same while clearing the value from the parameter control