Fixed Report, Variable Input

[Threepoint]

I am looking for some help.
I need to create a monthly report that has the following layout. The action column has 15 entries for different types of actions. There are three aggregate columns for open,closed and pending.

Individual's Name
Action Open Clsd Pend
Attachments Against Property amt1 amt2 amt3
Property Executions - Regular amt1 amt2 amt3
Property Executions - Small Claims amt1 amt2 amt3
.....
.....
.....
.....
Service (Summons,Citations) amt1 amt2 amt3
Summary Proceddings amt1 amt2 amt3
Summons Miscellaneous amt1 amt2 amt3

The input is varied for the individual person. The individual will have four or five actions for a month. They will never have all 15 actions, but all actions must appear on the report.
I have no problem obtaining the data. My problem is in trying to create the report efficiently. Should I create an array for each individual and update the array for the five entries for the month ? Or is there another way to do this? The problem is that an individual may have entries for the first two actions, nothing for actions 3 thru 10, entries for 11 thru 13,nothing for 14 & 15. If anyone can offer some advice on solving this I would appreciate it.

 

[Wocca]

If I understand what you are getting at.

Pull a line as your data source equating to each action, including the individual's details sorted by Individual & then action.

On the report group by Individual with section headers & footers.

This should give you what you are after. Regards
Warwick