Answers.Body: <p>Check out an example here - this is a report that joins tables the extension creates/maintains with other civicrm core tables to produce this report:</p>
  
  <p><a href="https://github.com/jake-mw/CDNTaxReceipts/blob/master/CRM/Cdntaxreceipts/Form/Report/ReceiptsIssued.php" rel="nofollow noreferrer">https://github.com/jake-mw/CDNTaxReceipts/blob/master/CRM/Cdntaxreceipts/Form/Report/ReceiptsIssued.php</a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-09-20T04:36:56.450Z
Answers.LastActivityDate: 2017-09-20T04:36:56.450Z
Answers.UserDisplayName: KarinG - Semper IT
Answers.Body: <p>There shouldn't be anything special you need to do. In your report code you just reference them the same way you do in your extension.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-09-20T03:17:27.883Z
Answers.LastActivityDate: 2017-09-20T03:17:27.883Z
Answers.UserDisplayName: Demerit
Body: <p>I have several custom tables that I have created for use with extensions that I have built. </p>
  
  <p>I would like to use those tables in a custom report. What is the best approach for this? I checked the documentation and did not see anything clear.</p>
  
  <p>I appreciate any direction for this!</p>
  
Tags: <civireport><database><mysql><custom-reports>
Title: Using an External (custom) Table in a Custom Report
ThreadText: # Using an External (custom) Table in a Custom Report
  
  (Asked by: username_0 on 2017-09-19)
  
  I have several custom tables that I have created for use with extensions that I have built.
  
  I would like to use those tables in a custom report. What is the best approach for this? I checked the documentation and did not see anything clear.
  
  I appreciate any direction for this!
  
  **Tags:** civireport, database, mysql, custom-reports
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2017-09-20. Score: 3
  
  Check out an example here - this is a report that joins tables the extension creates/maintains with other civicrm core tables to produce this report:
  
  <https://github.com/jake-mw/CDNTaxReceipts/blob/master/CRM/Cdntaxreceipts/Form/Report/ReceiptsIssued.php>
  
  
  ---
  
  ### Answer by username_2 on 2017-09-20. Score: 0
  
  There shouldn't be anything special you need to do. In your report code you just reference them the same way you do in your extension.
  
  
  ---
  
  