Crystal Database Configuration Remapping¶
Video - Crystal Database Remapping¶
Watch the video below to see an end-to-end walk-thru of CR DB remapping, or jump further below to see individual steps.
Overview¶
Crystal Reports have many data source options that allow users to specify where data should be retrieved from prior to refreshing a report. Such configurations can be managed in the Properties page of the CMC, under the Database Configuration menu as shown here:
In this chapter, we'll review how to modify these properties "in bulk" - or change database configuration settings for multiple Crystal Reports at once.
This drastically reduces the time it takes to perform such operations while reducing points of failure.
Crystal Database Remapping - Walk-thru¶
Do not change configs from the CMC
In the following topics we show the database configuration item, but do not actually change them from the CMC. Later on, we'll use MetaMiner Client to make these changes.
Identify Crystal Reports for Database Remapping¶
First note down all of the target configurations needed
| Item | Setting | Description |
|---|---|---|
| 1 | Custom or Original database logon information? |
Use custom since we're remapping to a new datasource |
| 2 | Server |
The ODBC DSN name usually |
| 3 | Database |
The database name associated with the DSN |
| 4 | User |
Username to authenticate to the database |
| 5 | Password |
Password belonging to the user |
| 6 | Table Prefix |
When using a different database or "schema", it may be needed to remap the table prefix |
Modify Extended Properties from MetaMiner¶
- Right-click on one or more Crystal Reports from
CMS Explorer - Choose Modify → Modify Extended Properties
- Review the custom properties below as they map back to the CMC database configuration page. Because there are many properties and we're only
interested in database configs ("Logon Info"), search for si_logon_info in the quicksearch bar to limit the tree size.
