There is no way to produce a report in which all censuses are listed in dwelling number order if you have not entered that dwelling number as the first entry in a field that you include in your report. I think there are two logical fields for this data, the Place Detail and the Memo. I've used both; but using the Place Detail field will result in a very long Master Place List, as each dwelling number/family number entered there becomes a new place. Therefore, I use the Memo field for this information.

Regardless of the field you choose,
• enclose the dwelling number (and family number) in sensitivity brackets. For most reports, you won't want this information printed.
• Don't forget that the number 2 is sorted after the number 11 by the computer, so enter all numbers with at least three digits: 001, 052, 112, etc., if you want them sorted correctly.
• Examine the Memo in the Census Tag Entry screen on the left to see how this information is entered.

• This report refers to many people who are linked by an event: a specific census enumeration. Although it might seem like this should be a List of People report, our interest is in the census event. List of People reports do not give an option to print a census tag. Individual Narrative and Detail reports allow only limited sorting options. When you wish a report which is sorted by Event information, the best option is a List of Events report.
• We need a Filtered Group: all households in a given census year in a specified geographic area. Select Filtered Group and add a new Report Filter definition.
• Output will be to screen for this "quick and dirty" report.

• I have two census event tags, CENSUS and CENS-STAT, so the Tag Label for my filter begins with CENS.
• A census list by dwelling order refers to only one census enumeration, so I specify the census event year. I don't enter a specific year but use the [?]. Each time I run this report, I can specify a different year.
• I always include the state, as county and town names are duplicated in many states. [This is why I don't use the Place field for this report.]
• This filter is used for a county-wide listing. If I wanted only a city-wide listing, I would add a line to specify the city. Operator is contains as that allows for entry variations, such as Co., Twp., Boro, etc.

• Give the report a title if you wish.

• The output columns tab allows you to specify what columns you want printed, in what order, and in what order the entire report is sorted.
• There are three columns specified on this screen: Principle (last name first), City, Memo, printed in that order.
• The output is sorted first by city and second by memo. In other words, all residents of a town are grouped together first, then listed by memo order within the city.
• Consider adding Year to the list of columns. Note that you can enter the number of witnesses, but you cannot add a column that gives the names of witnesses.

• The Miscellaneous Tab allows me to Show excluded data, i.e. the sentences I've excluded; and to Show sensitive data, i.e. information that has been surrounded by sensitivity brackets { } to keep it from printing in reports. At the moment, these options don't seem to affect List of Events reports. That's not true for any narrative reports, however, so I check the appropriate boxes for all reports.

This is the resulting screen report.

• There is only one major difference between the spreadsheet report and the screen report: the designated output site. In this case, send the report to a file and specify an Excel format.
• In addition, consider expanding the memo field width to as much as 250 to 300 characters.

This is the resulting Excel report. Although the original file was sorted in dwelling number order, this has been resorted by surname. As well as being more flexible, the Excel report allows more of the census memo to be visible, if the user desires.