SAP Knowledge Base Article - Public

1270980 - Users should be prompted for database logon credentials before generating the report

Symptom

Users are not prompted for the database logon credentials before generating a report in Infoview or CMC.

Reproducing the Issue

  • Logon to CMC
  • Go to the report
  • Go to the process tab
  • Click on database tab
  • Set the database logon credentials.
  • At the bottom select the "Use the same database logon as when report is run" option.
  • Click on update
  • Preview the report

 

  • Product: Crystal Reports Server XI R2
  • Operating System: Windows 2003
  • Database: SQL Server 2005

Cause

  • The Logon credentials were set for the report [In CMC]
  • "Use the same database logon as when report is run" option was set for the report.

Resolution

  1. Go to the report
  2. Go to the process tab
  3. Click on database tab
  4. At the bottom select the "Prompt the User for database logon" option.
  5. Click on update

Keywords

Users should be prompted for database logon credentials before generating the report , KBA , BI-BIP-ADM , BI Servers, security, Crystal Reports in Launchpad , How To

Product

Crystal Reports Server XI R2