continue to modify the report to return the expected data if the resources selected are multiple
get the idea from Mark for less and optimize the query, check if the query returns the expected data if resources selected in the parameter is single or multiple
as per checking, it is now OK and returning the expected data, apply the query in the report
check if the report returns the data as the data in the query, as per checking, it is returning the data and based on the selected data in parameter