I use the status="Closed" and action="Closed" to capture those.

workitem_status_lookup_value='Closed' and workitem_action='Closed' ORDER BY workitem_number ASC

Hi Mboggs,
I used the Wizard and the query is stated below:

SELECT
T0.[workitem_number] AS 'Incident Number',
T0.[workitem_status_lookup_value] AS 'Status'
FROM [HD_workitem_current_view] T0
WHERE (T0.[workitem_action] = 'Closed'
AND T0.[workitem_status_lookup_value] = 'Closed') AND DATEDIFF(DAY, T0.[workitem_created_on], GETDATE()) <= %N Days%
ORDER BY T0.[workitem_number] ASC

However the results are coming up with incidents which have the created date of way past the 7 days that I declared in the paramaters.

I hope you're able to assist.

Thanks

make sure your variable of N days is set to 7 in your report parameters and that the checkbox for Replace with SQL parameter is checked and the Prompt for value is NOT checked.

I used this SQL and hard coded 7 days and only get 7 days worth of results, so it must be your parameter.