Format Report Tables

There are many ways to change the formatting of a report table. Right-click a report table to access the following formatting options:

Table Style

adds borders, shading, and dividing lines to the table. Select from the following options:

‒	Underline Headings shows the preference setting for Underline Table Headings.

‒	Shade Headings shows the preference setting for Shade Table Headings.

‒	Column Borders contains borders outside columns and divider lines between columns.

‒	Row Borders contains borders outside rows and divider lines between columns.

‒	Shade Alternate Rows shades alternate rows.

‒	Shade Cells shades the body of the table. When used with Shade Alternate Rows, a darker shade is used on alternate rows.

Note: Change the format of all report tables by selecting the preceding options in the JMP preferences. On Windows, the Report Tables options are in File > Preferences > Styles. On Macintosh, select the Report Tables options in JMP > Preferences > Styles.

Columns

shows or hides columns in the table.

Note: Columns whose names begin with a tilde (~), such as ~Bias, are not applicable to the analysis that you ran and do not appear in the table, even if you place checks next to their names.

Sort by Column

Sorts the columns in descending or ascending order by the selected column.

Make into Data Table

creates a JMP data table from the report table.

Make Combined Data Table

searches the report for other tables like the one you selected and combines them into a single data table.

Make Into Matrix

creates a JMP matrix from a report table. See Turn a Report Table Into a Matrix.

Copy Column

copies the contents of the right-click column to the Clipboard for pasting into another window or application.

Copy Table

copies the right-click table to the Clipboard for pasting into another window or application.

Bootstrap

approximates the sampling distribution of a statistic. For more information, see the Basic Analysis book.

Modify Display Box Properties in a Report

For each display box in a report, you can change properties such as the font, text color, padding, and alignment. Your changes are included when you save the report as a script, a graphic, or a journal.

To modify display box properties, follow these steps:

1.	Right-click the disclosure icon next to the report and select Edit > Show Properties.

The Properties pane appears.

2.	Modify the report properties.

3.	Click the report to view your changes.

Tips:

•	In the Properties pane, use the arrow buttons to navigate among display boxes in the display tree.

•	After you open the Properties pane, use the Selection tool to select a specific report and change its properties.

Turn a Report Table Into a Matrix

You can create a JMP matrix from a report table. For example, when working with JMP Scripting Language (JSL), you might want to access a report’s table that has been stored into a JSL variable. Or, you might want to store a report table’s values into a table property as either a table property or as a JSL assignment, which is stored within the data table and is accessible via a script or the Formula Editor.

To store a table in matrix form into a global variable, into a table property, or into a table property as an assignment:

1.	Right-click anywhere in a report table.

2.	Select Make into Matrix.

3.	In the window that appears, tell JMP how you want to store the table.

4.	(Optional) Rename the variable or property by entering a new name into the box beside Name.

Use Conditional Formatting

Note: You must enable Show conditional formatting in Reports preferences for your conditional formatting to appear in JMP reports.

To configure reports to use conditional formatting, you must first set your report preferences to enable showing conditional formatting. See Reports in JMP Preferences for details.

To configure conditional formatting:

1.	Open the JMP Preferences window.

2.	Select the Reports preference group.

3.	Click Manage Rules.

The Conditional Format Rule window appears.

Conditional Format Rule Window

By default, JMP includes conditional formatting for Correlation, Factor Patterns, and PValue. These rules are enabled by default. The PValue rule is applied to columns that contain probability values.

From this window you can Add, Edit or Delete a rule.

Disable or Enable a Rule

To disable or enable a rule:

1.	Open the JMP Preferences window.

2.	Select the Reports preference group.

3.	Click Manage Rules.

The Conditional Format Rule window appears.

4.	Select the rule from the list.

5.	If Rule enabled is selected, select to disable.

6.	If Rule enabled is not selected, select to enable.

Add a Rule

To add a rule:

1.	Open the JMP Preferences window.

2.	Select the Reports preference group.

3.	Click Manage Rules.

The Conditional Format Rule window appears.

