Click here to Skip to main content
15,881,812 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
hello,
I have a drop down list in my ssrs report
When I run the report in preview mode, that drop down list have a <Select a Value> and my assumption is since I want them to pass null, I will just leave them that way.
However, when the report is ran, I receive an error saying "Please select a value for the parameter: (my parameter)". So it forces me to select an option at which I don't want to do.
Here i want to pass null value to that parameter.
Posted

1 solution

Hi,

Kindly read article on report trigger.

About report triggers

List of drop down to have some hard coded value = NL and using report trigger the report SQL where clause to be modified to have IS NULL condition.

Regards,
Sudhir Kankal
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900