Answers.Body: <p>In Drupal Views you can </p>
  
  <ul>
  <li><p>build reports with exposed filters, with cols in any order you want, with links to exploded reports and lots more.</p></li>
  <li><p>use Contextual Filters or standard filters to ensure the user only sees information pertinent to them</p></li>
  <li><p>Civi Relationships (and Views Relationships) to expose to the user other records in civi they should be able to access.</p></li>
  </ul>
  
  <p>To get started</p>
  
  <ul>
  <li>if your Drupal db is separate to civi DB then add the prefix required for the civi tables in to your settings.php</li>
  <li>add a view based on CiviCRM Contacts</li>
  <li>add some fields, filters etc and familiarise yourself with Views capabilities</li>
  </ul>
  
  <p>If the above is too hard</p>
  
  <ul>
  <li>check some of the excellent videos tutorials around on using Views</li>
  <li>reach out to one of the Partners such as Fuzion to at least get you started without too much banging of heads again solid or other types of objects.</li>
  </ul>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-06-25T01:53:47.317Z
Answers.LastActivityDate: 2017-06-25T01:53:47.317Z
Answers.UserDisplayName: petednz - fuzion
Answers.Body: <p>You can also try out some of the extensions that have been built by users and Partners and clients such as the one Fuzion built called <a href="https://github.com/eileenmcnaughton/nz.co.fuzion.extendedreport" rel="nofollow noreferrer">Extended Report</a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-06-25T01:56:48.340Z
Answers.LastActivityDate: 2017-06-25T01:56:48.340Z
Answers.UserDisplayName: petednz - fuzion
Body: <p>So a few things, when I create a custom report display, by adding additional fields to display. Is there anyway to re-order the fields. so for example if I want lastname, then first name...or other changes?</p>
  
  <p>secondly, is there a way to extend the reporting so i can have reports built? I would like to be able to add an "Action" under the action menu and be able to take the results of the query and send it to a new report?</p>
  
  <p>third, is there a way to bulid a different set of filters for example, what if i want to have the person be able to select a date range or to be able to select a date before, or date after...but the user could decide.</p>
  
  <p>I want to keep everything within Civi framework and not have the user have to go out to a third party app</p>
  
  <p>thanks,
  Mark</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-06-24T22:50:41.097Z
Comments.Text: I was going to say 'if you are using Drupal then Views may be an easier methodology for doing the above', but your last para put me off saying this (briefly)
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-06-25T00:59:15.197Z
Comments.Text: ok, I am using Drupal, how do you use Views to accomplish some of this. I would prefer to say in Civi, but this could be used for now. I am surprised that no one has built a nice extension for reporting withing the framework. The current reporting is so limited.
Comments.UserDisplayName: Mark
Tags: <civireport><custom-reports>
Title: Reporting options
ThreadText: # Reporting options
  
  (Asked by: username_0 on 2017-06-24)
  
  So a few things, when I create a custom report display, by adding additional fields to display. Is there anyway to re-order the fields. so for example if I want lastname, then first name...or other changes?
  
  secondly, is there a way to extend the reporting so i can have reports built? I would like to be able to add an "Action" under the action menu and be able to take the results of the query and send it to a new report?
  
  third, is there a way to bulid a different set of filters for example, what if i want to have the person be able to select a date range or to be able to select a date before, or date after...but the user could decide.
  
  I want to keep everything within Civi framework and not have the user have to go out to a third party app
  
  thanks,
  username_0
  
  **Tags:** civireport, custom-reports
  
  > **Comments:**
  > **username_1**: I was going to say 'if you are using Drupal then Views may be an easier methodology for doing the above', but your last para put me off saying this (briefly)  
  > **username_0**: ok, I am using Drupal, how do you use Views to accomplish some of this. I would prefer to say in Civi, but this could be used for now. I am surprised that no one has built a nice extension for reporting withing the framework. The current reporting is so limited.  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2017-06-25. Score: 2
  
  In Drupal Views you can
  
  * build reports with exposed filters, with cols in any order you want, with links to exploded reports and lots more.
  * use Contextual Filters or standard filters to ensure the user only sees information pertinent to them
  * Civi Relationships (and Views Relationships) to expose to the user other records in civi they should be able to access.
  
  To get started
  
  * if your Drupal db is separate to civi DB then add the prefix required for the civi tables in to your settings.php
  * add a view based on CiviCRM Contacts
  * add some fields, filters etc and familiarise yourself with Views capabilities
  
  If the above is too hard
  
  * check some of the excellent videos tutorials around on using Views
  * reach out to one of the Partners such as Fuzion to at least get you started without too much banging of heads again solid or other types of objects.
  
  
  ---
  
  ### Answer by username_1 on 2017-06-25. Score: 0
  
  You can also try out some of the extensions that have been built by users and Partners and clients such as the one Fuzion built called [Extended Report](https://github.com/eileenmcnaughton/nz.co.fuzion.extendedreport)
  
  
  ---
  
  