Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

My parameters are required - no data if NULL is selected

Status
Not open for further replies.

PleaseGiveHelp

Programmer
Oct 29, 2002
131
US
I noticed that since we upgraded to Crystal Enterprise that a checkbox appears in our parameters specifying that we can check the box for NULL. However not ALL of our reports have this. I have a report that I have 1 parameter for - and it is required. I don't want the null checkbox to appear. Is there anyway I can get it off of the parameter window - just for this report? Within Crystal 8.5 can I specify that a parameter is NOT nullible? Or is this done within the stored procedure itself? Help!
 
Unfortunately I think that it's done by the SP and you have no control over them.

You might check for NULL within the SP and create a default value if NULL is passed.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top