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 CiviReport (Moderator: Dave Greenberg) »
  • Filter report on price options
Pages: [1]

Author Topic: Filter report on price options  (Read 902 times)

leupi

  • I post frequently
  • ***
  • Posts: 192
  • Karma: 2
Filter report on price options
March 07, 2013, 12:10:31 pm
I have an event that uses a Price Set and within that Price Set are a couple of field labels and within them are differing price options. For example one of the field labels is ‘Field Trips’ and within that are two price options, ‘Potomac River’ and ‘Main Street’. Is there a way to run a report filtering on these price options in any way? I would like to run a report and see who chose which ones, basically, how many people are going to each of those field trips.

KilakwaBT

  • I post occasionally
  • **
  • Posts: 101
  • Karma: 11
  • CiviCRM version: 4.5.5
  • CMS version: WordPress 4.1
  • MySQL version: 5.1.68
  • PHP version: 5.3
Re: Filter report on price options
March 07, 2013, 02:48:14 pm
I have been wrestling with a similar issue. The Extended report extension should help with this but I have been having trouble getting it to run on my install.

Under Search/Custom Searches there is a search called "Price Set Details for Event Participants" it provides a list of participants and who selected what. It does not provide totals but you can export the data and total things up in a spreadsheet.

Hope it helps

leupi

  • I post frequently
  • ***
  • Posts: 192
  • Karma: 2
Re: Filter report on price options
March 12, 2013, 11:57:35 am
That sounds about perfect but when I run the report I get this:
Quote
Sorry but we are not able to provide this at the moment.
DB Error: no such field
Return to home page.
Not sure why...

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Filter report on price options
March 12, 2013, 01:09:55 pm

what version of civi? might want to check the CiviCRM.*.log files to see a more detailed error message. In the past, i remember this error showing up due to price fields being deleted / disabled etc

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

leupi

  • I post frequently
  • ***
  • Posts: 192
  • Karma: 2
Re: Filter report on price options
March 13, 2013, 05:51:13 am
That was very helpful. If I reenable the two options that were disabled then I can run the report. So I did that and then promptly disabled them again. I also looked for the civicrm.log file under uploads, which is where I have the temporary files set to in CiviCRM Upload Directories. Unfortunately I cannot find this file.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Filter report on price options
March 13, 2013, 08:00:53 am

check under files/civicrm/ConfigAndLog

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Filter report on price options
March 18, 2013, 11:32:25 am
are you using v1.3 - just got a success report on that
http://forum.civicrm.org/index.php/topic,27943.0.html
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviReport (Moderator: Dave Greenberg) »
  • Filter report on price options

This forum was archived on 2017-11-26.