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 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
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 and
then wrap again at the end of the first line, 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 text. 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.
All
tables run by each banner:
Banner
1 |
|
Table
1 |
|
|
Table 1 |
|
Banner 1 |
|
Table 2 |
|
Banner 2 |
|
Table 3 |
Table 2 |
|
|
Table 4 |
|
Banner 1 |
Banner2 |
Table 1 |
|
Banner2 |
|
Table 2 |
Table 3 |
|
|
Table 3 |
|
Banner 1 |
|
Table 4 |
|
Banner 2 |
|
|
Table 4 |
|
|
|
|
Banner 1 |
|
|
|
Banner 2 |
Different
tables for each banner:
Banner
1 |
|
Table
1 |
|
|
Table 1 |
|
Banner 1 |
|
Table 3 |
Table 2 |
|
Banner
2 |
|
|
Banner 2 |
|
Table 2 |
Table 3 |
|
|
Table 4 |
|
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.
Related topics:
Advanced processing features