4.	Click Add.

A blank Conditional Format Rule window appears.

Blank Conditional Format Rule Window

5.	Add and format conditions as described in Add a Condition.

6.	Click OK to save the new rule and return to the previous Conditional Format Rule window.

7.	Select Rule enabled to enable the rule.

Edit a Rule

To change the conditional formatting of a rule:

1.	In the Conditional Format Rule window, select the rule from the list.

2.	Click Edit.

The Conditional Format Rule window appears, showing the selected rule’s current conditions.

Conditional Format Rule Window

The default rule for PValue includes two conditions. The order of the list indicates the order that the rules are applied. For example, a p-value of 0.04 would not invoke the first rule (x < 0.01) but would invoke the second rule (x < 0.05).

Note: You cannot edit an existing condition within a rule. To edit an existing condition, you must delete the condition and then add it. See Edit an Existing Condition for details.

Add a Condition

To add a condition to a rule:

1.	Open the rule to view the Conditional Format Rule window.

2.	In the Condition area, select a relation from the drop list and enter a value in the text box.

If you want the condition to include a value range:

‒	Select > or ≥ from the relation drop list and enter the value in the text box.

‒	Select the check box, select the < or ≤ relation, and enter the value.

3.	Format the condition using the procedure described in Format a Condition.

Tip: When you click Add, the condition and its format settings are immediately added to the bottom of the condition list and the Condition and Format areas return to their default settings. Verify your settings before you click Add.

4.	After verifying your settings, click Add to add the condition to the rule.

5.	Use the and buttons to position the condition within the list.

Example of an Added Condition

6.	Click OK to save your changes and return to the previous Conditional Format Rule window.

Delete a Condition

To delete a condition from a rule:

1.	In the Conditional Format Rule window, select the condition and click Delete.

2.	Click OK to save your changes and return to the previous Conditional Format Rule window.

3.	Click OK to return to the Preferences window.

Format a Condition

To format values that fall within a condition:

1.	With a Condition entered, select a Text Color from the drop list:

‒	Default - The value appears without color.

‒	Solid - The value appears in the specified color.

‒	Dimmed - The value appears dimmed by the specified transparency.

‒	Color Range - For ranged conditions, the values appear in color gradients within the specified color range.

‒	Dimmed Range - For ranged conditions, values appear in dimmed gradients by the specified transparency range.

2.	To specify a text color, click the color swatch and select a color.

3.	To specify a transparency, enter the percent value (for example, ‘60%’).

The Sample area displays a preview of the appearance of the text column.

4.	Select a Background Color from the drop list:

‒	Default - The value appears without a color background.

‒	Solid - The value appears with the specified color background.

‒	Color Range - For ranged conditions, the values appear with background color gradients within the specified color range.

5.	To specify a background color, click the color swatch and select a color.

The Sample area displays a preview of the appearance of the text column.

6.	To have condition values noted, select an Annotation from the drop list:

‒	None - No notation is used on the value.

‒	Box - The value appears in the table with a box around it.

‒	Circle - The value appears in the table with an ellipse around it.

‒	* (asterisk) - An asterisk (*) appears to the right of values in the table.

The Sample area displays a preview of the appearance of the text column.

7.	To style the value text, select the Font Style from the drop list:

‒	None - No style is used to format the value.

‒	Plain - No style is used to format the value.

‒	Bold - The value appears bolded in the table.

‒	Italic - The value appears italicized in the table.

‒	Bold Italic - The value appears bolded and italicized in the table.

Example Formatting

Note: After configuring the formatting, remember to click Add to add the new condition to the rule.

Edit an Existing Condition

To change the formatting for an existing condition:

1.	In the Conditional Format Rule window, select the condition and click Delete.

2.	Re-create the condition by using the procedure described in Add a Condition.

3.	Format the conditional using the procedure described in Format a Condition.

4.	After verifying your settings, click Add to add the condition to the rule.

5.	Use the and buttons to position the condition within the list.

6.	Click OK to save your changes and return to the previous Conditional Format Rule window.