I need to generate a weekly and monthly report on the tasks and work logs added with the following details:

Our database is Postgre

For Weekly and Monthly Ticket Report - focusing on the Service Request/Incident  IDs created in a given week or month

Request ID

Created Time

Technician

Group (I want to define only the specific groups that I need to include in the report)

Request Status

Work Log Added by (Technician name)

Time spent on each work log

Total Time Spent (Total time of all the work logs under specific Request ID)

Work Log Date

For Weekly and Monthly Ticket Report - focusing on Task IDs created in a given week or month. This includes Tasks for Service/Incident Request, Change Requests, Problems and Projects

Task ID

Service/Incident Request ID or Problem ID or Change ID or Project ID associated to the task

Task Created Date (Can you make it flexible that I can set a specific date range I want?)

Task Owner

Actual Time spent on Task

Total Time spent per Task Owner

Task Status