SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Conditions check in SSRS		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sanghavi17389
Starting Member

India
26 Posts
Posted - 05/18/2012 :  08:44:24  Show Profile  Reply with Quote
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 sanghavi

edit: moved to proper forum

visakh16
Very Important crosS Applying yaK Herder

India
47036 Posts
Posted - 05/19/2012 :  15:00:41  Show Profile  Reply with Quote
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 MVP
http://visakhm.blogspot.com/
Go to Top of Page

sanghavi17389
Starting Member

India
26 Posts
Posted - 05/21/2012 :  09:48:47  Show Profile  Reply with Quote
thanx

harshal sanghavi
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000