I want to show the text "All" in textbox IIF Parameter CUSNO is selected null in SSRS. Else textbox has the Parameter!CUSNO.Value in it.Here's what I've already tried:
=IIF(IsNothing(Parameters!CUSNO.Value), "All", Parameters!CUSNO.Value)
Asked
Active
Viewed 30 times
0
FunThomas
- 23,043
- 3
- 18
- 34
Michael Benning
- 5
- 5
-
Are you talking about VBA or VB.Net? – FunThomas Jul 05 '23 at 07:50
-
Thats VB.NET... – Michael Benning Jul 05 '23 at 07:59
-
Is the parameter multi-value? – Alan Schofield Jul 05 '23 at 08:58
-
No. It's not multi-value – Michael Benning Jul 05 '23 at 09:22
-
I can't see anything wrong with your expression, in fact I just created a quick report and test. It worked fine. Do you see the `NULL` checkbox next to the parameter field? Show some screen shots of your parameter setup. – Alan Schofield Jul 05 '23 at 14:09
-
How are you populating the CUSNO parameter values? Is Allow Blank checked? – Hannover Fist Jul 05 '23 at 17:55
-
Are you 100% sure IsNothing() is what you want to use? Is the field actually Null, or is it DBNull? While for all intents and purposes mean the same thing DBNull != nothing. https://stackoverflow.com/questions/14600825/difference-between-nothing-and-system-dbnull – Hursey Jul 05 '23 at 20:45