ReportServer Forum

arbeyg9

Member

Registered: 2017-07-24

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

eduardo

Administrator

Registered: 2016-11-01

Website

Re: NULL Parameters

Hi arbeyg9,

what exactly isn't working? Do you have an error ?
Take a look here: https://reportserver.net/en/guides/admi … arameters/

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

Best regards,
Eduardo