Title: No record Display
Last modified: August 24, 2016

---

# No record Display

 *  [ypsmag](https://wordpress.org/support/users/ypsmag/)
 * (@ypsmag)
 * [11 years ago](https://wordpress.org/support/topic/no-record-display/)
 * Sorry i’m new here. Can anyone told me what is my error.
    1. i have the below
   SQL, If just only this sql without add any Fields (optional) it run ok with all
   the display and record. If add Fields (optional) with c.company_name it will 
   display the record rows with correct but no value display out in the report. 
   Any setting i need to put in the Fields (optional)?
 *     ```
       select c.company_name, t.type, m.privilege_no, t.created_at, t.spent, t.points from transactions t
       left join merchants c ON c.id = t.source_id
       left join members m ON m.privilege_no = t.recipient_id
       left join users u ON u.id = m.user_id
       left join privilege_cards p ON p.privilege_no = t.recipient_id
       ```
   
 * [https://wordpress.org/plugins/exports-and-reports/](https://wordpress.org/plugins/exports-and-reports/)

The topic ‘No record Display’ 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/)

## Tags

 * [l](https://wordpress.org/support/topic-tag/l/)

 * 0 replies
 * 1 participant
 * Last reply from: [ypsmag](https://wordpress.org/support/users/ypsmag/)
 * Last activity: [11 years ago](https://wordpress.org/support/topic/no-record-display/)
 * Status: not resolved