Joined: 18 Mar 2010
Online Status: Offline
Posts: 23
Topic: Conditional Summary Posted: 08 Sep 2011 at 10:45am
We are working on a report where we have a group for "Out of Budget FTE's" If a cost center has an out of budget FTE then this row will show up with the applicable data.
Our problem is that it also shows up if the department does not have an out budet FTE. It shows up with zeroes but we would like to somehow tell the report to not show this group or row if there are no out of budget fte's.
Joined: 26 Oct 2007
Location: United States
Online Status: Offline
Posts: 99
Posted: 09 Sep 2011 at 7:37am
Use the suppress attribute of the section. Don't use a running total for this. Instead use IF <your condition> Then 1 Else 0. Then, sum that formula to get your total count for the group.
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
www.MilletSoftware.com
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum