Answers.Body: <p>This <em>could</em> be a place where it's just easier for the users to use an advanced search to bring up a list of households related to their own contact record. It's definitely possible that this puts too much onus on the user for your use-case, but it really only adds a couple of clicks over pulling up a report:</p>
  
  <p><code>Advanced Search>Relationships tab
  Relationship Type = <em>your relationship from org to individual</em>
  Target Contact = <em>the reps name</em></code></p>
  
  <p>This would bring up the list of households the rep has a relationship for them. There are many ways to proceed in how they may 'tick off' these households for the year depending on the org process.</p>
  
  <p>If that's too much for this set of users than your "p.s." is probably on the right track and writing a custom report is the way to go here. I would not create an entire extension for this.</p>
  
  <p>If you're just adding results columns, it's usually pretty painless - the documentation is just kind of all over the place. The new .tpl file is a one-liner explained in Alastair's blog post. You can copy the base report (contact relationships in this case) .php file that is closest to what you want and then copy/paste the address block columns from a different report base that has them included.</p>
  
  <p>I would like to add two resources to your links above that I found helpful to put it all together when learning custom report writing for myself:</p>
  
  <p><a href="https://artfulrobot.uk/civicrm-custom-birthdays-report" rel="nofollow">https://artfulrobot.uk/civicrm-custom-birthdays-report</a></p>
  
  <p><a href="https://sf2012.civicrm.org/sites/default/files/slides/CiviCRM%20Reports-Customize%20and%20Extend.pdf" rel="nofollow">https://sf2012.civicrm.org/sites/default/files/slides/CiviCRM%20Reports-Customize%20and%20Extend.pdf</a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-09-15T18:32:33.173Z
