NULL Parameters

Hi, im working with input parameters
something like this:

select product_id, product_name from product
where product_id = ${id}

and that goes well

But im trying to get a NULL value from the input, so if i don’t write anything on the input, it will shows me everything.

I was trying with something similar to store procedures like this:

where ${id} is NULL or product_id = ${id}

But it doesn’t work

What can i do ?

Thanks

Hi arbeyg9,

what exactly isn’t working? Do you have an error ?
Take a look here: https://reportserver.net/en/guides/admin/chapters/using-parameters/

You should try with:
$X{EQUAL, column, parameterkey}: If the parameter value is other than NULL, an expression in the form = ? will be generated. If the parameter value is NULL, the generated expression is IS NULL.

Best regards,
Eduardo