Solved

# Accumulating Group Footer count

Posted on 2013-06-18
Medium Priority
421 Views
I have a 2 Groups, Group1 is all cardnumbers then Group 2 is dates with all transactions in the data field - I run a formula in GF to check if the count of data transaction is 2 (Always a entry and a exit and the last transaction is a exit) - if there is only one transaction count and it is a entry show a '1'

I'm trying to calculate all the 1's (all users that is 'IN' ) - I tried  running total but it seems to calculate each transaction rather than just the ones.

0
Question by:John-S Pretorius
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 2
• 2

LVL 101

Expert Comment

ID: 39258286
Do you mean for when the group total is 1?

Try this
WhilePrintingrecords;
Global NumberVar CountStillIn;
""

In the group footer for the dates (assume that is where you are showing the 1
WhilePrintingrecords;
Global NumberVar CountStillIn;
If ({YourField} = 2) then
CountStillIn := CountStillIn + 1;
""

At the end of the report
WhilePrintingrecords;
Global NumberVar CountStillIn;
CountStillIn

mlmcc
0

Author Comment

ID: 39258300
Actually I want to count if the last transaction  is still in, sometimes users have multiple in / out transactions - I was thinking a if statement which gives a 1 in the footer if the last transaction is in , then count just all the 1's in the footers.
0

LVL 101

Accepted Solution

mlmcc earned 1600 total points
ID: 39258311
In the group footer for the dates (assume that is where you are showing the 1
WhilePrintingrecords;
Global NumberVar CountStillIn;
If ({YourField} = 1) then
CountStillIn := CountStillIn + 1;
""

mlmcc
0

Author Closing Comment

ID: 39259105
This worked great, thank you.
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
###### Suggested Courses
Course of the Month10 days, 14 hours left to enroll