Skip to content

[MM-C16] Data Source Use

Lists the database servers your Crystal Reports connect to, original and overridden.

Report document

Web Intelligence document [MM-C16] Crystal IA - Datasource 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 connect to a given database server?
  • Where a report's stored server was overridden in the CMS.
  • Which reports must be repointed when a database server moves.

Who uses it: BI platform administrators and database administrators planning server moves and consolidations.

Report tabs

Tab Shows
Crystal IA - Datasource Use One row per report and connection.

Image of MM-C16 refreshed for one environment, Crystal IA - Datasource Use tab

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

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

Columns and measures

Group Columns
Report Environment, Document, Document CUID, Crystal Doc, Crystal Doc CUID, Folder Type, Folder Name, Folder Path Complete
Connection Active Connection Type, Active Server, Active DB User, Original Server, Original Server Type, Original DB User, Custom Server, Custom Server Type, Custom DB User, OLAP Datasource?
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.
Servers No Pick one or more Database server names to look for, checked against the original and the custom (overridden) server.

Image of the MM-C16 Prompts dialog with Environments answered

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

Legacy image for reference: images/mmsr_prompt_MM-C16.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, Active Server, Original Server, Custom Server, Document contains a Sub Report?.

Image of the MM-C16 Input Controls panel

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

Legacy image for reference: images/mmsr_ICs_C16.png

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-C16] Crystal IA - Datasource 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.