HI IM USING THE FOLLOWING CODE IN THE RDL FILE I NEED TO CHECK IF THE USER SELECT GROUP CHANGE BY DAY ("D") OR TIMESTAMP ("T") AND APPLY THE FOLLOWING FEILDS =(IIF Parameters!p_GroupChangesBy.Value = 'D',(((IIF((LEN(Fields!DETAILS_TYPE.Value)>0), Fields!DETAILS_TYPE.Value & vbcrlf,"") & IIF((LEN(Fields!DETAILS_ROLE.Value)>0), Fields!DETAILS_ROLE.Value & vbcrlf,"") & IIF((LEN(Fields!DETAILS_ORGANIZATION.Value)>0), Fields!DETAILS_ORGANIZATION.Value & vbcrlf,"") & IIF((LEN(Fields!DETAILS_PERSON.Value)>0), Fields!DETAILS_PERSON.Value & vbcrlf,"") & IIF((LEN(Fields!DETAILS_TITLE.Value)>0), Fields!DETAILS_TITLE.Value & vbcrlf,"") & IIF((LEN(Fields!DETAILS_WORKPROFILE.Value)>0), Fields!DETAILS_WORKPROFILE.Value & vbcrlf,"") & IIF((LEN(Fields!DETAILS_STATUS.Value)>0), Fields!DETAILS_STATUS.Value & vbcrlf,"") & IIF((LEN(Fields!DETAILS_STATUSDATE.Value)>0), Fields!DETAILS_STATUSDATE.Value,"") & IIF((LEN(Fields!DETAILS_QCDONE.Value)>0),Fields!DETAILS_QCDONE.Value,"")) & vbcrlf),(IIF((LEN(Fields!Add_oldB.Value)>0), Fields!Add_oldB.Value & vbcrlf,"")) ) THIS IS THROWING AN ERROR. CAN U TELL ME WHERE IM GOING WRONG. THANKS JUSTIN

Hi, You should use double-quotes here: =(IIF Parameters!p_GroupChangesBy.Value = 'D'Remember to mark as an answer if this post has helped you.

Also the IIF syntax is wrong Try this =IIF(Parameters!p_GroupChangesBy.Value = "D", (((IIF((LEN(Fields!DETAILS_TYPE.Value)>0), Fields!DETAILS_TYPE.Value & vbcrlf, "") & IIF((LEN(Fields!DETAILS_ROLE.Value)>0), Fields!DETAILS_ROLE.Value & vbcrlf, "") & IIF((LEN(Fields!DETAILS_ORGANIZATION.Value)>0), Fields!DETAILS_ORGANIZATION.Value & vbcrlf, "") & IIF((LEN(Fields!DETAILS_PERSON.Value)>0), Fields!DETAILS_PERSON.Value & vbcrlf, "") & IIF((LEN(Fields!DETAILS_TITLE.Value)>0), Fields!DETAILS_TITLE.Value & vbcrlf, "") & IIF((LEN(Fields!DETAILS_WORKPROFILE.Value)>0), Fields!DETAILS_WORKPROFILE.Value & vbcrlf, "") & IIF((LEN(Fields!DETAILS_STATUS.Value)>0), Fields!DETAILS_STATUS.Value & vbcrlf, "") & IIF((LEN(Fields!DETAILS_STATUSDATE.Value)>0), Fields!DETAILS_STATUSDATE.Value, "") & IIF((LEN(Fields!DETAILS_QCDONE.Value)>0),Fields!DETAILS_QCDONE.Value, "")) & vbcrlf), (IIF((LEN(Fields!Add_oldB.Value)>0), Fields!Add_oldB.Value & vbcrlf, "")))