Formula Question 1

[JasGrand]

Hello, I am converting an MS Access report to a Crystal report. I have the following formula in Access:

=(Sum([REGISTRATION_COST])+Sum([Books_Cost])+Sum([travel_cost])+Sum([accomodation_cost])+Sum([exam_cost])+Sum([other_costs])+Sum([salben_costs]))

I created the following formula (called @Total) in Crystal Reports:

Sum ({ReportCompletedTraining.RegistrationCost}, {ReportCompletedTraining.CostCenter}) +
Sum ({ReportCompletedTraining.BooksCost}, {ReportCompletedTraining.CostCenter}) + Sum ({ReportCompletedTraining.TravelCost}, {ReportCompletedTraining.CostCenter}) + Sum ({ReportCompletedTraining.AccomodationCost}, {ReportCompletedTraining.CostCenter}) + Sum ({ReportCompletedTraining.ExamCost}, {ReportCompletedTraining.CostCenter}) + Sum ({ReportCompletedTraining.OtherCosts}, {ReportCompletedTraining.CostCenter}) + Sum ({ReportCompletedTraining.SalbenCosts}, {ReportCompletedTraining.CostCenter})

I did this in Crystal reports but some numbers aren't showing up. Where ever there is a missing total number there is also missing Book_Cost's that are not in the database. I was wondering if this could be an issue? If i'm doing it wrong then I was wondering how I can get all the numbers to show in the total in Crystal Reports.

Thanks again,


Jason Grandmaison

 

[synapsevampire]

This may be a NULL issue, try selecting File->Report Options->Convert Null Value to Default.

It may also be the joins used, post the SQL.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[JasGrand]

Woohoo!!! It was a null issue.


Thanks a lot.

Do I reward points or anything on this forum?