Accessing Arrays data
I am trying to put in a "No row" message with the following code: It works fine if I enter 2 or more parameter but if only 1 is entered NOTHING shows up not even the constant.
=iif(Parameters!Warehouse.count = 1
"No data selected for:" & vbcrlf &Parameters!Warehouse.Value(0),
iif(Parameters!Warehouse.count = 2,
"No data selected for:" & vbcrlf &
Parameters!Warehouse.Value(0) & vbcrlf &
Parameters!Warehouse.Value(1),
"More than 2"))
If it works for 2 or 3 entries why will it not work for 1.I'm new at this so any help is appreciated. If there is an easier way please send example. I really need something that works for an unlimited # of entries.
[1053 byte] By [jhaberer] at [2007-12-22] 