Pulling infomation from PeopleSoft - Case Updates

[MiagiSan]

I am not even sure if Crystal can do this but here goes.

I am using CR X and I am pulling information out of PeopleSoft. I want to know when a ticket is Modified; the problem is that each time you choose the "Save" option during the creation of the case, the Database is updated here: {table.EVENTNAME} = "Case Changed"

I have a unique case number here: {table.CASE_ID}
And I have times for each update here: {table.ROW_ADDED_DTTM}

If someone updates a case and hits "Save" 4 times, I do not want that to be counted as 4 updates but as only 1.

Can I write a formula that will show me the following:

If a unique case number has multiple instances of {table.EVENTNAME} = "Case Changed" within a 5 minute time period {table.ROW_ADDED_DTTM} Then "1"

I hope this makes sense; thank you very much for your help.

 

[synapsevampire]

Kinda tricky, but doable.

Details formula:

whileprintingrecords;
numbervar Countem;
if onfirstrecord
and{table.EVENTNAME} = "Case Changed"
then
countem:=countem+1
else
if {table.EVENTNAME} = "Case Changed"
and
datediff("n",previous({table.ROW_ADDED_DTTM}),{table.ROW_ADDED_DTTM}) >= 5 then
countem:=countem+1;

Then in a subsequent section, group footer or report footer, use:

whileprintingrecords;
numbervar Countem

You gave no indication of your report layout, so I had to guess at what you werte intending to display and where, but the theory here is sound.

-k

 

[MiagiSan]

Thank you Thank you Thank you!