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!
Sum function
- Thread starter EscapeUK
- Start date
You can't do this directly, but you can indirectly, depending on how the records are suppressed.
If you have entered a suppress conditon for the details band you can create a formula that uses the same condition as the suppression:
If -your suppress condition-
then {value to sum}
else 0
Then sum this formula.
This begs the question of why the suppressed records are in the report. If you don't want to see them or total them you might simply be able to use the record selection formula to eliminate them.
If, however you have a TopN or Group Selection formula that causes records not to print, then you must use running totals to sum only the printing records.
Ken Hamady
Crystal Reports Training and a
Quick Reference Guide to VB/Crystal
If you have entered a suppress conditon for the details band you can create a formula that uses the same condition as the suppression:
If -your suppress condition-
then {value to sum}
else 0
Then sum this formula.
This begs the question of why the suppressed records are in the report. If you don't want to see them or total them you might simply be able to use the record selection formula to eliminate them.
If, however you have a TopN or Group Selection formula that causes records not to print, then you must use running totals to sum only the printing records.
Ken Hamady
Crystal Reports Training and a
Quick Reference Guide to VB/Crystal
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question