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.
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.