Run|Tables

Run|Tables lets you combine banners and tables, check syntax, set some report options and run tables. You must open your data file before you can run tables using File|Open|Open Data, however, there are options to run tables without data so that you can check the table layout and run a syntax check on your logic.

You can run tables even if you have not created banners. You can also run tables without selecting a banner when banners do exist. A default banner with a single total column automatically runs against the tables.

You can double-click on a single table in the tables list to run a quick report. If a single banner is selected for that table, the table will be processed with that banner. If multiple banners have been selected for that table, the table will be processed with those banners. If no banner was selected, the table will be processed with a single total column.

Saved banner/table selections:

When your job file is saved, the last banner/table selections processed are also saved in an editable jobname.run file that is written to the same folder where your job file resides.
The next time you open that job file or select Run|Tables in the same WinCross session, the banner/table selections will be preselected for you and the name of the jobname.run file will be displayed in the Saved banner/table selections: field.
You can save the banner/table selections to a file name of your choice by selecting the Save As option to the left of the Saved banner/table selections: dropdown list.
All *.run files that reside in the same folder as the WinCross job file (*.job) are available to use from the dropdown list of Saved banner/table selections:.
You can also browse to another folder where a *.run file resides using the Browse option to the left of the Saved banner/table selections: dropdown list.
Most recent Run Tables selection is the last set of banner/table selections processed that differs from jobname.run.

Select banners:

Click on the Banner name in the Banner Title column to select a table or group of tables.
Click on the Seq. # check box to select all tables for that banner.
Once any table or group of tables is selected for a specific banner, the Seq. # check box will be selected.
The Weighted column will contain Yes or No depending on whether any column of the banner is weighted or not.
# Selected displays the number of tables selected for that banner.

Select All

Selects all tables for all banners.

Deselect All

Clears all selected tables and banners. Use this option if you would like to run your tables without selecting a banner when banners do exist. A default banner with a single total column will run against the tables selected.

Find a banner

Allows you to enter search criteria to locate a specific banner. This is especially useful where there are many banners in your job file and you only want to select a specific banner.

Find Next Banner

Allows you to find the next banner that matches the previously entered search criteria. This is especially useful when there are multiple banners in your job file with similar names.

Select tables

You can select any number of tables.
To select adjacent tables, click on the first table, drag the mouse to highlight all the desired tables, then release the mouse button.
To select non-adjacent (non-contiguous) tables, keep the Ctrl key depressed while clicking on the individual tables you want to select.

Select All

Selects all tables for the current banner.

Deselect All

Clears all selected tables for the current banner.

Edit Selections

You can select tables or add tables to run for the current banner.
Choose to Use table names or Use sequence numbers in Table selection. Use table names is the WinCross default.
Enter the table names or sequence numbers in Table selection.
Separate table names or sequence numbers with commas. Indicate consecutive table names or sequence numbers with hyphens. For example: 1-3,10,12,13 or Q1-Q3,Q10,Q12,Q13.
Auto preview will display the tables selected in the Preview of table selection list box. Auto preview is the WinCross default.
When Auto preview is not selected, use Preview to display the tables selected in the Preview of table selection list box.

Word wrap

Displays the Table Title in word wrap mode. This is helpful if your Tables Titles are long.
Word wrap is disabled as the default.
When Word wrap is selected, it persists for the current WinCross session, unless it is manually disabled.

Find a table

Allows you to enter search criteria to locate a specific table. This is especially useful where there are many tables in your job file and you only want to select a specific table or group of tables.

Find Next Table

Allows you to find the next table that matches the previously entered search criteria. This is especially useful when there are multiple tables in your job file with similar names.

Report viewing formats

Plain text produces an ASCII plain text report.
Enhanced text uses the Setup|Job Settings|Enhanced Text Reports options to customize your report.
Enhanced text Options provides options for printing blank significance lines, suppressing blank lines after significance lines and the position of significance indicators.
Enhanced text Options are saved to the jobname.run file.
Excel produces an Excel report using options selected on the Excel Options dialog.
Excel Options

Data transformations applied

WinCross provides a status for reports indicating whether the banners/tables processed were weighted and if glossary transformations were applied. You can click on the Data transformations applied status to open the Report Log where banner weighting and Glossary information is provided.

Run Filter

Run filter lets you enter a Filter Title (optional) and Filter Logic to be applied to your entire set of tables.
The Filter Title you specify is placed under the Job title on your reports or at the top of the page if no Job title is specified and uses the justification selected for Job Title (Setup|Job Title). Filter titles can have up to 480 characters on up to 4 lines. Text automatically wraps, but you can specify where the text will wrap by entering multiple lines in the Filter Title window. Pipe symbols (|) are inserted in the filter title of the job file (View|Job File) automatically when multiple lines are entered. Keep in mind that regardless of how many characters you enter on each line, text will wrap based on the Table title width specified on the Table Presentation tab of Setup|Job Settings for Plain Text Reports or on the Enhanced Text Reports tab of Setup|Job Settings for Enhanced Text Reports. For example, if you enter 50 characters on the first line and 50 characters on the second line and your table title width is set at 40, the text will wrap at 40 characters from the first line and then wrap again after the remaining 10 characters, then wrap at 40 characters from the second line and again for the remaining 10 characters of the second line, resulting in 4 lines of row textt. Alternatively, you can specify where words should break by inserting a pipe symbol (|) at the point where you want the break to occur.
The Filter Logic can be simple or complex and can be up to 1024 characters.
The Run Filter is active check box can be used to remove the Run Filter without removing the Filter Title and Filter Logic that was previously entered. This allows you to reuse the Filter Title and Filter Logic if desired.

