Body: <p>I have a report that I would like sorted by County but that field doesn't appear as a sortable column, although it does appear on the report. This field is in fact 'State/Province' but is renamed via word replacement to 'County' (I am in the UK).  There are other fields that appear as sortable that are surprising because their usefulness is very dubious (like Notes) but County doesn't appear.  Is there some way to make this field appear?  </p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-08-09T15:44:03.773Z
Comments.Text: Could you elaborate on which report you are running with perhaps a screen shot?
Comments.UserDisplayName: peterb
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-08-09T18:49:00.437Z
Comments.Text: It's based on the template of 'Constituent Report (Summary)' - I can't post a copy as it has confidential info.  But you've prompted an idea to instead base the report on ''Constituent Report (Detail)' which does allow sorting on State/Province.  I'll let you know as this is probably the answer
Comments.UserDisplayName: Andy Clark
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-08-10T16:17:52.353Z
Comments.Text: Basing the report on the 'Detail' template solved the problem but introduced a new one (isn't that usually the case!) because now the formatting is poor. One of the fields is a note, which was handled OK before but is now all squashed up. But odd that in the detailed template I can sort and group by state/province but not in the summary template.
Comments.UserDisplayName: Andy Clark
Tags: <civireport><reports><4.6><sort-order>
Title: How to add a sorting column in Reports
ThreadText: # How to add a sorting column in Reports
  
  (Asked by: username_0 on 2017-08-09)
  
  I have a report that I would like sorted by County but that field doesn't appear as a sortable column, although it does appear on the report. This field is in fact 'State/Province' but is renamed via word replacement to 'County' (I am in the UK). There are other fields that appear as sortable that are surprising because their usefulness is very dubious (like Notes) but County doesn't appear. Is there some way to make this field appear?
  
  **Tags:** civireport, reports, 4.6, sort-order
  
  > **Comments:**
  > **username_1**: Could you elaborate on which report you are running with perhaps a screen shot?  
  > **username_0**: It's based on the template of 'Constituent Report (Summary)' - I can't post a copy as it has confidential info.  But you've prompted an idea to instead base the report on ''Constituent Report (Detail)' which does allow sorting on State/Province.  I'll let you know as this is probably the answer  
  > **username_0**: Basing the report on the 'Detail' template solved the problem but introduced a new one (isn't that usually the case!) because now the formatting is poor. One of the fields is a note, which was handled OK before but is now all squashed up. But odd that in the detailed template I can sort and group by state/province but not in the summary template.  
  
  ---
  
  ## 0 answers
  
  