Title: ELI's SQL Reports
Last modified: September 2, 2016

---

# ELI's SQL Reports

 *  [w4npn](https://wordpress.org/support/users/w4npn/)
 * (@w4npn)
 * [12 years, 8 months ago](https://wordpress.org/support/topic/elis-sql-reports/)
 * Great Plugin! But the MySQL “SET” syntax doesn’t work. I want to establish a 
   Variable: SET @TotalRev=0 and this is rejected every time. Maybe I’m doing something
   dumb?
    Otherwise it is excellent++ Frank

Viewing 1 replies (of 1 total)

 *  Plugin Author [Eli](https://wordpress.org/support/users/scheeeli/)
 * (@scheeeli)
 * [12 years, 7 months ago](https://wordpress.org/support/topic/elis-sql-reports/#post-7796261)
 * Thanks for the great review. I just released an update to my plugin that should
   allow you to execute multiple SQL statements in you Report. This should solve
   your problem of using SET statements prior to your SELECT statement.
 * Upgrade to version 3.10.19 and let me know how it works for you.
 * Aloha, Eli

Viewing 1 replies (of 1 total)

The topic ‘ELI's SQL Reports’ is closed to new replies.

 * ![](https://ps.w.org/elisqlreports/assets/icon-256x256.png?rev=1231385)
 * [EZ SQL Reports Shortcode Widget and DB Backup](https://wordpress.org/plugins/elisqlreports/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/elisqlreports/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/elisqlreports/)
 * [Active Topics](https://wordpress.org/support/plugin/elisqlreports/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/elisqlreports/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/elisqlreports/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Eli](https://wordpress.org/support/users/scheeeli/)
 * Last activity: [12 years, 7 months ago](https://wordpress.org/support/topic/elis-sql-reports/#post-7796261)