Print Page | Close Window

Summing on NULL values

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Writing Code
Forum Discription: .NET 2003 programming API, report integration
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=602
Printed Date: 16 May 2024 at 3:43pm


Topic: Summing on NULL values
Posted By: sgodbout
Subject: Summing on NULL values
Date Posted: 28 Apr 2007 at 10:37am
Hello guru's,
 
I have a crystal report that has the following information:
Group
Actual Expenditures (from one table)
Budgeted Expenditures (from another table).
Available Amount (Budgeted - Actual)
End Group - Total for the above three.
 
The problem I have is that there may be actual expenditures for something that there is no budget for and there may be no expenditures for a budgetted item. 
 
In order to get the information I needed, I had to set up a Left-Outerjoin between the Budget Table and the actual transactions.
 
The problem is in the case there are no actual transactions, I don't get anything back (as expected) and I would like to change or set it to 0.  It is also effecting the Avaliable amount (nothing - budget is giving me nothing.
 
I have just started back on Crystal after many years away and I know that I am missing something simple
 
Thanks in advance for all your help.
 
SCG


-------------
Stephane Godbout


Replies:
Posted By: BrianBischof
Date Posted: 30 Apr 2007 at 11:52am
You can set a report option to return 0 for null values.

-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>


Print Page | Close Window