Title: Executing the report
Last modified: December 14, 2018

---

# Executing the report

 *  [alanbaker](https://wordpress.org/support/users/bakeralanbakernet/)
 * (@bakeralanbakernet)
 * [7 years, 5 months ago](https://wordpress.org/support/topic/executing-the-report/)
 * Hello Scott and All,
 * This plugin looks perfect for my needs, but I have an embarrassingly fundamental
   question. I’ve defined a group and a report, but I don’t see a way to run the
   report from the WP dashboard.
 * Within Manage Reports, I can Edit, Duplicate, or Delete a report. Within Reports
   I can choose a report and it responds with View Report <reportname> and below
   that it says No items found.
 * I don’t see an option to run the report. Is ‘No items found’ telling me I’ve 
   overlooked something important? What am I missing? I’m using Version 0.8.1 on
   WP 5.01.
 * Thanks for your guidance,
 * Alan

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Author [Scott Kingsley Clark](https://wordpress.org/support/users/sc0ttkclark/)
 * (@sc0ttkclark)
 * [7 years, 5 months ago](https://wordpress.org/support/topic/executing-the-report/#post-10990675)
 * The reports are just SQL SELECT queries. You select data and the report configuration
   helps you display that data in columns that are searchable, filterable, paginated,
   and exportable. What kind of query are you trying to do?
 *  Thread Starter [alanbaker](https://wordpress.org/support/users/bakeralanbakernet/)
 * (@bakeralanbakernet)
 * [7 years, 5 months ago](https://wordpress.org/support/topic/executing-the-report/#post-10990755)
 * Thanks for your reply, Scott. I’m very familiar with SQL SELECTs and database
   stuff, which is why your plugin is so appealing to me.
 * I’ve coded the SELECT into the SQL Query box in the Edit Report screen and pressed
   the Save Changes button, so now the report is all ready to run. But I don’t know
   the next step. How do I run the saved query?
 * Regards,
 * Alan
 *  Plugin Author [Scott Kingsley Clark](https://wordpress.org/support/users/sc0ttkclark/)
 * (@sc0ttkclark)
 * [7 years, 5 months ago](https://wordpress.org/support/topic/executing-the-report/#post-10990921)
 * The query will run when you view the report. It shows the results from the query.
 * Perhaps you can share details of your report with me to help you further? Send
   it to lol at scottkclark.com
 * Please provide:
    - The SQL query you are using in the report
    - Screenshot of the edit report screen with your settings
    - Screenshot of the view report screen for your report
    - Add `&debug=1` to your report URL and copy the query it gives you and include
      that
 * Thanks!

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Executing the report’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/exports-and-reports.svg)
 * [Exports and Reports](https://wordpress.org/plugins/exports-and-reports/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/exports-and-reports/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/exports-and-reports/)
 * [Active Topics](https://wordpress.org/support/plugin/exports-and-reports/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/exports-and-reports/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/exports-and-reports/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [Scott Kingsley Clark](https://wordpress.org/support/users/sc0ttkclark/)
 * Last activity: [7 years, 5 months ago](https://wordpress.org/support/topic/executing-the-report/#post-10990921)
 * Status: not resolved