[MM-C14] Crystal IA - Table Field Use¶

Purpose¶

The purpose of this report is to list Table Field and identify in which Crystal Report documents they are used within.

Prompts¶

Prompt_Example

Environments -> {FolderTypes -> {FolderPath -> {Folders} | {Table.Field}}}

Environments

This optional multi-select prompt (featuring in most MMSRL reports) is often used as the parent of a cascading set of subsequent prompts. The LOV will list the CMSIDs of all available Environments. The prompt return value is CMSID, but the more descriptive Environment description along with whether the Environment supports "Enhanced IA" is also detailed in the LOV entries.

FolderTypes

This optional multi-select prompt features in most reports and again is often used as the parent of a cascading set of subsequent prompts for their LOVs and its own LOV cascades from the Environments prompt.

FolderPath

This mandatory mono-select prompt (with its default set to wildcard %) features in most reports with its LOV determined by FolderTypes and again is often used as the parent of a cascading set of subsequent prompts.

Folders

This optional multi-select prompt features in most reports, which benefit the report output by restricting the folders being reported against. Its LOV is determined by the preceding prompts, including the FolderPath prompt (if changed from the default wildcard of %).

Table.Field

This optional multi-select prompt allows the user to restrict the report output to selected "Table.Fields". Its LOV is determined by the preceding prompts, including the FolderPath prompt (if changed from the default wildcard of %).

Layout¶

Layout

Hyperlinks

Drill ▼

Opens & refreshes [MM-C17] Crystal IA - Command Text (passing in the relevant parameters for the Drill), to report the Cystal Document's Command Text.

Input Controls¶

Input_Control_Example

Prompt Selection

Allows the user to reveal / hide the display of the Prompt Selection (can also include Input Control selection too).

"Spaced" option

The default "Spaced" option reveals the Prompt Selection (below the report header), but also reformats lists to be more readable by adding a space between listed items.

"Show" option

The alternative "Show" option reveals the Prompt Selection (below the report header), without reformatting lists with a space between listed items.

"Hide" option

The "Hide" option hides the Prompt Selection.

Environment / CMSID

Allows the user to switch the display of Environment (within the report) between CMSID and CMS display name (as configured in MetaMiner Administrator).

Warning

Although this Input Control switches the display within the report's results, it does not affect what is listed in the Environment input control, which always lists CMSID. The same is true for the Environments prompt (during prompt selection) and the display of Environments (within the prompt selection block).

Folder / Complete

Allows the user to switch the display of the Folder within the report between the Folder or Complete Folder Path.

Environment

Allows the user to filter the report results to a selected CMSID.

Warning

Although this Input Control is named Environment, it always works on CMSID regardless of the prior Environment / CMSID selection.

Folder

Allows the user to filter the report results to the selected Folder Path.

Table

Allows the user to filter the report results to the selected Table.

Field

Allows the user to filter the report results to the selected Field.

Table.Field

Allows the user to filter the report results to the selected Table.Field combination.

Document contains a Sub Report?

Allows the user to filter the report results as per the Input Control selection.

Document has Command Text?

Allows the user to filter the report results as per the Input Control selection.