Answers.Body: <p>See also  <a href="https://civicrm.org/bug-reporting" rel="nofollow noreferrer">https://civicrm.org/bug-reporting</a> but take a look at <a href="https://civicrm.stackexchange.com/questions/17286/bug-reports-and-feedback">the question</a> I am just about to post in case you're interested in civiCRM.org/higher level bug reporting and feedback</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-02-17T12:28:20.950Z
Answers.LastActivityDate: 2017-02-17T20:41:56.817Z
Answers.LastEditDate: 2017-04-13T12:53:13.207Z
Answers.UserDisplayName: Nick Plant
Answers.Body: <p>With most extensions, the place to report bugs is on Github. In this case you want to go to <a href="https://github.com/eileenmcnaughton/nz.co.fuzion.extendedreport" rel="nofollow">https://github.com/eileenmcnaughton/nz.co.fuzion.extendedreport</a> and click on the "Issues" tab at the top.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-03-09T15:52:26.363Z
Answers.Text: I also ran into the same problem of not knowing where to place a bug report on this extension.  Perhaps an extra line on the extension page to this effect is in order?
Answers.UserDisplayName: G H
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-03-07T19:31:57.473Z
Answers.LastActivityDate: 2016-03-07T19:31:57.473Z
Answers.UserDisplayName: Coleman
Body: <p>I have recently installed the <a href="https://civicrm.org/extensions/extended-reports" rel="nofollow noreferrer">Extended Reports Extension</a> within civiCRM. However, I am noticing some strange behavior when I attempt to make a template. </p>
  
  <p>Within the Bookkeeping with extra fields template, if I use the group by function, I do not receive the proper line totals (they are not adding up). </p>
  
  <p>For instance, if I group by line item financial type, it groups it correctly, but the line totals are wrong: 
  <a href="https://i.sstatic.net/vVUy4.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/vVUy4.png" alt="bookkeeping group by line item"></a></p>
  
  <p>If I use the Contribution Based Line Item report, the totals are accurate. However, I need the account code on this report, which is why I was using the bookkeeping report. 
  <a href="https://i.sstatic.net/21jK1.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/21jK1.png" alt="line item report"></a></p>
  
  <p>Any idea on how to fix this or make the account codes available in the Contribution Based Report? I looked through the code and was able to make the financial account columns appear; however, upon selecting the columns I got a "DB not available error". I believe I need to add something similar to the code below, but I wasn't exactly sure how to do it correctly. </p>
  
  <pre><code>function joinActivityFromCase() {
  $this-&gt;_from .= "
    LEFT JOIN {$this-&gt;_caseActivityTable} cca ON cca.case_id = {$this-&gt;_aliases['civicrm_case']}.id
    LEFT JOIN civicrm_activity {$this-&gt;_aliases['civicrm_activity']} ON {$this-&gt;_aliases['civicrm_activity']}.id = cca.activity_id";
  }
  </code></pre>
  
  <p>I couldn't find a place to report the bug on civiCRM, so I posted it here.</p>
  
Tags: <civireport><extension><custom-reports>
Title: Extended Reports Bug?
ThreadText: # Extended Reports Bug?
  
  (Asked by: username_0 on 2016-03-07)
  
  I have recently installed the [Extended Reports Extension](https://civicrm.org/extensions/extended-reports) within civiCRM. However, I am noticing some strange behavior when I attempt to make a template.
  
  Within the Bookkeeping with extra fields template, if I use the group by function, I do not receive the proper line totals (they are not adding up).
  
  For instance, if I group by line item financial type, it groups it correctly, but the line totals are wrong:
  [![bookkeeping group by line item](https://i.sstatic.net/vVUy4.png)](https://i.sstatic.net/vVUy4.png)
  
  If I use the Contribution Based Line Item report, the totals are accurate. However, I need the account code on this report, which is why I was using the bookkeeping report.
  [![line item report](https://i.sstatic.net/21jK1.png)](https://i.sstatic.net/21jK1.png)
  
  Any idea on how to fix this or make the account codes available in the Contribution Based Report? I looked through the code and was able to make the financial account columns appear; however, upon selecting the columns I got a "DB not available error". I believe I need to add something similar to the code below, but I wasn't exactly sure how to do it correctly.
  
  ```
  function joinActivityFromCase() {
  $this->_from .= "
    LEFT JOIN {$this->_caseActivityTable} cca ON cca.case_id = {$this->_aliases['civicrm_case']}.id
    LEFT JOIN civicrm_activity {$this->_aliases['civicrm_activity']} ON {$this->_aliases['civicrm_activity']}.id = cca.activity_id";
  }
  
  ```
  
  I couldn't find a place to report the bug on civiCRM, so I posted it here.
  
  **Tags:** civireport, extension, custom-reports
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_2 on 2016-03-07. Score: 4 | Accepted answer
  
  With most extensions, the place to report bugs is on Github. In this case you want to go to <https://github.com/eileenmcnaughton/nz.co.fuzion.extendedreport> and click on the "Issues" tab at the top.
  
  > **Comments:**
  > **username_3**: I also ran into the same problem of not knowing where to place a bug report on this extension.  Perhaps an extra line on the extension page to this effect is in order?  
  
  ---
  
  ### Answer by username_1 on 2017-02-17. Score: 3
  
  See also <https://civicrm.org/bug-reporting> but take a look at [the question](https://civicrm.stackexchange.com/questions/17286/bug-reports-and-feedback) I am just about to post in case you're interested in civiCRM.org/higher level bug reporting and feedback
  
  
  ---
  
  