Reports

The Reports tab opens a series of pre-formatted reports that are generated by WYSIWYG, containing all data entered in CAD and DATA modes. These reports are available for you to use as is, or to modify to suit your needs. Unlike the spreadsheets in DATA mode, you cannot edit fixture data here. Reports are designed to be printed documents. You can, however, modify their setup and layout.

Notes:

• The “Rigging Points by Position” report on the Truss Rigging Point symbols will be replaced automatically when a file is loaded or merged. The new version will report on drawn Rigging Point objects.
• The “Rigging Points List” report (which does not group Rigging Points by the Position column) will be added automatically if it does not already exist in the file.

Working with reports

To modify a report

1. In the Reports tab, right-click and select View Options.

Result: The View Options window appears.

Tip: You can use the View Options tool on the Standard toolbar.

  The View Options button.

2. Modify the Scene options as desired.
3. Select the fixture categories from the Exclude the following Fixture Categories list in the Fixture Exclusions from this Report section, to remove from the report all fixtures under the categories.
4. Select the individual fixture types from the Exclude the following Fixture Types list in the Fixture Exclusions from this Report section, to remove from the report.
5. Select the accessory types from the Exclude the following Accessory Types list in the Fixture Exclusions from this Report section, to remove from the report all accessories that was added to the fixtures.
6. Select the Zebra Striping checkbox to display rows in alternating colors.
7. Select the Show Headers checkbox to       display the labels for the rows and columns.
8. Select the Frozen Pane checkbox to lock the top cells of your report.
9. Click OK.

General tab

Options on the General tab affect the scene that is displayed in the report.

• Follow Current Scene: Select this checkbox to filter the report according to the current scene. The current scene is displayed on the drop-down list on the Scene toolbar and in the Scene Database dialog box (from the Managers menu, choose Scenes).

To filter your show information based on the scene selected, clear the checkbox, and then select the desired scene from the Scene drop-down list. Only fixtures on the active layers (or layers in the scene) are displayed in the report.

Tip: You can change the current scene at any time by using either the Scene toolbar or the Scene Database dialog box. For more information on scenes, see Scenes.

Report tab

Options on the Report tab affect the appearance of the report.

• Report Defaults: Click this button to open the Report Defaults window.
• Report Type: Indicates the type of report. Can be either one of Fixtures or Truss. The Report Type determines the available options under Report Detail and the columns available for use in the report.
• Report Detail: Changing the detail level will change how the row information is displayed in your report.

Example 1: Given a Three Cell Cyc light, the Fixtures detail level will only give you one row of data: Three Cell Cyc. If you switch the detail level to Circuits, then you will get three rows of Three Cell Cyc, one for each circuit.

Example 2: Given a Source 4 with a Scroller attachment, a report with the Fixtures detail level will simply display “Source 4”. The same report with the Fixtures and Accessories detail level will display one row for Source 4 and one row for the scroller attachment.

• Group By: Select a data field for grouping data. These groups will appear as separate tabs at the bottom of a report. In the case of an Instrument Schedule, fixtures are grouped by hanging position. Each position appears on a separate page.

Columns

Each row in the Columns table represents a column that can be displayed in the Report. To enable a header, select the checkbox on the row of the relevant data column.

• Columns – Group Total: This checkbox appears only when Group By is not set to None. When selected, WYSIWYG generates the sum-total of the data column underneath the last cell in that column.
• Columns – Report Total: When Group By is set to None, Group Total will generate a sum-total of the data column underneath the last cell in that column; otherwise, a new Totals tab will be created, listing the sum-total of the data for that column across all groups.
• Columns – Word Wrap: When selected, the text in that column will use word wrap to try to fit all the text in the cell.
• Up/Down: These controls let you re-order the way columns appear in your report. First, select a row in the Columns table, and re-arrange it using Up/Down buttons.
• Move selected columns to top: When selected, all visible columns will be shifted to the top of the Columns table.
• Merge duplicate rows: When selected, all rows with duplicate Type names will be grouped into one row. For example, a report that has a Three Cell Cyc with Circuits Report Detail will show three individual rows, one for each circuit in the Three cell Cyc. With merge duplicate rows enabled, the three circuits will be combined into one row.
• Combine group sheets: When selected, multiple reports will be combined to be on the same sheet. When a Report is grouped by a column, this option is enabled. When selected, the separate Report sheets will be displayed on one Report tab. This option may be helpful if you wish to display the grouped Reports on a Layout with in one Report object.
• Show totals of merged duplicates: This option is enabled only when Merge duplicate rows is enabled. After merging duplicate lines, this gives you the option to show the quantity of a single item, or the sum total of all the merged items. For example, if a Three Cell Cyc with Circuits Report Detail is merged, you can show the Wattage of an individual circuit (Show totals of merged duplicates OFF) or the total Wattage of all three circuits (Show totals of merged duplicates ON).
• List Accessories under their Fixture: This option is available if Fixtures and Accessories is selected from the Report Detail drop-down list. Select this checkbox to add the list of accessories attached to the fixture below the fixture.
• Identify Accessories: This option is available if the List Accessories under their Fixture checkbox is enabled which will add a symbol to identify the accessories on the list. Select this checkbox and click on the symbol from the drop-down list.

