Skip to Content
0

How to set the parameter to null by default in Crystal

May 10 at 08:41 PM

36

avatar image
Former Member

Hi,

I am using a Stored Procedure for one of my Crystal reports.I have parameters in it.

Generally when the parameters are from Stored Procedure we get a checkbox with set to null when we refresh the reports. I am not getting it, Is it because of the version of Crystal Reports that I am using(Crystal Reports 2016 SP04)

10 |10000 characters needed characters left characters exceeded
Former Member

My actual issue was I am not able to provide null as default to one of the parameters, if set check box is provided that would have been helpful.

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Abhilash Kumar
May 11 at 07:34 AM
0

Hi Pujitha,

Which database are you reporting against?

Have you "called" the Stored Proc via "Add Command" or added it manually from the list of SPs in the Database Expert?

-Abhilash

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Database is Netezza and I have called the Procedure from the list not from the add command.

0
Dell Stinnett-Christy May 14 at 02:33 PM
0

Crystal doesn't allow you to set parameters for Stored Procedures or Commands to null. Instead, you have to use a dummy value and your stored proc needs to be written to work with the dummy value.

-Dell

Share
10 |10000 characters needed characters left characters exceeded