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 |
|
sanghavi17389
Starting Member
26 Posts |
 Posted - 2012-05-18 : 08:44:24
|
| I am making a report in ssrs.Now I have a requirement to add a column which will show the difference between two columns(means Subtraction).before that I must check the values of those two fields. If they are not null then only do subtraction.How can I do this?harshal sanghaviedit: moved to proper forum |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-19 : 15:00:41
|
| do IIF expression like=IIF(IsNothing(Fields!FirstField.value) Or IsNothing(Fields!SecondField.value),<your default value>,Fields!FirstField.value-Fields!SecondField.value)------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
sanghavi17389
Starting Member
26 Posts |
Posted - 2012-05-21 : 09:48:47
|
| thanxharshal sanghavi |
|
|
|
|
|
|
Conditions check in SSRS