SAP Knowledge Base Article - Public

1738292 - Microsoft SQL Server Synonyms will not expand in Database Expert

Symptom

Microsoft SQL Server Synonyms will not expand in Database Expert

Environment

Crystal Reports 2008, 2011, Crystal Reports for Visual Studio 2010

Reproducing the Issue

  1. Connect to Microsoft SQL Server 2005 or 2008
  2. Create a new report and connect to the DB Servers
  3. Select synonyms
  4. Database Expert will not expand the list

Cause

Microsoft changed the way Synonyms were queried.

Resolution

This issue has been resolved in the following patches:

  • ADAPT01599228    Crystal Reports 2008 Fix Pack 4.2
  • ADAPT01599233    BOE 4.0 SP04_S1
  • ADAPT01615146    Crystal Reports for Visual Studio 2010 Service Pack 3
  • ADAPT01615147    Crystal Reports 2008 Service Pack 6
  • ADAPT01615148    Crystal Reports 2008 Fix Pack 5.1
  • ADAPT01622961    Crystal Reports for Visual Studio 2010 Service Pack 4

Keywords

Microsoft SQL Server 2005, Microsoft SQL Server 2008, Synonym , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Bug Filed

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports, developer version for Microsoft Visual Studio