SAP Knowledge Base Article - Public

1291890 - How to remove “Set to Null” option for a stored procedure parameter in crystal reports.

Symptom

How to remove "Set to Null" option for a stored procedure parameter in crystal reports.

Reproducing the Issue

Environment Details:

Business Objects Enterprise: XIR1,R2

Crystal Designer:XI,XIR2,2008

OS: Windows Server

Database: Any Database

 Steps to reproduce the Issue:

1. Create a Crystal report using a Stored Procedure having parameter.

2. When you refresh the report "Set to Null" option is prompted for the Stored Procedure Parameter.

Resolution

Steps to Resolve the Issue:

1. Create a New Connection; Insert a command instead of using a stored procedure.

2. In the Add a Command, Write

Exec StoredProcedureName{?Parameter}

3. {? Parameter} is created at command level i.e.

Parameter List-->Create-->Give the parameter name-->Type of the parameter-->OK

Note: Type of the parameter should be same as in stored procedure.

4. When you refresh the report Set to Null option has been removed.

Keywords

Null value option,Stored Procedure. , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , How To

Product

SAP Crystal Reports XI R2