Sort By

Contains the settings for how the report will be sorted. The keys sort fixtures in alphabetical or numeric order. When fixtures have the same value in the first sort key, the report is then sorted by the values of the second sort key, and so on for the third sort key. For example, the standard Instrument Schedule sorts fixtures by position as Key 1, and unit number as Key 2. When a column is selected as a key, the visible option will be checked and greyed out. Columns that are sort keys must be visible.

Filter By

Contains settings for the column that you selected from the Columns list. You can use filters to extract specific information from reports. A total of three filters can be applied to any given report. For example, you can create a report that displays all the fixtures that have notes. To do so, select the Notes column and the Visible checkbox, and then select the filter Not Empty. You will also have to make Position, Unit, and Channel visible so that you know which fixtures have these notes.

To create a new report

1. Click the Reports shortcut tab.
2. Right-click in the reports shortcut area, and then choose New Report.
3. Type the name of your new report.
4. Select the Report Type (Fixtures, Truss, etc.).
5. Select an existing report from which you would like to copy the columns, formatting, filters, etc.
6. Click OK.

Sharing reports

You can save a Report to the application level, and then you can export or import this Report to and from other files.

To share a report

1. In the Reports tab, from the REPORT menu, choose Add Default Report.

Result: The Add Default Report dialog box appears.

2. Type the name of your default report.
3. Select the Default Report from the Select Default Report drop-down list.
4. Click OK.

Result: The Default Report that you added is included in the list of Reports that can be exported and the list of Report Templates that can be imported from the File menu.

Redesigning headings

You can customize the fonts, styles, and layouts used in the headings and text of your reports. These settings can be applied to the headings of all reports in your document as desired.

To change the heading format

Report headings can be directly modified on the current report. You may add, remove, and change the formatting of cells within the report with a limited degree of freedom. For more information about the functionality of the spreadsheet, see Worksheets.

To apply the current formatting to other reports

Once the editing has been completed, you can apply the look and feel of your current report by completing the following steps:

1. Select Report > Apply Current Report Template.
2. In the new dialog box, select the reports to which you want to apply the current format.
3. Click OK.

To merge cells

1. Select cells you wish to merge together.
2. Right-click and select Merge > Merge Cells.

Result: The cells merge and any text will span the merged cell.

To unmerge cells

1. Select cell you wish to separate.
2. Right-click and select Merge > Unmerge Cells.

Result: The merged cells unmerge.

Report templates

You can customize the formatting used in the headings of your reports and apply the customized headings to all the reports in your document.

You can save the modified reports with the customized headings by exporting the file as Report Templates. Consequently, you can import the Report Templates into WYSIWYG and apply the customized headings to selected reports in your document.

To export report formatting

You can save the current report with customized heading format to a file, as follows:

1. From the File menu, choose Export > Report Template.

Result: The Export window appears.

2. In the Export window, type the name of your Report Template file.
3. Select the file format that you would like to export to.
4. Click Save.

Note: For optimal compatibility with other WYG files, it is recommended that you export to the WYSIWYG Spreadsheet format (*.wss).

To import report formatting

You can import and apply the customized report heading format into WYSIWYG as follows:

1. From the File menu, choose Import Report Template.

Result: The Choose which Reports to import into window appears.

2. On the Choose which Reports to import into window, select the Report(s) where the customized heading format will be applied to.

Tips:

