[Roesing]

I am writing a report in Crystal that will show the last three actions and the next three actions. I imported all dates from RE. I was changing the dates in RE Export but if other staff run the report they do not know how to do that. So I would like to have Crystal do it automaticly, but I don't know how to write a formula that says. Take todays date and show me the last three actions or next three actions. I do have a subreport for past and one for future.

Thank you for any help.

[DrewAllen]

It is possible to do this, but not particularly easy. It's easier if you separate last actions and future actions into different sub-reports, but not necessary. Here's what you would need with everything in the main report or in the same sub-report.

• A group on the constituent
• A boolean formula to separate past and future actions
• A group on this boolean formula
• Sort on the action date. (Either ascending or descending will work.)
• A running total that increments the COUNT on change of action and resets on change of the boolean group.

You'll need to go into the section properties and select the formula for suppression. Your formula will depend on whether you're sorting your actions in ascending or descending order and whether it is a past or future action.

The following formula uses the running total to show the first three actions in the group.

{#Running Total} > 3

The following formula uses the running total and a total count of actions in the group to show the last three actions in the group.

Count({ActionTable.ActionID},{@Boolean Group}) - {#Running Total} > 3

If you are including multiple action notes or something else that causes the actions to "duplicate" you will need to use a distinct count in your suppression formula.

Drew