Parameter Stored Procedure returns a Null

[msflinx]

How do I kill the report, when a parameter that is set by a stored procedure is null (this is not a data error, but a small potential error with new clients).

If I set the parameter to not allow nulls, the report errors out.

Is there some code I can write that will grab this null set and say "Stop here, you don't have any data" and then post a "No Data Available" statement?

Please let me know if you need more information.

Thank you in advance for your assistance.

msflinx

 

[msflinx]

I just re-read this and thought I would clarify.

I am filling a "drop-down list" for my parameter, via a stored procedure. That stored procedure is returning a null dataset, so I do not have a "drop-down list". I want to kill the report at this point, with a No Data available.

Is this possible?

Thanks,

msflinx