[MM-C17] Command Text Use¶
Lists the SQL command text of your Crystal Reports and finds reports whose command text contains a search term.
Report document
Web Intelligence document [MM-C17] Crystal IA - Command Text 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 use SQL commands instead of tables?
- Which command texts reference a given table, column or SQL fragment?
- Which sub reports carry the command text.
Who uses it: Crystal Reports developers and database administrators planning database changes.
Report tabs¶
| Tab | Shows |
|---|---|
| Crystal IA - Command Text | One row per report table, with its command text. |
Image of MM-C17 refreshed for one environment, Crystal IA - Command Text tab
../images/reports/mm-c17-layout.png
Legacy image for reference: images/mmsr_layout_MM-C17.png
Columns and measures¶
| Group | Columns |
|---|---|
| Report | Environment, Document, Document CUID, Crystal Doc, Crystal Doc CUID, Folder Type, Folder Name, Folder Path Complete |
| Table | Crystal Doc Table, Crystal Doc Table (Id), Crystal Doc Table Class, Crystal Doc Table Type, Crystal Doc Table Command Text |
| Sub reports | Crystal Doc Table Sub Report, Crystal Doc Table is a Sub Report Table?, Crystal Doc contains a Sub Report? |
| Connection | Active Server, Active Database, Crystal Doc Connections List (Active) |
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. |
| DocumentCUIDs | No | Pick one or more | Document CUIDs, normally filled in by a drill link from another report. Leave empty when you refresh the report yourself. |
| Search Term | Yes | Type a value | Text to look for in the SQL. Enter % to list everything. |
Image of the MM-C17 Prompts dialog with Environments answered
../images/reports/mm-c17-prompts.png
Legacy image for reference: images/mmsr_prompt_MM-C17.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. |
| Expand | Shows long multi-value fields (such as SQL text and lists) in full, or shortens them to one row. |
Filter controls keep only the rows that match the values you pick: Environment, Folder, Active Server, Active Database, Document contains a Sub Report?.
Image of the MM-C17 Input Controls panel
../images/reports/mm-c17-input-controls.png
Legacy image for reference: images/mmsr_ICs_C17.png
Drill links¶
| Link | Opens |
|---|---|
| Document name | Opens the report in BI launch pad. |
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¶
- In BI launch pad, open
[MM-C17] Crystal IA - Command Textfrom the folder where you imported the standard report pack. - Refresh the document and answer the prompts. Keep FolderPath at
%to include all folders. Enter%in Search Term to list everything. - 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-C14] Table Field Use - lists the database tables and fields each Crystal Report uses.
- [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-W17] Data Provider SQL - lists the SQL of each Web Intelligence data provider, with row counts and refresh times, and finds documents whose SQL contains a search term.
- Reports and Data - all standard reports, shared prompts and delivery