SAP Knowledge Base Article - Preview

1661997 - Crystal report instance created by a Publication is prompting for database logon when drilling down to the on-demand subreport


When using a Crystal report with an on-demand subreport within a Publication, the receiver of the report will be prompted for the database logon when drilling down to the on-demand subreport even though the credentials might be hard-coded in the report.

  • Crystal report used in publication
  • On-Demand subreport on same data source as main report
  • Hard-coded username/password



  • SAP BusinessObjects Enterprise XI 3.x
  • SAP BusinessObjects Business Intelligence 4.0


SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Enterprise XI 3.1


prompt login logon prompt username password username/password subreport ondemand on-demand sub-report , KBA , BI-BIP-PUB , Publishing and scheduling in InfoView/BI launch pad , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.