• I find what the problem was.

    The code above works perfeclty when I select each parameter individually, problem occurs when all parameters are selected at once which occurs when the report first loads (this is because the lookup does not find the matching records).

    So I will make the "All" parameter and handle its case.

    Thanks