Records and calculations !!

[Monkeyboy126]

Hi

CR8.5

Background:

Helpdesk call logging software. Complex SQL database. Report displays a call ref number and all activities for that call (DateTime logged, DateTime of a logged comment, DateTime of escalation etc). All activities are produced from the same table (different fields).

Problem:

I am looking to at two DateTime's in particular, the DateTime Logged and the DateTime of the next entry (whatever it might be), and I then need to calculate the elapsed time between the two. This bit I can work out but the report obviously displays all records (events)from the table and I only need the first two.

Also I then need to work out how I perform the date difference calculation on two records from the same table.

I hope this explains my problem... Help!!

Many thanks

 

[synapsevampire]

Group by the event and in the group header use a formula like:

datediff("m",{table.datetime},next({table.datetime}))

This will provide a comparison between the first and second row of each event only.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com