• thanks but optional parameters are choose by user we need to build where clause based on user selection for each report