Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
atlachar123456
Starting Member
33 Posts |
 Posted - 2011-11-03 : 10:09:10
|
| Hi, I have a requirement to add trade_Linked column in the report,for this column i need to write an expression Display if legal is Trade-Linked (Y/N).how to write the expression in that particular column for example:=iif(thiscoulmn.this =y or n) like this we have to write,can anyone correct the expression? it seems to be in the report : trade_Linked or trade_Linked Y N atlaaaaaaaa |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-03 : 11:00:23
|
| =iif(fields!trade_Linked.value =y or fields!trade_Linked.value =n,<some logic>,<some other logic>)------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
atlachar123456
Starting Member
33 Posts |
Posted - 2011-11-03 : 13:21:54
|
| can i use this either of teh expression =iif(Trd_linked()=0,N,Y) or =iif(fields!Trd_Linked.value =0,"N","Y")atlaaaaaaaa |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-03 : 13:24:07
|
| it should be latter------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
atlachar123456
Starting Member
33 Posts |
Posted - 2011-11-03 : 13:28:41
|
| I did't get you? can i use it or not in this wayatlaaaaaaaa |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-03 : 13:55:39
|
| use it like=iif(fields!Trd_Linked.value =0,"N","Y")------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Issue with the expression in the report