Hi I Create a report in SSRS. i want to write iif expression like iif element_id =123 then take element_id 124 value how to write expression for this in ssrs

Hey There, Can you please clarify this? - You want to display the Element_ID of 124 when your current Element_ID is 123? What would you want to display when the element_ID is not 123? Cheers, IceQBPlease mark correct answers :)

iif my element id =123, i want to get element id 124's value and show in element id 123 value.. like element id value 122 12 123 78 <- from 124 element value 124 78

Better write a VB function for this in the SSRS code page and use the function here. AFAIK, IIF() does not support data iteration through datasets. Hope this helps.NSK

Better write a VB function for this in the SSRS code page and use the function here. AFAIK, IIF() does not support data iteration through datasets. Hope this helps.NSK

Better write a VB function for this in the SSRS code page and use the function here. AFAIK, IIF() does not support data iteration through datasets. Hope this helps.NSK

Thanks for clarifying. Here's what you can do: Let's assume that your dataset is named "DataSet1" and has two fields as below: element_id number 122 12 123 78 <- from 124 element value 124 78 Now, to display the 124's number value for 123, place an expression under your number field as below: = IIf ( Fields!element_id.value = 123, LookUp (124, Fields!element_id.value, Fields!number.value, "DataSet1"), Fields!number.value) ) Please Note: Replace the Fields!number.value with the actual name of your field, and also the name of the DataSet1 to the actual name of your dataset. Let me know if you need more info. HTH. Cheers, IceQB Please mark correct answers :)