IMPORTANT: When a Run Filter has been specified and the Run Filter is active check box is selected, the Run Filter will be applied to all subsequent processing of tables, frequencies and/or marginals. For example, if you add a Run Filter to your table processing using Run|Tables and then select Run|Frequency, the Run Filter check box will be selected because the Run Filter is still active. To remove the Run Filter, deselect the Run Filter is active check box on the Run Filter dialog.

Use glossary transformations

Processes tables with Glossary statements applied.
Click on the check box to deselect Use glossary transformations. The WinCross default is to Use glossary transformations.

Interweave banners

Interweave banners lets you write the first table against each banner, the second table against each banner and so on. If you do not select Interweave banners, each banner is written for all the tables, the next banner is written for all the tables and so on. In the following examples, two banners and four tables are illustrated as they would appear with and without Interweave banners selected.

Default banner run:

Banner 1
	Table 1
	Table 2
	Table 3
	Table 4
Banner 2
	Table 1
	Table 2
	Table 3
	Table 4

All tables run by each banner (Interweaved):

Table 1
	Banner 1
	Banner 2
Table 2
	Banner 1
	Banner 2
Table 3
	Banner 1
	Banner 2
Table 4
	Banner 1
	Banner 2

Different tables for each banner (Default Setup):

Banner 1
	Table 1
	Tqable 3
Banner 2
	Table 2
	Table 4

Different tables for each banner (Interweaved):

Table 1
	Banner 1
Table 2
	Banner 2
Table 3
	Banner 1
Table 4
	Banner 2

If the tables selected for each banner are exclusive, then they are created in the order they appear in the Tables dialog box when Interweave banners is selected.

Note: The Interweave banners option is not available for use when you are writing tables to Excel using the Report viewing format of Excel.

Show table of contents

Use Show table of contents to process tables with or without creating the Table of Contents.
Show table of contents is enabled on the Run Tables dialog as the WinCross default.
This setting toggles with the Show table of contents setting in Job Settings|Table Presentation for the duration of the WinCross session.
To save the modified setting to your job file, you will need to save your job file.

Ignore ranking

Use Ignore ranking to run tables without ranking even if ranking is selected for one or more tables. This option is helpful for checking tables when comparing counts against a Frequency report that is not ranked.
The Ignore ranking option is not retained. Once tables are processed, this setting is no longer selected.

Run tables without weighting

Use Run tables without weighting to run unweighted tables even if the banner(s) selected is weighted. This allows you to process unweighted tables without having to use Setup|Banners|Edit Banner to remove weighting from the selected banner(s).
The Run tables without weighting option is not retained. Once tables are processed, this setting is no longer selected.
Select Show "Unweighted Tables" note to print the "Unweighted Tables" label above the Table title. This note will be justified based on the justification for Table title specified in Setup|Job Settings|Table Presentation for Plain Text Reports or in Setup|Job Settings|Enhanced Text Reports for Enhanced Text Reports.

Create tables

Create tables (default) processes the job file using the current open data file.
If you select Create tables, you must have an open data file to run the tables.

Create tables without data

Runs tables without data.
Create tables without data causes the ‘shell’ of the tables to be produced, including the banner and row text, table and job titles in addition to footnotes.

Run syntax check only

Use Run syntax check only to check for syntax errors in your job file.

Records per case

Enter the number of records per case.
When you first use Run|Tables for a new job, Records per case displays a 1 or the number of records from the last time the data file was run.
When you enter the number of Records per case for your data file, Cases to run is automatically updated to display the total cases in your data file.

Note: When using variable type data files, Records per case is not applicable.

Cases to run

Enter the number of Cases to run.
When you enter a number for Records per case, Cases to run is automatically updated to display the total cases in the data file.
You can run all cases or just a subset. Running a subset can be a good way of testing your job file.

Table Numbering

Specifies a table name other than 1 for the first table in your report.
Select Table Numbering.
Enter the new starting value in the Enter the starting value field. The starting value must be numeric.

Page Numbering

Specifies a page number other than 1 for the first page in your report.
Select Page Numbering.
Enter the staring page number in the Enter the starting page number field.
The Page numbering override is only active if the Show page numbers option has been specified in Setup|Job Settings|Page Layout.

You can bypass syntax checking by selecting Alt+Z on the Run Tables dialog box.

Run

Select Run to begin processing.