Print Page | Close Window

Need some help

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=3047
Printed Date: 07 May 2024 at 10:41pm


Topic: Need some help
Posted By: rbnielson
Subject: Need some help
Date Posted: 28 Apr 2008 at 9:04am
Here is the issue I am printing out a statement,  for the purpose of the statement I am printing only on a change of invoice number.  I am also changing the total so that if there is no insurance payment the invoice total is 0 as far as the patient responsibility.  the formula is
IIF ({#Invoice Ins Payments}<>0,{#Invoice Charges} - ({#Invoice Ins Payments}+{#Invoice Patient Payments}+{#Invoice Practice Adj}) ,0 ) this formula works fine in the group footer for change of invoice.  I also want to total the patient responsibility fields that are created above but have been unable to do  so.  Any Ideas?
 
Thanks


Replies:
Posted By: BrianBischof
Date Posted: 28 Apr 2008 at 3:29pm
You can create a manual running total. Use a Global variable to summarize the data in a formula and then to print it out create another formula which simply returns the value of that global variable. It's also important that in each formula you re-declare the global variable so that you don't get an error about an unknown variable.

I have three chapters that teach everything you need to know about writing formulas and the programming syntax. You can find out more about my books at http://www.amazon.com/exec/obidos/ASIN/0974953601/bischofsystem-20 - Amazon.com or reading the http://members.crystalreportsbook.com - Crystal Reports eBooks online.

-------------
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