Creating Space and Asset Reports

Although Visio 2007 includes many types of built-in reports, the Space Plan template includes two special reporting shapes. When you drag the Space Report or Asset Report shape from the Resources stencil, Visio 2007 reads the shape data in the space plan and automatically generates a table that summarizes the information.

A space report provides subtotals and totals of the square footage in your floor plan based on the size of the space shapes, as Figure 26-27 shows. The report calculates the area by department and then adds the areas together. For each space shape in your floor plan, the report lists the space name, department, use, and area. If you haven’t entered or imported data for the space shapes’ shape data, these fields will be blank in the report.

An asset report lists all the fixed assets in each space of your floor plan: computers, equipment, fixtures, furniture, and other assets represented by asset shapes. For each asset, the report displays the values of the category, name, and manufacturer shape data, as Figure 26-28 shows. As with the space report, this report displays a blank cell for any shape data that don’t have a value.

Among other things, the reports are a great way to double-check your data entry. If a shape data item doesn’t have a value, the report will show a blank cell. If the cell should contain a value, you can select the space shape associated with the blank data, display the Shape Data window, and then type the information. If you imported the property values from an external data source, the report tells you that your database or spreadsheet is missing some information.

Editing Space and Asset Reports

You can edit the report—they’re simply Visio 2007 table shapes. Right-click a cell in the table to display a shortcut menu with options for editing the table. You can also change the contents by editing the report definition that Visio 2007 uses to generate the space and asset reports. For example, if you want an asset report to include Asset Number rather than Category, you can edit the definition of the asset report to include the shape data you want. The report shapes on the Resources stencil are only shortcuts for using the Report command in Visio 2007. Rather than drag a shape onto the page, you can generate the same report as follows:

• Create a space report Choose Data, Reports. In the Report column, choose Space Report. You can then run the report or click Modify to edit the report definition and change the properties that appear.

• Create an asset report Choose Data, Reports. In the Report column, choose Asset Report, and then select the options you want.

Creating Reports in Different Formats

If you want to output a space or asset report as a separate file rather than as a table shape in your drawing, you can use the Report tool. You can still opt to create the report as a Visio 2007 shape, and it will appear on the page just as it would if you dragged the Space Report shape to the page. However, you can also choose to output the report to HTML, Excel, or XML format.

Follow these steps to output your report as a separate file:

1.	Choose Data, Reports.
2.	In the Report column, choose Asset Report or Space Report, and then click Run.
3.	In the Run Report dialog box, select the output format you want, and then click OK.