You can add an Ad-Hoc report by following the steps below:
From the DPS FD home screen, select Reports.
Click Ad-Hoc Reports.
Click Add New Report.
Enter a Report Name.
Paste your SQL query to the Report Query.
add Report OrderBy Field Name (Optional).
Click Get Fields.
Click Add Report.
Click Refresh.
Select new report from Select Report dropdown box.
Click View Ad-Hoc Report.