Print Page | Close Window

Problems seeing all records in group footer

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=9395
Printed Date: 05 May 2024 at 3:49am


Topic: Problems seeing all records in group footer
Posted By: flanman
Subject: Problems seeing all records in group footer
Date 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.

Flanman


Replies:
Posted By: DBlank
Date Posted: 16 Mar 2010 at 10:24am
Can't 'see' what you are trying to do here...can you post some samples with an explanation?

Posted By: flanman
Date 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. 

Posted By: flanman
Date 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.

Posted By: DBlank
Date Posted: 16 Mar 2010 at 11:17am
How exactly are you calculating the 'still available'?

Posted By: DBlank
Date 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).
Is this on the right track for you?

Posted By: flanman
Date Posted: 17 Mar 2010 at 4:59am
You are correct in your assumption. Now is an insert Summary value different than a normal summary. Not sure what you mean there.

Posted By: flanman
Date Posted: 17 Mar 2010 at 5:20am
Nevermind my previous comment. Dumb.. duh.. I am continuing to search for a solution.

Posted By: DBlank
Date Posted: 17 Mar 2010 at 7:00am
How are you calculating the 'still avialable' amount?

Posted By: flanman
Date 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.

Posted By: DBlank
Date Posted: 17 Mar 2010 at 11:36am
try to change your report settings to 'select distinct records' to eliminate the dupes.
If that works ...
If your calc is using 2 different fields create a formula to combine them.
You can use the insert summary (sigma sign) on the new formual field as a SUM at your group1 level.
Create another formula for your day as you did but make that a MAX at your group 1 level
Then try and suppress using these 2 summaries togther, something like:
MAX(weekdayformula,group1)-SUM(other formula,group1)


Print Page | Close Window