Crystal Reports

[chomzky]

Hello,
I have a command object created to extract the following fields:

AreaAudited: (ex Slots, Table Games)
Section: (ex BlackJack, Live Payments)
GameAuditStartDateTime: (date time field)
ReviewMethod: (Pass, Fail, Live)
Number: (Audit number ex GA20120002122)
Violation: (incorrect payment)

I want to create a monthly summary report which will count the number of audits (based on start date time) using the follwing formula:

if {Command.GameAuditStartDateTime} >= #1/1/2012 12:00:00# and {Command.GameAuditStartDateTime} <= #1/31/2012 11:59:59# then 1 else 0

So far I have a summary field to count the number of audits that occured based on the GameAuditStartDateTime field. The problem I am having is there can be multiple violations in each audit so my summary field (GameAuditStartDateTime) is not accurate. If there are 3 violations my summary is off by +2. Is there any other way to accomplish this ?

 

[IanWaterman]

Use your same formula but evaluate it with a running total.

In the evaluation section of the RT check chnge of field or group so that each violation is not counted just the summary type

Ian

 

[lbass]

Please do not create multiple threads on the same topic.

-LB

 

[chomzky]

sorry...I thought I hit preview post the first time ...

 

[gennaro7]

Hi, help on this subject is appreciated. I am creating a crystal report and I want to extract records, in the calldesc field, that have these keywords; voyager, mobility, cash edge. My table is Calllog and the field is calldesc. I am a beginner in SQL programming. What is the code to do this extraction. thanks for the help.

g.