Please help with this report.

I would like to generate a report from Incident Requests module which should show me all tickets that were reported in last 2 weeks (fortnight) and their respective status, requester, technician etc and in the same report it should also show all the tickets that were resolved in the last 2 weeks,

i.e All tickets with

Created Time = last 2 weeks & Resolved Time = Last 2 weeks

It becomes a bit tricky when done from custom reports because in date filter i could enter just 1 filter either Created time or Resolved time and when i add the other condition in advance filtering it doesn't work the way i want it to.

Also i have included a vertical bar chart with Request Status on X-axis.

Report doesn't show all request status when i select Resolved Time = Last 2 weeks in Date Filter options. it just shows Resolved and closed even if i have added additional filter of created time = last 2 weeks.

Also, in Date Filter options there is no fortnight option in During, it has only got Today, This week, Last week, This Month and so on . How can i schedule a dynamic report which would run every Monday and look back last couple of weeks and generate info that i have mentioned above.

Please advise.

Thanks