InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 20:32:07 GMT20http://www.sqlservercentral.com/Forums/Topic1365054-147-1.aspxGoto Expressions :iif(fields!country.value="","",<field_name>,<field_name>)Fri, 28 Sep 2012 06:07:25 GMTD.DHAMOhttp://www.sqlservercentral.com/Forums/Topic1365054-147-1.aspx[quote][b]sanju2t (9/27/2012)[/b][hr]Hi, I have a report where countrycode is a paramater and i need to show the date format as dd/MM/yyyy on basis of countrycode. Can someone help me know how can i simplify the statetment for the condition? In Pseudo code:If countrycode in ("AU", "NZ", "IN", "MAL")then endDate.Format("dd/MM/yyyy")else endDate.Format("MM/dd/yyyy")end ifI need to write somewhat the same for my report (.rdl) file.ThanksSusheel[/quote]a case statement is your friendcase when countrycode in ("AU", "NZ", "IN", "MAL") then convert(varchar(12),[datecolumn],101)else convert(varchar(12),[datecolumn],103)end*code may take some tweakingFri, 28 Sep 2012 05:58:48 GMTcrashdanhttp://www.sqlservercentral.com/Forums/Topic1365054-147-1.aspxHi, I have a report where countrycode is a paramater and i need to show the date format as dd/MM/yyyy on basis of countrycode. Can someone help me know how can i simplify the statetment for the condition? In Pseudo code:If countrycode in ("AU", "NZ", "IN", "MAL")then endDate.Format("dd/MM/yyyy")else endDate.Format("MM/dd/yyyy")end ifI need to write somewhat the same for my report (.rdl) file.ThanksSusheelThu, 27 Sep 2012 00:46:15 GMTsanju2t