Answers.LastActivityDate: 2016-09-15T18:32:33.173Z
Answers.UserDisplayName: Eli Lisseck
Answers.Body: <p>Are you on Drupal?  If so, you could do that with Views.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-09-13T09:41:13.573Z
Answers.Text: Thanks for your post.  It would be helpful for others if you could expand your answer with some more detail.
Answers.UserDisplayName: William Mortada
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-09-15T08:47:43.050Z
Answers.Text: I'm on WordPress
Answers.UserDisplayName: Alan Fuller
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-09-12T22:43:15.137Z
Answers.LastActivityDate: 2016-09-12T22:43:15.137Z
Answers.UserDisplayName: Aidan
Answers.Body: <p>Since you're on WordPress, Views won't help.  </p>
  
  <p>You could check the published extensions and see if any of those do what you need: go to <a href="https://civicrm.org/extensions" rel="nofollow">https://civicrm.org/extensions</a> and search for 'report'.  Two that might be of interest are: <a href="https://civicrm.org/extensions/extended-reports" rel="nofollow">https://civicrm.org/extensions/extended-reports</a> and <a href="https://civicrm.org/extensions/relationship-overview-report" rel="nofollow">https://civicrm.org/extensions/relationship-overview-report</a></p>
  
  <p>If none of those fit and you want to develop your own, create an extension (<a href="https://wiki.civicrm.org/confluence/display/CRMDOC/Create+a+Module+Extension#CreateaModuleExtension-Generateaskeletalextension" rel="nofollow">https://wiki.civicrm.org/confluence/display/CRMDOC/Create+a+Module+Extension#CreateaModuleExtension-Generateaskeletalextension</a>) and add a report (<a href="https://wiki.civicrm.org/confluence/display/CRMDOC/Create+a+Module+Extension#CreateaModuleExtension-Addareport" rel="nofollow">https://wiki.civicrm.org/confluence/display/CRMDOC/Create+a+Module+Extension#CreateaModuleExtension-Addareport</a>)
  Note that you can copy an existing report to modify.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-09-19T12:18:34.263Z
Answers.Text: I have found that There is an extended reports extension - that actually covers my initial use case of address columns.
  
  But my requirement goes further and I'm pretty certain I will have to custom code.  I will post a related 'help' question relating to getting some pointers mainly on the SQL.
Answers.UserDisplayName: Alan Fuller
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-09-15T09:51:59.087Z
Answers.LastActivityDate: 2016-09-15T09:51:59.087Z
Answers.UserDisplayName: Aidan
Body: <p>Can you point me to resources that can cover this requirements, I'm sure it would be needed often, and whilst I can dive into working it out from first principals, as a newbie, it would be nice to get thr benefit of some starting points.</p>
  
  <p>Scenario is multiple households are 'managed' by an individual rep.</p>
  
  <p>I would like to produce a reported, grouped / broken by rep of all their households.</p>
  
  <p>Effectively a 'responsibility list' they can use to 'tick off' their annual visit to households.</p>
  
  <p>So I have set up reps as type of 'individual'</p>
  
  <p>and set up an A-B relationship between rep and household.</p>
  
  <p>The standard 'contact relationship' goes part way there, but for instance doesn't have address.</p>
  
  <p>I can see a 'developer tab' so I am assuming I can tweak the SQL -  but before I start hacking around I though I'd ask the best way to approach this.</p>
  
  <p>Thanks</p>
  
  <p>p.s.  </p>
  
  <p>I found this <a href="https://wiki.civicrm.org/confluence/display/CRMDOC/CiviReport+Reference" rel="nofollow">https://wiki.civicrm.org/confluence/display/CRMDOC/CiviReport+Reference</a>
  the implication to me is to write a custom php report?  Is that the right approach?</p>
  
  <p>Seems pretty heavy weight  to get the desired results - but blogs lik ethis seem to indicate it is the way to go</p>
  
  <p><a href="https://alastaira.wordpress.com/2011/03/17/civicrm-creating-a-custom-report/" rel="nofollow">https://alastaira.wordpress.com/2011/03/17/civicrm-creating-a-custom-report/</a></p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-09-13T09:44:29.280Z
Comments.Text: Thanks for your post.  Please indicate which version of CiviCRM you are using and which CMS you are using (e.g. Drupal, WordPress or Joomla).  The answers will vary depending on your CMS.
Comments.UserDisplayName: William Mortada
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-09-13T09:45:44.533Z
Comments.Text: You may find the answers to this related question helpful: http://civicrm.stackexchange.com/questions/73/how-can-i-make-it-easier-for-users-to-generate-the-reports-they-need
Comments.UserDisplayName: William Mortada
Tags: <relationships><reports>
Title: Custom Report By Relationship
ThreadText: # Custom Report By Relationship
  
  (Asked by: username_0 on 2016-09-12)
  
  Can you point me to resources that can cover this requirements, I'm sure it would be needed often, and whilst I can dive into working it out from first principals, as a newbie, it would be nice to get thr benefit of some starting points.
  
  Scenario is multiple households are 'managed' by an individual rep.
  
  I would like to produce a reported, grouped / broken by rep of all their households.
  
  Effectively a 'responsibility list' they can use to 'tick off' their annual visit to households.
  
  So I have set up reps as type of 'individual'
  
  and set up an A-B relationship between rep and household.
  
  The standard 'contact relationship' goes part way there, but for instance doesn't have address.
  
  I can see a 'developer tab' so I am assuming I can tweak the SQL - but before I start hacking around I though I'd ask the best way to approach this.
  
  Thanks
  
  p.s.
  
  I found this <https://wiki.civicrm.org/confluence/display/CRMDOC/CiviReport+Reference>
  the implication to me is to write a custom php report? Is that the right approach?
  
  Seems pretty heavy weight to get the desired results - but blogs lik ethis seem to indicate it is the way to go
  
  <https://alastaira.wordpress.com/2011/03/17/civicrm-creating-a-custom-report/>
  
  **Tags:** relationships, reports
  
  > **Comments:**
  > **username_1**: Thanks for your post.  Please indicate which version of CiviCRM you are using and which CMS you are using (e.g. Drupal, WordPress or Joomla).  The answers will vary depending on your CMS.  
  > **username_1**: You may find the answers to this related question helpful: http://civicrm.stackexchange.com/questions/73/how-can-i-make-it-easier-for-users-to-generate-the-reports-they-need  
  
  ---
  
  ## 3 answers
  
  ### Answer by username_2 on 2016-09-15. Score: 1
  
  This *could* be a place where it's just easier for the users to use an advanced search to bring up a list of households related to their own contact record. It's definitely possible that this puts too much onus on the user for your use-case, but it really only adds a couple of clicks over pulling up a report:
  
  `Advanced Search>Relationships tab
  Relationship Type = your relationship from org to individual
  Target Contact = the reps name`
  
  This would bring up the list of households the rep has a relationship for them. There are many ways to proceed in how they may 'tick off' these households for the year depending on the org process.
  
  If that's too much for this set of users than your "p.s." is probably on the right track and writing a custom report is the way to go here. I would not create an entire extension for this.
  
  If you're just adding results columns, it's usually pretty painless - the documentation is just kind of all over the place. The new .tpl file is a one-liner explained in Alastair's blog post. You can copy the base report (contact relationships in this case) .php file that is closest to what you want and then copy/paste the address block columns from a different report base that has them included.
  
  I would like to add two resources to your links above that I found helpful to put it all together when learning custom report writing for myself:
  
  <https://artfulrobot.uk/civicrm-custom-birthdays-report>
  
  <https://sf2012.civicrm.org/sites/default/files/slides/CiviCRM%20Reports-Customize%20and%20Extend.pdf>
  
  
  ---
  
  ### Answer by username_3 on 2016-09-12. Score: 0
  
  Are you on Drupal? If so, you could do that with Views.
  
  > **Comments:**
  > **username_1**: Thanks for your post.  It would be helpful for others if you could expand your answer with some more detail.  
  > **username_0**: I'm on WordPress  
  
  ---
  
  ### Answer by username_3 on 2016-09-15. Score: 0
  
  Since you're on WordPress, Views won't help.
  
  You could check the published extensions and see if any of those do what you need: go to <https://civicrm.org/extensions> and search for 'report'. Two that might be of interest are: <https://civicrm.org/extensions/extended-reports> and <https://civicrm.org/extensions/relationship-overview-report>
  
  If none of those fit and you want to develop your own, create an extension (<https://wiki.civicrm.org/confluence/display/CRMDOC/Create+a+Module+Extension#CreateaModuleExtension-Generateaskeletalextension>) and add a report (<https://wiki.civicrm.org/confluence/display/CRMDOC/Create+a+Module+Extension#CreateaModuleExtension-Addareport>)
  Note that you can copy an existing report to modify.
  
  > **Comments:**
  > **username_0**: I have found that There is an extended reports extension - that actually covers my initial use case of address columns.  But my requirement goes further and I'm pretty certain I will have to custom code.  I will post a related 'help' question relating to getting some pointers mainly on the SQL.  
  
  ---
  
  