Title: Create a custom report using different data tables
Last modified: March 14, 2025

---

# Create a custom report using different data tables

 *  Resolved [snapdesign](https://wordpress.org/support/users/snapdesign/)
 * (@snapdesign)
 * [1 year, 1 month ago](https://wordpress.org/support/topic/create-a-custom-report-using-different-data-tables/)
 * Can someone provide me with the steps to create a custom report that pulls information
   from different columns in different data tables within my WordPress database?
   All I need is a simple spreadsheet layout with the information and able to download
   a CSV file from it. Thanks so much!

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

 *  Plugin Contributor [Kim L](https://wordpress.org/support/users/kimmyx/)
 * (@kimmyx)
 * [1 year, 1 month ago](https://wordpress.org/support/topic/create-a-custom-report-using-different-data-tables/#post-18364803)
 * Hi [@snapdesign](https://wordpress.org/support/users/snapdesign/),
 * You can use our **SQL Query Builder** to execute a **create view **statement 
   between tables to pull columns from them.
 * See here: [SQL Query Builder](https://wpdataaccess.com/docs/sql-query-builder/query-builder-getting-started/)
 * We suggest creating a **view** and then, and then creating a data table app of
   the result.
 * Here’s a short demo on how to create a view and then a data table app using the
   view as a data source: [https://share.zight.com/KouRxKQJ](https://share.zight.com/KouRxKQJ)
 * You can then export a report using the **Bulk Actions** button. See here: [Bulk Actions | WP Data Access](https://wpdataaccess.com/docs/table/bulk-actions/)
 * For more information about create view statements, you can refer to this guide:
   [SQL Views](https://www.geeksforgeeks.org/sql-views/)
 * Hope that helps! Let us know if you have other questions. 😊
 *  Thread Starter [snapdesign](https://wordpress.org/support/users/snapdesign/)
 * (@snapdesign)
 * [1 year, 1 month ago](https://wordpress.org/support/topic/create-a-custom-report-using-different-data-tables/#post-18370571)
 * Thank you Kim! Super helpful! 🙂

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

The topic ‘Create a custom report using different data tables’ is closed to new 
replies.

 * ![](https://ps.w.org/wp-data-access/assets/icon-256x256.png?rev=3299063)
 * [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards](https://wordpress.org/plugins/wp-data-access/)
 * [Support Threads](https://wordpress.org/support/plugin/wp-data-access/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-data-access/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-data-access/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-data-access/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [snapdesign](https://wordpress.org/support/users/snapdesign/)
 * Last activity: [1 year, 1 month ago](https://wordpress.org/support/topic/create-a-custom-report-using-different-data-tables/#post-18370571)
 * Status: resolved