I'm looking to build a custom report that shows all tickets open/on hold/waiting on client or waiting on vendor that have not been updated in 7 days.

I'm looking to add the following fields in the following order: 

Request ID

Requester

Request Status

Subject

Technician

Created Time

Due By Time

Last Update Time

I tried building a tabular report myself and could not filter out the last 7 days. 

mssql database

ver 9.0 build 9009

Thanks.