How to set default value of Boolean parameter false in SSRS?

Question

I have 18 Boolean parameters in my report. I want to make their default value to false through expression when ever user runs the report.

I am trying this but its not working

=SIDIdNum.Value = "false"

Getting Error: parameter SIDIdNum caontain an error [BC30451]

score 8 · Accepted Answer · answered May 15 '15 at 02:15

8

Have you tried just...

false

enter image description here

I'm also not sure where you're trying to set this value? If you are accessing the parameter from somewhere other than parameter properties dialog, you'll need to use

Parameters!SIDIdNum.Value="false"

answered May 15 '15 at 02:15

Trubs

2,829
1
24
33

1

I am trying to set from parameter properties. It worked Thanks. – younus May 15 '15 at 14:11

score 6 · Answer 2 · answered Feb 19 '16 at 20:43

6

I had to tweak the prior answer in SSRS 2012.

I needed to make the value: =false

answered Feb 19 '16 at 20:43

Michele Adams

61
1
2

1

Absolutely correct. Equal (=) sign is required in SSRS 2008 R2 – Naresh Mittal May 08 '16 at 09:41

How to set default value of Boolean parameter false in SSRS?

2 Answers2