Make Report fill in a diagram?

Sizemore5000

Registered User.
Local time
Today, 17:42
Joined
Jul 3, 2007
Messages
18
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?
 

Attachments

  • untitled.GIF
    untitled.GIF
    4.5 KB · Views: 184
Does the report always look like this, same number of boxes populated from the same fields in the data with the same connections?
 
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.
 
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.
 

Users who are viewing this thread

Back
Top Bottom