[Adding Header Row to Variable Table]

Hello all:

 

I was wondering if you can provide me with some assistance.

 

I have a table that contains a variable amount of rows based on the number of dependents each record contains.

 

I have found this logic from a previous thread and it works great:

 

var fields = [[Rule("Dep1_Rule"),Field("dep1dob"),Field("dep1rel")],[Field("dep2fname") + " " + Field("dep2lname"), Field("dep2dob"), Field("dep2rel")],[Field("dep3fname") + " " + Field("dep3lname"),Field("dep3dob"), Field("dep3rel")],

[Field("dep4lfname") + " " + Field("dep4lname"),Field("dep4dob"), Field("dep4rel")],[Field("dep5fname") + " " + Field("dep5lname"),Field("dep5dob"), Field("dep5rel")],[Field("dep6fname") + " " + Field("dep6lname"),Field("dep6dob"), Field("dep6rel")]];

 

var myTable = new FPTable;

myTable.AddColumns(14400, 6100, 8500);

myTable.AddRows(6);

 

for (var i=0; i<6; i++) {

if (fields[2] != "") {

myTable.Rows.Cells[0].Font="Calibri"

myTable.Rows.Cells[0].PointSize = 10;

myTable.Rows.Cells[0].SetBorders("Thin","Black","Top","Bottom","Right","Left");

myTable.Rows.CopyCells(0,1,2);

myTable.Rows.Cells[0].HAlign = "Left";

myTable.Rows.SetContents(fields[0], fields[1], fields[2]);

}

}

return myTable.MakeTags();

 

The problem I'm having is that I need to be able to add a header row (3 Columns) that contain "Name", "Birth Date", "Relationship".

 

I've tried a couple of things but nothing seems to work. I'm pretty new to making tables so any assistance you can provide would be appreciated.

[Listing using External Data File]

Below is the code I am using to list the codes. The codes are showing in one columm. I would like them to overflow to the next column if there is more than 4 codes to list for each column. Thanks for any help.

 

if(FusionPro.inValidation)

Rule("OnJobStart");

var myTable = '<table columns=4><column width=9000><column width=9000><column width=9000><column width=9000><alignment="left"';

myTable += '<margins = "top:0;bottom:0;left:0;right:0">';

myTable += '<drawbrule = "false">'

var numRecsExtDF = externalDF.recordCount;

for (recordWalker=1; recordWalker <= numRecsExtDF; recordWalker++)

{

if (externalDF.GetFieldValue(recordWalker, 'letterid') == Field("letterid"))

{

myTable += '<row><cell>' + NormalizeEntities(externalDF.GetFieldValue(recordWalker, 'coid'))

 

}

}

myTable += '</table>';

return myTable;

[Listing using External Data File]

Good Morning.

 

Working on a project that requires listing a code on a letter that utilizes an external data file. While I am able to list the code on one column, I would like to be able to list the code over multiple columns. So if I have five codes to list, it will appear like so:

 

******X ******X

******X

******X

******X

 

If I have 12 codes to list from the external data it will appear like so:

 

******X ******X ******X

******X ******X ******X

******X ******X ******X

******X ******X ******X

 

So as you can see, I will not always have the same number of codes to list for each record and since there are paragraphs immediately after I list these codes, the amount of space I have is limited.

 

Is there some kind of "counter", if you will, that I can use in Fusion Pro that will tell it to start a new column if it reaches a certain number? Any direction/instruction would be greatly appreciated!