Building Permits

Archived Content

Information identified as archived is provided for reference, research or recordkeeping purposes. It is not subject to the Government of Canada Web Standards and has not been altered or updated since it was archived. Please "contact us" to request a format other than those available.

64-001-XIE

Building Permits

December 2001

Our unique table viewer picks up where your Web browser leaves off. Using Statistics Canada's own table viewer, you can:

isolate specific rows and columns
export your data to a spreadsheet
use print options to customise printing

Obtain Statistics Canada's table viewer free of charge. Get it NOW!

How do I isolate specific rows and columns?

Click on the "Table" menu

Select "Rows" (or "Columns")

Double click on the plus sign to expand or double click on the minus sign to minimise the hierarchy

You can deselect an item by clicking on the check mark or you can select an item by clicking on the circle, selected items will appear in the table view

When selecting rows, the "Check children" option controls the behaviour of the select/deselect action. When "Check children" is enabled (default), selecting an item will also select every item contained within the item being selected (the same is true for deselecting). This gives us a handy way of deselecting everything by deselecting the top most item. Then, only items of interest can be selected for viewing.

To display the table in its original form (i.e. all columns and rows are selected), choose "Reset" from the "Table" menu

Note: a check mark beside an item means the item has been selected and a circle beside an item means the item has been deselected.

How do I export data to a spreadsheet?

Click on the "File" menu

Select "Export"

Indicate the location you would like to save in

Give your file a name

Choose a file format for exporting from the drop down menu titled "Save as type"

The export function provides an option to convert the tables into different file formats. The file formats supported by the export function are:

File Format	Comments
HTML	Converts tables into HTML format, which can be viewed by Internet browsers. Note: When converting into HTML format, the full table will be exported. The export will not be affected by any customisations.
Excel	Converts tables into Excel version 4.0 or 5.0 Note: If you customised your table using the columns and rows functions, the export function will extract only the data found in your customised table view.
Tabbed-Text (Values only)	Converts tables into a tabbed-text format. Note: If you customised your table using the columns and rows function, the export function will extract only the data found in your customised table view.

How do I use print options to customise printing?

From the "File" menu, select "Page Setup..."

Create custom headers and footers	In the Header and/or Footers box enter your text. Note: you can only have one custom header and one custom footer on a table. If you create a custom header or footer, it will replace any existing header or footer on the table.
Set page margins	In the Top, Bottom, Left and Right boxes, enter the desired margin size Note: the measuring units for the page margins can be set to inches or centimetres
Grid Line	By default the grid lines option is always on and cannot be changed.
Black and White	By default the black and white option is always on and cannot be changed.
Row Heading	Prints the row headings on the left side of the table
Column Heading	Prints the column heading at the top of the table.
Scale	Enter the percentage by which you want to reduce or enlarge the table, or you can tick the "Fit to page(s)" box to fit the table to the page. You can use the "Pages Wide" and "Pages High" to span the table across one or more pages.