RE: Creating report from room layout shapes



{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fprq2\fcharset0 MS Sans Serif;}}
\viewkind4\uc1\pard\f0\fs20 I don't think this is possible within the current design of the reporting tool in Visio 2007. Within the subtotals section of the report wizard you can specify grand totals however it will not perform a tally on the quantity column for the report.
\par
\par James W.
\par
\par \pard\li720 --------------------
\par Thread-Topic: Creating report from room layout shapes
\par thread-index: AcmsnX/VRhcIo/V+Sk+sdkdm8tIPlg==
\par X-WBNR-Posting-Host: 207.46.193.207
\par From: =?Utf-8?B?cHdn?= <pwgnc@xxxxxxxxxxxxxxxxxxxxxxxxx>
\par Subject: Creating report from room layout shapes
\par Date: Tue, 24 Mar 2009 09:28:01 -0700
\par Lines: 21
\par Message-ID: <46AEAA8C-58B6-42D5-8280-12E595F69448@xxxxxxxxxxxxx>
\par MIME-Version: 1.0
\par Content-Type: text/plain;
\par \tab charset="Utf-8"
\par Content-Transfer-Encoding: 7bit
\par X-Newsreader: Microsoft CDO for Windows 2000
\par Content-Class: urn:content-classes:message
\par Importance: normal
\par Priority: normal
\par X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.3168
\par Newsgroups: microsoft.public.visio.general
\par Path: TK2MSFTNGHUB02.phx.gbl
\par Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.visio.general:11965
\par NNTP-Posting-Host: tk2msftsbfm01.phx.gbl 10.40.244.148
\par X-Tomcat-NG: microsoft.public.visio.general
\par
\par I have a room layout for an event. There are multiple size tables such as 6
\par ft and 8 ft. I want a report to tell me the total number of 6 fts or 8 fts in
\par room, whether they need electricity, and size linen for table.
\par
\par For each shape I have created data fields:
\par Electricity: (fill with yes/no)
\par Linen size: (fill with size such as 8 ft)
\par Table size: (fill with size such as 6 ft)
\par
\par I have tried multiple ways of creating a custom report and can't get it to say
\par 6 ft tables: 10
\par 8 ft tables: 20
\par Electricity yes: 12
\par Electricity no: 15
\par ...and so on...
\par
\par The closest I got was having the column heading TABLE SIZE then a list of
\par all the tables under it, but there was no total.
\par
\par Either I have created incorrect data fields and entries or I don't know how
\par to do the report. Thanks for any help.
\par \pard
\par
\par }