SAP Knowledge Base Article - Preview

1198920 - Supressing prompt from stored procedure in Crystal Reports

Symptom

When you create a report based off a stored procedure with input parameters, Crystal Reports automatically generates prompts for the procedure's input parameters.
 
An example is when a recordset is to be restricted depending on the user who is logged onto an Enterprise system.
The username (CurrentCEUsername Document Property) will be passed to the stored procedure which will create and return the recordset.
The resulting recordset is then limited to all the records where the username matches the value in the database. 
When you assign the CurrentCEUserName to the prompt for the stored procedure the prompt popup still appears.


Read more...

Product

Crystal Enterprise 10 ; SAP BusinessObjects Business Intelligence platform R2 ; SAP BusinessObjects Enterprise XI ; SAP Crystal Reports XI ; SAP Crystal Reports XI R2

Keywords

Stored Procedure;Prompt;Input Parameter;CurrentCEUserName , 2489141 , KBA , BI-BIP , Business intelligence platform , 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.