The following queries will show Crystal reports deployed in Versago. They should be run against the Versago Common database.

-- Links to Crystal from Reports
SELECT a.ReportName, b.ActionName, b.ActionDestination
FROM   TWBS_WS_ORPT a
       INNER JOIN TWBS_WS_ORACT b ON a.ReportID =b.ReportID
WHERE  b.ActionType = 3
 
-- Reports based on Crystal
SELECT ReportName, ReportDataSource
FROM   TWBS_WS_ORPT
WHERE  ReportDataSourceType = 4

The following query will show Crystal reports deployed in Bizweaver. It should be run against the Bizweaver Common database.

SELECT DISTINCT
       WFDTL.TaskID AS 'WorkflowNumber', 
       WF.TaskName AS ' WorkflowName' 
FROM   VGO_Sync_Tasks AS WF
       JOIN  VGO_SYNC_WFDETAILS AS WFDTL ON WFDTL.TaskId  = WF.TaskId
WHERE  WFDTL.Type = 101

The following steps show how to redefine a Crystal report data source to use the SQL Native Client 11.0

Open the report in Crystal Reports (full version), and then set Datasource Location:

Create a new connection, using the OLE DB(ADO) connection type.

Choose provider SQL Server Native Client 11.

Enter the database details and create new data source. Replace all existing data sources with the new created one.