Need help using EXEC in Report for running SQL query in stored procedure

I'm trying to run a SQL SELECT query from a Report using the EXEC command in Report Designer, but the documentation for it is very limited and I'm having trouble getting it to work. Can someone help me?

The SELECT query I'm trying to run is this:

select prefix, middle, revision, copy_no, file_name, left(action_date,11), person_code from documents
left join document_copies on documents.document_id = document_copies.document_id
left join doc_copy_files on document_copies.copy_id = doc_copy_files.copy_id
left join doc_source on doc_copy_files.file_id = doc_source.pdm_file_id
left join object_audit_info on documents.document_id = object_audit_info.object_id
left join persons on object_audit_info.person_id = persons.person_id
where documents.status = 'N'
and documents.class_id = '108'
and documents.template = 'N'
and current_revision = 'y'
and has_other_revs = 'y'
and (file_name is not null
and file_name not LIKE '%eB Historic%')
and object_type = 3
and action_type = 1
order by prefix, middle, revision, copy_no

Thanks