Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Posative and negative figures
- Thread starter EscapeUK
- Start date
I will assume that these 'figures' are stored in a numeric field.
First, create a Crystal formula field with the following formula:
If {field} < 0
then "B"
else "A"
Second insert a new group using this field.
Third, add a page break on the group footer of this group using the "New Page After" check mark under "Format - Section".
You can now select the field itself and use "Insert - Grand Total" or "Insert - Subtotal" to get the totals that you need.
Ken Hamady
Crystal Reports Training and a
Quick Reference Guide to VB/Crystal
First, create a Crystal formula field with the following formula:
If {field} < 0
then "B"
else "A"
Second insert a new group using this field.
Third, add a page break on the group footer of this group using the "New Page After" check mark under "Format - Section".
You can now select the field itself and use "Insert - Grand Total" or "Insert - Subtotal" to get the totals that you need.
Ken Hamady
Crystal Reports Training and a
Quick Reference Guide to VB/Crystal
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question