if statement
Try this... =Iif(Fields!fielda.Value = "xx", Fields!fieldb.Value, Fields!fielda.Value) Jason Long
March 12th, 2011 4:57am

Hi Helix Please see the code below. =Iif(Fields!fileda.Value = "xx", "b", Fields!fileda.Value) hopefully this will solve your problem. See Olaf link as well for better understanding.Dasari
Free Windows Admin Tool Kit Click here and download it now
March 12th, 2011 5:52am

Great. Thanks Jeevanwww.helixpoint.com
March 12th, 2011 6:06am

How do I do if field a = "xx" use field b If field a does NOT = "xx" then use that field www.helixpoint.com
Free Windows Admin Tool Kit Click here and download it now
March 12th, 2011 6:31am

Hello, For this you can use the IIF function, see Expression Examples => Decision Functions. Olaf Helper * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich tglich Blog Xing
March 12th, 2011 6:58am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics