Daryl Edmonds 0 Report post Posted June 28, 2007 (edited) Hi all, When I run a "List of Places" report I expected to get an alphabetical list of the towns/cities that I have entered into the "City" box in my project. However, instead I get a list of the items I've put in the "Detail" box, in alphabetical order, (such as Pandurra Station, on board "Fairlie", New Church, etc)., followed by the town/city for the event. I would like to be able to create an alphabetical list of the towns and cities in my project but can't find any way of getting what I want. Can someone please make a suggestion on how to achieve my goal! I'm using the UK edition and the columns in the report are: Details---Village/Area---Town/City---County/Region---Country. However, the report comes out with: Details column=correct, Village/Area column lists the towns, Town/City lists the UK County, County/Region lists Australian states (I'm in Australia), Country=correct. I've noticed in other reports that I've run that I have to filter using Village/Area rather than Town/City to find which people have been connected to various places over their lifetime, so perhaps it's a foible of the UK edition? Looking forward to a solution, hope that's clearer than mud! Cheers, Daryl Edited June 28, 2007 by daryl edmonds Share this post Link to post Share on other sites
RGC 0 Report post Posted June 28, 2007 Hi all, When I run a "List of Places" report I expected to get an alphabetical list of the towns/cities that I have entered into the "City" box in my project. However, instead I get a list of the items I've put in the "Detail" box, in alphabetical order, (such as Pandurra Station, on board "Fairlie", New Church, etc)., followed by the town/city for the event. I would like to be able to create an alphabetical list of the towns and cities in my project but can't find any way of getting what I want. Can someone please make a suggestion on how to achieve my goal! I'm using the UK edition and the columns in the report are: Details---Village/Area---Town/City---County/Region---Country. However, the report comes out with: Details column=correct, Village/Area column lists the towns, Town/City lists the UK County, County/Region lists Australian states (I'm in Australia), Country=correct. I've noticed in other reports that I've run that I have to filter using Village/Area rather than Town/City to find which people have been connected to various places over their lifetime, so perhaps it's a foible of the UK edition? Looking forward to a solution, hope that's clearer than mud! Cheers, Daryl In the report definition screen, select options and then the output columns tab. Share this post Link to post Share on other sites
Daryl Edmonds 0 Report post Posted June 28, 2007 In the report definition screen, select options and then the output columns tab. Thanks, RGB, That worked, but I would still like the option to turn on/off columns that I want or not. Daryl Share this post Link to post Share on other sites
Jim Byram 0 Report post Posted June 28, 2007 Thanks, RGB, That worked, but I would still like the option to turn on/off columns that I want or not.Daryl Which you can do. The Output Columns tab has many options. 1) Use the right-click menu to add or delete columns. 2) Use the down arrow to open the list to change a column type. 3) You are correct that the place levels use the U.S. edition names but you can use the place levels directly (Place L1, Place L2, etc.). 4) Modify the width and heading label for each column. 5) Use the sort field for each column (on the left) to control the sort order. (Be sure not to use the same sort value on two columns.) The output columns are completely customizable as you wish. Wouldn't hurt to use the [Help] button. Share this post Link to post Share on other sites
Daryl Edmonds 0 Report post Posted June 30, 2007 Which you can do. The Output Columns tab has many options. 1) Use the right-click menu to add or delete columns. 2) Use the down arrow to open the list to change a column type. 3) You are correct that the place levels use the U.S. edition names but you can use the place levels directly (Place L1, Place L2, etc.). 4) Modify the width and heading label for each column. 5) Use the sort field for each column (on the left) to control the sort order. (Be sure not to use the same sort value on two columns.) The output columns are completely customizable as you wish. Wouldn't hurt to use the [Help] button. Thanks Jim, I have these "seniors" moments when I forget there's a right click an the mouse!! Share this post Link to post Share on other sites