Answers.Body: <p>If you are using price set then you might find this <a href="https://civicrm.org/blogs/eileen/getting-data-out-civi-extending-reports" rel="nofollow">blog</a> and the <a href="https://civicrm.org/extensions/extended-reports" rel="nofollow">extended reports extension</a> useful</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-09-11T00:42:28.227Z
Answers.Text: +1 for the Extended Reports extension, this will give you what you need.  This allows reporting (though not searching) based on the line items rather than the contribution.  There's also a rumor that the Botanical Society has an extension that allows searching on the line items...
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-09-14T15:51:46.493Z
Answers.Text: Ok.  Already have the Extended Report Ext loaded and the Export to Excel loaded.  I WILL dig deeper.
Answers.UserDisplayName: Gary Zimmerman
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-09-14T16:46:20.550Z
Answers.Text: I can not get the field called "Item"  The Extended Report shows Qty Unit Price, Total Price but I can not find the Item.  Any way to get the Item listed in the report?
Answers.UserDisplayName: Gary Zimmerman
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-09-18T13:52:38.917Z
Answers.Text: I AM WILLING TO PAY SOMEONE BECAUSE I HAVE TO GET THIS DONE!  Please email me directly if you can help!   Along with above here's what I have and then need.   
  HAVE: I do use a price set.  Once the Membership(s) are created and you go into the Individual Contact Membership Tab and Edit the membership and then edit the Related Payments at the top I will see the two line items with the Item, Qty, Unit Price, Total Price.  I MUST be able to search on the Line Item Des
Answers.UserDisplayName: Gary Zimmerman
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-09-18T14:02:23.117Z
Answers.Text: A sample of my data is "Chapter Dues - Pennsylvania-Delaware"  
  Using the Extended Reports Extension I can get the numerical values ok but the Item Description is not available.  Is there a way to create a custom SQL Query somewhere for this?    I NEED a report that gives me all Chapter Dues filtered by Receive date and Price.
Answers.UserDisplayName: Gary Zimmerman
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-09-09T22:20:02.730Z
Answers.LastActivityDate: 2015-09-09T22:20:02.730Z
Answers.UserDisplayName: petednz - fuzion
Body: <p>CiviCRM 4.6.8 and WP4.3
  I have Memberships setup with a main membership and chapter memberships.  When a person buys a Main Membership and Chapter Membership with one payment I can not report on the Chapter Member only.  It gives me the amount for the full payment.  When I look at the detail I can see the items for the payment.  How can I report on just the Chapter payment?   I can get just the Chapters but it shows the full payment.  Again, I need just the Chapter amount.</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-09-09T22:17:31.363Z
Comments.Text: Gary - are you using a Price Set?
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-09-14T15:14:07.580Z
Comments.Text: Yes.. using a Price Set.
Comments.UserDisplayName: Gary Zimmerman
Tags: <civicontribute><civimember>
Title: Member dues report
ThreadText: # Member dues report
  
  (Asked by: username_0 on 2015-09-09)
  
  CiviCRM 4.6.8 and WP4.3
  I have Memberships setup with a main membership and chapter memberships. When a person buys a Main Membership and Chapter Membership with one payment I can not report on the Chapter Member only. It gives me the amount for the full payment. When I look at the detail I can see the items for the payment. How can I report on just the Chapter payment? I can get just the Chapters but it shows the full payment. Again, I need just the Chapter amount.
  
  **Tags:** civicontribute, civimember
  
  > **Comments:**
  > **username_1**: Gary - are you using a Price Set?  
  > **username_0**: Yes.. using a Price Set.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2015-09-09. Score: 3
  
  If you are using price set then you might find this [blog](https://civicrm.org/blogs/eileen/getting-data-out-civi-extending-reports) and the [extended reports extension](https://civicrm.org/extensions/extended-reports) useful
  
  > **Comments:**
  > **username_2**: +1 for the Extended Reports extension, this will give you what you need.  This allows reporting (though not searching) based on the line items rather than the contribution.  There's also a rumor that the Botanical Society has an extension that allows searching on the line items...  
  > **username_0**: Ok.  Already have the Extended Report Ext loaded and the Export to Excel loaded.  I WILL dig deeper.  
  > **username_0**: I can not get the field called "Item"  The Extended Report shows Qty Unit Price, Total Price but I can not find the Item.  Any way to get the Item listed in the report?  
  > **username_0**: I AM WILLING TO PAY SOMEONE BECAUSE I HAVE TO GET THIS DONE!  Please email me directly if you can help!   Along with above here's what I have and then need.    HAVE: I do use a price set.  Once the Membership(s) are created and you go into the Individual Contact Membership Tab and Edit the membership and then edit the Related Payments at the top I will see the two line items with the Item, Qty, Unit Price, Total Price.  I MUST be able to search on the Line Item Des  
  > **username_0**: A sample of my data is "Chapter Dues - Pennsylvania-Delaware"   Using the Extended Reports Extension I can get the numerical values ok but the Item Description is not available.  Is there a way to create a custom SQL Query somewhere for this?    I NEED a report that gives me all Chapter Dues filtered by Receive date and Price.  
  
  ---
  
  