Totals not adding up in Crystal Reports

Okay, when I do a left outer join in crystal to display orderrel and shipdtl, the correct number of orders display, the if nothing exist in shipdtl, like packslip, it is left blank.  

Good morning, 


My report is looking good, but when adding this formula {OrderRel.OurReqQty}*{OrderDtl.UnitPrice} that displays the total value for a release, the sum is incorrect.  How could this be? 


Thanks.

 

Are you summarizing and resetting at the correct group levels?  Pretty easy to miss, especially if a grouping change got made.

-Todd C.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, January 28, 2015 11:25 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Totals not adding up in Crystal Reports

 

 

Good morning, 

 

My report is looking good, but when adding this formula {OrderRel.OurReqQty}*{OrderDtl.UnitPrice} that displays the total value for a release, the sum is incorrect.  How could this be? 

 

Thanks.

 

Your also miss the OrderDtl.PricePer factor in your formula.

 

Patrick Winter

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, January 28, 2015 11:25
To: vantage@yahoogroups.com
Subject: [Vantage] Totals not adding up in Crystal Reports

 

 

Good morning, 

 

My report is looking good, but when adding this formula {OrderRel.OurReqQty}*{OrderDtl.UnitPrice} that displays the total value for a release, the sum is incorrect.  How could this be? 

 

Thanks.

 

Thanks Todd.  I'm summarizing all the values for my orders.  This is a grand total not at the group level.