Welcome to SSC,

A few things...

You should get more responses if you post to a new thread instead of a prehistoric one.

For a newbie, nice post, but I have some questions...

What does the signature of your stored procedure look like? How to handle NULLs in parameters is different depending on if they're for Report parameters and if they're for stored procedure parameters. So where are the parameters coming from?