SAP Knowledge Base Article - Public

1447894 - Multiple database logon prompts are shown while refreshing Crystal Reports from Crystal Reports designer.

Symptom

Multiple database logon prompts are shown while refreshing Crystal Reports from Crystal Reports designer.

Environment

Crystal Reports 2008

Reproducing the Issue

  1. Create a Crystal Reports using multiple command object based on a single database.
  2. Create the report using fields from both the command objects.
  3. Refresh the report.

Cause

The command objects have no links in between so it prompts for database logon for every command.

Resolution

  1. In Crystal reports designer go to Database Expert.
  2. Go to Links tab and establish links between different command objects.

Keywords

KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

Crystal Reports 2008 V0 ; Crystal Reports 2008 V1