Identify reports using a specified connection

Problem:

You need to determine if there are Crystal Reports using a specific ODBC connection to an underlying data source.

Solution:

There are a couple of ways you can do this using Find it EZ.

Ensure that searching connection information is enabled in the Crystal Report settings:

• In the Source Panel in one of the Folders & Version Control or Business Intelligence Platforms click to Include: Crystal Reports source, as below:

  

• Open the Crystal Reports project settings: right-click on Crystal Reports in the Advanced Search Filters section of the Source panel on the left
  
  - OR - from the menu, select  Projects -> Settings -> Crystal Reports 

  

• In the Search section, click to check the Data Source and Connections option

Then,

1. Good - Run a Boolean search for {ODBC} AND {DSN}; where DSN is your DSN. That should find all of the reports with that connection.

   OR

2. Best - Generate the "SQL Code Extract" Report which will list all of the connections used in your reports. You can then filter and sort the spreadsheet to those using ODBC and a certain connection.