• You may click Select All if you want to apply the customized heading format to all the reports in WYSIWYG.
• You may click Select None if you choose not to apply to any report.
• You may click Sort Alphabetically to display the list of reports in alphabetical order.

3. Click OK.

Result: The Import window appears.

4. In the Import window, select the exported Report Template file you wish to apply to the selected report document(s) in WYSIWYG.
5. Click Open.

Result: The customized heading format of the imported Report Template is applied to the selected report document(s).

Column widths

You can change the column widths in the report. A double-headed arrow appears when you float the cursor between the column separations at the top of the report. Double-click the column headings to have the column resize to fit (auto-fit) the contents.

Formatting data section in reports

Reports data cells in WYSIWYG can be formated in many different ways to suit your needs. Each column in a report can be individually formated, and every row that appears under that column will have the same formatting e.g. text alignment, font style, font color, font size, font style, background color. Reports can also be edited to have zebra stripes or have borders around columns.

To format a report column

1. Select a cell in the column you want to format. If you select a cell in a column, the entire column should be selected.

Note: Clicking the first cell of the first column, called the smart cell, will select every cell.

2. From the Reports menu, choose Format Cell.

Result: The Format Cells window appears.

3. In the Format Cells window, edit the cells how you want.
4. When finished editing, click OK.

Note: Alternatively, you can use the New Plot Text toolbar for editing the cells.

Zebra striping

Zebra striping is a feature in reports where ever other data row will be highlighted in a report.

To add zebra striping to a report

Note: Formatting a cell will override zebra stripping.

From the Reports menu, choose Zebra Striping.

Tip: You can also select the Zebra Striping checkbox in General tab of the View Options window in the Reports tab.

Combining report

It is possible to display the reports of multiple sheets of a group into a single report. This combined report will fit on a single page.

To combine reports

1. Right-click in a report and select View Options.

Result: The View Options window appears.

2. In the View Options window, in the Report tab, in the Columns section, enable Combine group sheets.
3. Click OK.

Result: The multiple pages of the group report will be merged and be displayed on a single page.

Using formulas in spreadsheets

Over 100 formulas for common mathematical and logic functions are supported in WYSIWYG (you must manually enter the formula as text in a cell). Examples of formula include the following:

ABS: determines the absolute value of the specified value, cell or expression.

Syntax: ABS(value)

Syntax: ABS(expression)

Example: =ABS(-4) gives output 4

Example: =ABS(B4) alternatively, reference cells within your sheet

AVERAGE: finds the averages of a list of values.

Syntax: AVERAGE(value1, value2,...)

Syntax: AVERAGE(array1, array2, ...)

Example: =AVERAGE(1,2,3,4,5) gives output 3

Example: =AVERAGE(A1:A10) alternatively, reference cells in your sheet

CEILING: rounds a number up to the nearest multiple of the specified value.

Syntax: CEILING (value, rounding multiple)

Example: =CEILING(2.3, 1) rounds to the closest whole number in the negative range, gives output 3

FLOOR: rounds a number down to the nearest multiple of the specified value.

Syntax: FLOOR (value, rounding multiple)

Example: =FLOOR(2.3, 1) rounds to the closest whole number in the positive range, gives output 2

MAX: returns the maximum value from a given list of values.

Syntax: MAX(value1, value2,...)

Syntax: MAX(array1, array2,...)

Example: =MAX(1,2,3,4,5) gives 5

Example: =MAX(A1:A5, B2:B21) allows you to find the maximum value from multiple ranges

MEDIAN: returns the median, or the number in the middle of the provided set of numbers.

Syntax: MEDIAN(value1, value2,...)

Syntax: MEDIAN(array1, array2,...)

Example: =MAX(1,2,3,4,5) gives 3

Example: =MAX(A1:A5, B2:B21) allows you to find the median value from multiple ranges

MIN: returns the minimum value from a given list of values.

Syntax: MIN(value1, value2,...)

Syntax: MIN(array1, array2,...)

Example: =MIN(1,2,3,4,5) gives 1

Example: =MIN(A1:A5, B2:B21) allows you to find the minimum value from multiple ranges

SUM: returns the sum of cells or range of cells.

Syntax: SUM(value1, value2,...)

Syntax: SUM(array1, array2,...)

Example: =SUM(1,2,3,4,5) gives output 15

Example: =SUM(A1:15) allows you to sum over a range of cells