Make Report fill in a diagram?

[Sizemore5000]

I have a DB of people that must call each other in series, dominoing out until all people have been notified.

We currently have a diagram of this procedure on a Powerpoint slide, but I would rather use the DB to generate this doc.

The report's fill in columns 'down the across' or the like doesn't cut it: I need it to fill in records so the doc looks like this (in attachment).

Any ideas?

 

[Sizemore5000]

No ideas at all? Is this kind of thing even possible?

 

[neileg]

Does the report always look like this, same number of boxes populated from the same fields in the data with the same connections?

 

[Sizemore5000]

Yes, the only things that will change are the records that fill each block, as new people arrive and others get promoted. I can set a field to keep track of that, though.

I considered the possibility of having a ton of subreports to fill in the blocks, but that seems like the wrong way to do it for some reason.

 

[neileg]

Then all you need to do is place text boxes on the report that are bound to the field in the query that feeds the report. I would build the report from scratch, but if you want to use the wizard choose the Columnar format and then delete the labels from the controls and move them around.