How can I generate report for a time-distributed Resource utilization?

You can use Resource Usage Spreadsheet (Reports ribbon) to get Resource Utilization based on a defined time period. To change the period, right-click on the Timescale > Edit Timescale.

Note that only the child level Resources that are visible in the Resources window will be displayed in the Spreadsheet -