[MM-C14] Table Field Use

Lists the database tables and fields each Crystal Report uses.

Report document

Web Intelligence document [MM-C14] Crystal IA - Table Field Use from the MetaMiner standard report pack. It reads the MetaMiner Database (MMDB) through the MetaMiner Standard universe. See Reports and Data.

What it answers

• Which Crystal Reports read a given table.field?
• Which reports contain sub reports or command text?

Who uses it: Crystal Reports developers and database administrators planning table or column changes.

Report tabs

Tab	Shows
Crystal IA - Table Field Use	One row per report, table and field.

Image of MM-C14 refreshed for one environment, Crystal IA - Table Field Use tab

../images/reports/mm-c14-layout.png

Legacy image for reference: images/mmsr_layout_MM-C14.png

Columns and measures

Group	Columns
Report	Environment, Document, Document CUID, Crystal Doc, Crystal Doc CUID, Folder Type, Folder Name, Folder Path Complete
Database	Crystal Doc Table, Field, Table_Field
Flags	Crystal Doc contains a Sub Report?, Crystal Doc has Command Text (directly or in Sub Report)?

Prompts

Prompt	Required	Answer	What it does
Environments	No	Pick one or more	Environments to include, listed by CMSID with their description. Leave empty for all. The prompts below list only values from the environments you pick.
FolderTypes	No	Pick one or more	Folder types to include.
FolderPath	Yes	Pick one	Folder path pattern, matched with LIKE. Enter % for all folders.
Folders	No	Pick one or more	Folders to include. The list depends on the prompts above.
Table.Field	No	Pick one or more	Database table.field pairs to look for.

Image of the MM-C14 Prompts dialog with Environments answered

../images/reports/mm-c14-prompts.png

Legacy image for reference: images/mmsr_prompt_MM-C14.png

Input controls

Display controls change how the report shows its data:

Input control	What it does
Prompt Selection	Shows or hides the block under the header that lists your prompt answers. Spaced (default) shows it with a space between list items, Show shows it without spacing, Hide hides it.
Environment / CMSID	Shows environments in the report body by display name or by CMSID. Filters and prompts always list CMSIDs.
Folder / Complete	Shows the folder name or the complete folder path.

Filter controls keep only the rows that match the values you pick: Environment, Folder, Table, Field, Table.Field, Document contains a Sub Report?, Document has Command Text?.

Image of the MM-C14 Input Controls panel

../images/reports/mm-c14-input-controls.png

Legacy image for reference: images/mmsr_ICs_C14.png

Drill links

Link	Opens
Document name	Opens the report in BI launch pad.
Command Text drill	Opens [MM-C17] Command Text Use for that report.

A drill link opens the target report through BI launch pad OpenDocument and passes the environment and the selected item as prompt answers.

Run the report

1. In BI launch pad, open [MM-C14] Crystal IA - Table Field Use from the folder where you imported the standard report pack.
2. Refresh the document and answer the prompts. Keep FolderPath at % to include all folders.
3. Use the input controls to change the display or narrow the results.

Data it needs: Crystal Reports document processing (tables, fields, connections, Business Views and prompt groups). See Document Processing.

Related reports

• [MM-C15] DB User Use - lists the database user names your Crystal Reports connect with, original and overridden.
• [MM-C16] Data Source Use - lists the database servers your Crystal Reports connect to, original and overridden.
• [MM-C17] Command Text Use - lists the SQL command text of your Crystal Reports and finds reports whose command text contains a search term.
• Reports and Data - all standard reports, shared prompts and delivery