Joined: 04 Nov 2009
Online Status: Offline
Posts: 123
Topic: Problems seeing all records in group footer Posted: 16 Mar 2010 at 9:11am
I have a report that does groping first by event ID and then by date. So GF2 = Event ID GF1 = Date
I have running totals for a staff number that totals first by EventID And a second running total by Date. I then need to compare the total in the date group to another set field number in the GF1 (Date Footer). What I am trying to do is only see any records where the Staff number is greater than the set number for a particular date. I want to see the info in both footers if that condition is met. So I have both footer sections set to suppress priniting if the condition is not met. The problem I am having is on the GF2 section I am only seeing some records and not all. Basically I am seeing the records until the condition to suppress is meet then the other info is not seen on the report. What I am finally trying to accomplish is if the condition in GF1 is met show me that section and all info in GF1 as well. Hopefully that all makes sense.
Joined: 04 Nov 2009
Online Status: Offline
Posts: 123
Posted: 16 Mar 2010 at 10:56am
I will post a screen shot when I can. Ironically my personal web site is having problems today, and it does not look like we can post images via the forum.
Joined: 04 Nov 2009
Online Status: Offline
Posts: 123
Posted: 16 Mar 2010 at 11:07am
Ok. I finally got the screen shot uploaded. It is located at: http://picasaweb.google.com/flanman68/Family#5449339586440102754
If you look at each section with dates the numbers should total what is in the "Daily Total" Section. The individual date line are the GF2 and the Daily Totals section is GF1 Totals. I have a static value built for each day of the week. For example on Sat. Oct 16 you see the daily total of 11 and the "Still available" in red at -4. the way I have the suppress condition set is if the Still Available is a <0 number then show me the records in GF2 and GF1, but some record are dropped from GF2 as you can see. I need to figure out how to see all records in GF2 if the condition based on GF is met.
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 16 Mar 2010 at 11:48am
My guess is you have a RT or a variable formula that is calculating this.
The final total for these types does not 'exist' until it gets to the last record. Therefore as it read through the rows (and group footer2) it will suppress all the GF2s that cumulatively are >0 at that point in the report, and then when it hits the tipping point of being <0 it starts to show these GFs.
If you can convert that from a RT to using an insert Summary value then you can fix it that way. Those are calculated earlier in the report generation process (an earlier pass).
Joined: 04 Nov 2009
Online Status: Offline
Posts: 123
Posted: 17 Mar 2010 at 7:25am
I am pulling staffing numbers from 2 different tables (CL Staffed and Shift Staffed columns). These are running totals as the details section is showing some data duplication due to 2 different tables. Once I have these totaled I have a built in daily total for each day of the week in a formula for the still Available field. So my formula is something like: If table.date(weekday) is Monday Then Still Available = 15 - CLStaffed Daily Total Else If Table.date(weekday) is Tuesday Then Still Available = 12 - CLStaffed Daily Total Else ......
My final goal is when the above formula is run I want to see all the records in GF2 as well at the totals in GF1 When the StillAvailable is > 0 which is negative number.
I want to suppress any days where the Still Available total is not negative.
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