I am working with Table field Department, Document #, and Name.
For a selected Document #, a report is generated that has a different page for each Department. All the Names of individuals within that Department that need to be trained to that Document # are displayed on the report in 2 columns (if enough names are present).
I need to make the report match the format of an existing document. The existing documnet lists the Names in columns 1 and 3 of a 4 column table. There are 15 lines to the table. (In no case will I need to fill in more than 30 Names).
Right now I can get blocks to show up to make it looks like a table, but it only fills in blocks for as many Names as I have (i.e. if I have 7 Names for that Department, it only makes 7 rows of 2 columns). I need this to always show 15 rows, 4 columns.
Any idea how I can do this?
Also I would like to place the numbers 1-30 in the blocks.
I tried to create a separate table of Number and and use that to generate the boxes, but since there is no link between Number and Name, it would not display the names.
Any help would be appreciated. After 4 days of yelling at this thing, I am very frustrated.
Thanks
Meijhana
For a selected Document #, a report is generated that has a different page for each Department. All the Names of individuals within that Department that need to be trained to that Document # are displayed on the report in 2 columns (if enough names are present).
I need to make the report match the format of an existing document. The existing documnet lists the Names in columns 1 and 3 of a 4 column table. There are 15 lines to the table. (In no case will I need to fill in more than 30 Names).
Right now I can get blocks to show up to make it looks like a table, but it only fills in blocks for as many Names as I have (i.e. if I have 7 Names for that Department, it only makes 7 rows of 2 columns). I need this to always show 15 rows, 4 columns.
Any idea how I can do this?
Also I would like to place the numbers 1-30 in the blocks.
I tried to create a separate table of Number and and use that to generate the boxes, but since there is no link between Number and Name, it would not display the names.
Any help would be appreciated. After 4 days of yelling at this thing, I am very frustrated.
Thanks
Meijhana
