Grouping and Sorting: Custom display order

[n2nuk]

I need to produce a report that i can use to count the number of instances or episodes of contacts that occurred within 72 hours of the initial contact being recorded.
I have currently grouped my report on the individual record and then by date and time. The 'section will be printed' drop allows the list to be displayed by week, day, month etc. but it does seem to be possible to add to it

Any ideas greatly appreciated.

Many thanks in advance

 

[lbass]

Use a record selection formula like this:

{table.datetime} in {table.initialcontact} to datetime(dateserial({table.initialcontact}), timeserial(hour({table.initialcontact})+72,minute({{table.initialcontact}), second({table.initialcontact})))

If the initial contact is not a separate datetime field, but only the first datetime field, then replace {table.initialcontact} in the formula above with a SQL Expression {%initcontact}:

(
Select min(a.`datetime`)
From table a
Where a.`person`=`table`.`person`
)

Depending upon your database you might have to use different punctuation (quotes), and also depending upon your version of CR you might have to omit the 'a' in the first line only.

-LB