Answers.Body: <p>4.2->4.7 is a <em>huge</em> upgrade. Swathes of tables - including Activities and Settings - have changed. If you have any custom reports or extensions these definitely will need to be upgraded without a doubt.</p>
  
  <p>This could be caused by a number of things.</p>
  
  <ol>
  <li><p>Is this all reports, or just some? What are the names of the failing reports?</p></li>
  <li><p>Please could you provide a screenshot?</p></li>
  <li><p>Have you looked in the CiviCRM error logs and the Joomla! logs?</p></li>
  </ol>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-02-23T04:28:15.013Z
Answers.Text: All reports are not showing up an I had to update the database for activities_contacts as it was blank so I had to move manually or the original activities_target table, even creating new ones won't show up, this is the original site: https://www.screencast.com/t/atjQkP55Bwp and this is the new site: https://www.screencast.com/t/ckFmcyLAHR also no errors show on joomla or civicrm error logs.
Answers.UserDisplayName: Guillermo Ricci
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-02-17T03:06:19.600Z
Answers.LastActivityDate: 2017-02-17T03:06:19.600Z
Answers.UserDisplayName: JohnFF
Answers.Body: <p>Agree with JohnFF, if you have customized reports and are moving from 4.2 to 4.7 you will almost certainly need to upgrade each and everyone of those reports.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-02-23T04:29:12.360Z
Answers.Text: How are they upgraded? This is the first time I had to deal directly with CiviCRM as I don't use it for personal projects and is a lot different 4.2 to 4.7 which is why I'm not sure if something else causes this.
Answers.UserDisplayName: Guillermo Ricci
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-02-23T08:36:22.403Z
Answers.Text: Assuming you are using customized reports and do not have a CiviCRM/PHP developer in your staff, you have to find a CiviCRM expert/developer to do this for you? You can check the CiviCRM website (Find an Expert) for a list of partners near you?
Answers.UserDisplayName: ErikH - CiviCooP
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-02-17T09:35:18.310Z
Answers.LastActivityDate: 2017-02-17T09:35:18.310Z
Answers.UserDisplayName: ErikH - CiviCooP
Body: <p>I need to know what tables and fields are used for the CiviCRM reports, I've been dealing for several weeks trying to see why an updated site from CiviCRM 4.2 to 4.7.16 on Joomla is not showing any reports, I need to see if several tables changed or fields and where to look into why they are not showing up as they don't show any errors, they only show no result at all. Thank you.</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-02-17T15:39:06.413Z
Comments.Text: Different reports use different tables, because they report on different things!
Comments.UserDisplayName: Jon G - Megaphone Tech
Tags: <joomla><civireport><database>
Title: What tables are used for civicrm reports?
ThreadText: # What tables are used for civicrm reports?
  
  (Asked by: username_0 on 2017-02-17)
  
  I need to know what tables and fields are used for the CiviCRM reports, I've been dealing for several weeks trying to see why an updated site from CiviCRM 4.2 to 4.7.16 on Joomla is not showing any reports, I need to see if several tables changed or fields and where to look into why they are not showing up as they don't show any errors, they only show no result at all. Thank you.
  
  **Tags:** joomla, civireport, database
  
  > **Comments:**
  > **username_1**: Different reports use different tables, because they report on different things!  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_2 on 2017-02-17. Score: 1
  
  4.2->4.7 is a *huge* upgrade. Swathes of tables - including Activities and Settings - have changed. If you have any custom reports or extensions these definitely will need to be upgraded without a doubt.
  
  This could be caused by a number of things.
  
  1. Is this all reports, or just some? What are the names of the failing reports?
  2. Please could you provide a screenshot?
  3. Have you looked in the CiviCRM error logs and the Joomla! logs?
  
  > **Comments:**
  > **username_0**: All reports are not showing up an I had to update the database for activities_contacts as it was blank so I had to move manually or the original activities_target table, even creating new ones won't show up, this is the original site: https://www.screencast.com/t/atjQkP55Bwp and this is the new site: https://www.screencast.com/t/ckFmcyLAHR also no errors show on joomla or civicrm error logs.  
  
  ---
  
  ### Answer by username_3 on 2017-02-17. Score: 0
  
  Agree with username_2, if you have customized reports and are moving from 4.2 to 4.7 you will almost certainly need to upgrade each and everyone of those reports.
  
  > **Comments:**
  > **username_0**: How are they upgraded? This is the first time I had to deal directly with CiviCRM as I don't use it for personal projects and is a lot different 4.2 to 4.7 which is why I'm not sure if something else causes this.  
  > **username_3**: Assuming you are using customized reports and do not have a CiviCRM/PHP developer in your staff, you have to find a CiviCRM expert/developer to do this for you? You can check the CiviCRM website (Find an Expert) for a list of partners near you?  
  
  ---
  
  