CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviContribute (Moderator: Donald Lobo) »
  • Trying to track down where default civicontribute report info is stored
Pages: [1]

Author Topic: Trying to track down where default civicontribute report info is stored  (Read 420 times)

mchppit

  • I’m new here
  • *
  • Posts: 16
  • Karma: 0
  • CiviCRM version: 4.3
  • CMS version: Drupal 7
  • MySQL version: 5.1
  • PHP version: 4.1
Trying to track down where default civicontribute report info is stored
March 04, 2014, 11:49:01 am
Similar to this thread: http://forum.civicrm.org/index.php/topic,16905.msg122749.html#msg122749

We have somehow changed our contribution detail report to only return information with "contact ID =5".

I was looking through the SQL trying to see if that is a field somewhere in the table that controls this, and I'm digging around trying to figure out how this was changed in the default report template. Any ideas how I can remove this?

Thanks,
Brady

mchppit

  • I’m new here
  • *
  • Posts: 16
  • Karma: 0
  • CiviCRM version: 4.3
  • CMS version: Drupal 7
  • MySQL version: 5.1
  • PHP version: 4.1
Re: Trying to track down where default civicontribute report info is stored
March 04, 2014, 02:47:45 pm
Replaced 'detail.php' from my \CRM\Report\Form\Contribute with a newly downloaded detail.php and that didn't resolve the issue. I'm assuming I have some default setting wrong somewhere in the mysql or civicrm settings.

Attached is an image of the issue

joanne

  • Administrator
  • Ask me questions
  • *****
  • Posts: 852
  • Karma: 83
  • CiviCRM version: 4.4.16
  • CMS version: Drupal 7
Re: Trying to track down where default civicontribute report info is stored
March 04, 2014, 02:54:30 pm
I am presuming you have checked that the report detail >  set filters does not have anything in the donor name field.


Have you tried the solution suggested in that other post?

Go to Reports> Create Reports from Templates

In the Contribution Report Templates frame find  Donor Report (Detail)

Click on Existing report(s)  and Delete your existing version of Donor Report (Detail)

Go back to  Create Reports from Templates and this time click on  >>Donor Report (Detail).

After you Preview Report the option to  Create Report will appear.  Call it Donor Report (Detail) as you want to replace the one you deleted.

In the Other settings section:
Set  Parent Menu to  Reports
Set Permission to CiviContribute: access CiviContribute
Select Available for Dashboard?

then Create Report

mchppit

  • I’m new here
  • *
  • Posts: 16
  • Karma: 0
  • CiviCRM version: 4.3
  • CMS version: Drupal 7
  • MySQL version: 5.1
  • PHP version: 4.1
Re: Trying to track down where default civicontribute report info is stored
March 04, 2014, 04:35:46 pm
Thanks Joanne. Yep, all the filters are clear. I am going to try the 'fix' from the old post, but was also hoping to figure out what I did (and learn more along the way...). This 'issue' just traveled with me from one civicrm installation to another, so I'm thinking it is in the mySQL database unless I dragged along some altered template or something...

I'll give the fix a try, but if anyone else can think of how I might have hard coded "contact ID =5" as an 'unalterable' criteria in my contrib/detail report I'd love to hear it.

b

mchppit

  • I’m new here
  • *
  • Posts: 16
  • Karma: 0
  • CiviCRM version: 4.3
  • CMS version: Drupal 7
  • MySQL version: 5.1
  • PHP version: 4.1
Re: Trying to track down where default civicontribute report info is stored
March 04, 2014, 04:40:47 pm
Yep, that fix worked. Thanks for the walk through Joanne. I guess I'll try to find some time to dig in and see if I can deduce what I might have done before to cause the issue (I think it was done in civicrm 4.4.0 or similar...so perhaps it is related to an old issue).

Thanks for the walk through, that made it even smoother.
« Last Edit: March 05, 2014, 02:00:56 pm by mchppit »
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviContribute (Moderator: Donald Lobo) »
  • Trying to track down where default civicontribute report info is stored

This forum was archived on 2017-11-26.