Skip to Content

How to set the parameter to null by default in Crystal

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)

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • May 11 at 07:34 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • May 14 at 02:33 PM

    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

    Add comment
    10|10000 characters needed characters exceeded