How to pass null value in Multi-select value

Hi Guys,

Need some help here, because i need to create a report w/ parameter that can handle multi-select value…

i follow this instruction >>> Multi select lookups.

After creating the classes, i proceed in creating SSRS report in the properties of parameter the Multi value is automatically “TRUE”, now to accept a null value i need to change the Allow blank and Nullable to TRUE, but there is a error

“cannot accept null value”

Why i need to blank the parameter? because sometimes i don’t want to use the parameter such as:

BRAND
CATEGORY
SUB CATEGORY

how to avoid this error? or is any ways to solve this issue?

thank you.

HI JEMT,

Have you changed parameter properties in VS.

Path
VS–>Parameters node–>Particular parameter–>Properties

Allow blank = True
Nullable = true

Try this.

Thanks,
Suresh.G

Hi Sir,
I do that, i already said that above…

tnx