sql server reporting services: textbox edit expression problem ??? -- sql server reporting services

textbox edit expression problem ???

frankie lo
5/27/2006 10:55:14 PM

sql server reporting services: Ha...please any help..why "=" don't work.!!!!!!!!!!!!!!!!!!!!!!!!

-----------------The expression
=IIF(First(Fields!customer_id.Value, "customer_list") = "BBY", "BBY",
"Other")
-------------------------

(First(Fields!customer_id.Value, "customer_list") is "BBY", but textbox
always show "Other". i don't what happen????

I find that it only work like this
-----------------The expression
=IIF(First(Fields!customer_id.Value, "customer_list") > "BBY", "BBY",
"Other")
-------------------------
It shows "BBY" when value is "ACC" and "Other" when value is 'TTR". So why =
do'nt work.

Any help

Re: textbox edit expression problem ???

Colin Halliday
5/29/2006 12:00:00 AM

Is the "customer_list" scope the correct scope for what you need? Try
removing this second argument of the First function altogether.

Colin

[quoted text, click to view]