Answers.Body: <p>As I said to your previous post about the same topic here: <a href="https://civicrm.stackexchange.com/questions/17281/what-tables-are-used-for-civicrm-reports">What tables are used for civicrm reports?</a></p>
  
  <blockquote>
    <p>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.</p>
  </blockquote>
  
  <p>As ErikH said:</p>
  
  <blockquote>
    <p>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</p>
  </blockquote>
  
  <p>Upgrading these reports will require a coder to change their code to point them to the new database tables used by CiviCRM. There's no workaround. Code for custom reports will need to be changed. Tell your next developer to use the CiviCRM API if possible!</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-03-12T06:09:55.787Z
Answers.LastActivityDate: 2017-03-12T06:09:55.787Z
Answers.LastEditDate: 2017-04-13T12:53:13.207Z
Answers.UserDisplayName: JohnFF
Answers.Body: <p>I would check the CiviCRM log files.  <a href="https://civicrm.stackexchange.com/questions/15931/where-are-the-configandlog-and-templates-c-directories">Find them here</a>.  Also try steps listed here: <a href="https://civicrm.stackexchange.com/questions/6399/how-do-i-debug-civicrm-when-i-hit-a-blank-page-white-screen-fatal-error">How do I debug CiviCRM when I hit a blank page / white screen / fatal error?</a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-03-13T06:52:12.703Z
Answers.LastActivityDate: 2017-03-13T06:52:12.703Z
Answers.LastEditDate: 2017-04-13T12:53:13.167Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.Body: <p>Just a hint, the connection between the report URL and the executing report PHP class is stored in the option tables. Does following query return any results?</p>
  
  <pre><code>select  *  FROM civicrm_option_value v
  ,                  civicrm_option_group g
  where   g.id = v.option_group_id
  and     g.name = 'report_template'
  </code></pre>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-02-16T01:53:31.927Z
Answers.Text: Unfortunately this didn't help, also seems CiviCRM 4.2.7 doesn't have some tables that 4.7.13 does have and it might be the problem but even creating new activities we get no reports shown.
Answers.UserDisplayName: Guillermo Ricci
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-02-08T15:46:51.137Z
Answers.LastActivityDate: 2017-02-08T15:46:51.137Z
Answers.UserDisplayName: Kainuk - CiviCooP
Body: <p>CiviCRM was updated from 4.2.7 and right now is even updated to 4.7.16 but when we try to get reports and even try to click on "Refresh Results" it shows nothing, not even an error about it. The original site still has CiviCRM 4.2.7 and is able to show all reports with no trouble. I've been looking for any file, database table or anything that might be missing and needs to be updated but can't find what is causing this, any ideas what might be?</p>
  
  <p>Regards,</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-03-13T06:47:09.223Z
Comments.Text: Please update your question to indicate which reports you tested?
Comments.UserDisplayName: Jon G - Megaphone Tech
Tags: <civireport>
Title: CiviCRM upgrade from 4.2.7 to 4.7.13 fails to show any report
ThreadText: # CiviCRM upgrade from 4.2.7 to 4.7.13 fails to show any report
  
  (Asked by: username_0 on 2017-02-08)
  
  CiviCRM was updated from 4.2.7 and right now is even updated to 4.7.16 but when we try to get reports and even try to click on "Refresh Results" it shows nothing, not even an error about it. The original site still has CiviCRM 4.2.7 and is able to show all reports with no trouble. I've been looking for any file, database table or anything that might be missing and needs to be updated but can't find what is causing this, any ideas what might be?
  
  Regards,
  
  **Tags:** civireport
  
  > **Comments:**
  > **username_1**: Please update your question to indicate which reports you tested?  
  
  ---
  
  ## 3 answers
  
  ### Answer by username_2 on 2017-03-12. Score: 1
  
  As I said to your previous post about the same topic here: [What tables are used for civicrm reports?](https://civicrm.stackexchange.com/questions/17281/what-tables-are-used-for-civicrm-reports)
  
  > 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.
  
  As ErikH said:
  
  > 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
  
  Upgrading these reports will require a coder to change their code to point them to the new database tables used by CiviCRM. There's no workaround. Code for custom reports will need to be changed. Tell your next developer to use the CiviCRM API if possible!
  
  
  ---
  
  ### Answer by username_1 on 2017-03-13. Score: 1
  
  I would check the CiviCRM log files. [Find them here](https://civicrm.stackexchange.com/questions/15931/where-are-the-configandlog-and-templates-c-directories). Also try steps listed here: [How do I debug CiviCRM when I hit a blank page / white screen / fatal error?](https://civicrm.stackexchange.com/questions/6399/how-do-i-debug-civicrm-when-i-hit-a-blank-page-white-screen-fatal-error)
  
  
  ---
  
  ### Answer by username_3 on 2017-02-08. Score: 0
  
  Just a hint, the connection between the report URL and the executing report PHP class is stored in the option tables. Does following query return any results?
  select  *  FROM civicrm_option_value v
  ,                  civicrm_option_group g
  where   g.id = v.option_group_id
  and     g.name = 'report_template'
  
  > **Comments:**
  > **username_0**: Unfortunately this didn't help, also seems CiviCRM 4.2.7 doesn't have some tables that 4.7.13 does have and it might be the problem but even creating new activities we get no reports shown.  
  
  ---
  
  