May 11, 2011 at 1:27 pm
Hi,
I am populating parameter2 with respect to parameter1 and through a query. But I am still seeing the default value of paramter2 in the drop drown available.
How do I remove that and directly see the value populated through the query in the drop-down. Please Help!!!
If I remove the default value I see <select a value? how can I remove that and see the value from query directly on the drop down.
May 12, 2011 at 1:31 pm
Hi,
I just tried that for you.
All you need to do is set Default vale for Parameter2 with a expression something like below...
=IIF(Parameters!paramSize.Value="38","S",
IIF(Parameters!paramSize.Value="40","M",nothing)
)
In above expression, paramSize would be Parameter2 for you.
Above expression sets paramMaritalStatus as S if size=38 and M if size = 40
(I know there can be no relation between size and Marital status, just an example here 🙂 )
Let me know if it works for you ?
Regards,
Athar Iqbal
May 12, 2011 at 1:32 pm
One correction
paramSize would be parameter1 in your case and not Parameter2.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply