[Formatted table from external data]

If been struggling with this for a little while and I'm not very good at tables. I'm using an external data file and have been trying to format it as a text string but can't get it to format correctly. What I would like to do is format it as a table but have not been able to do it correctly, any help would be appreciated. I've attached the template and a pdf of the format I would like to achieve.

Enrollment.zip

[Proofs from multi page FP template]

Thanks guys I will try and let you know. These proofs are not my request but sales.

[Proofs from multi page FP template]

They can do it from Mail Manager but the sequence number changes. I'd just like to limit the amount of records from the original file.

[Proofs from multi page FP template]

I've been working with a client who requires 20 samples of each of the "effort code" field values in my FP template pulling the appropriate page. I've been composing the document and searching in Acrobat for 20 each of the "effort code" values but with 50M to 80M records it gets to be a long process.

 

I have an onRecordstart rule:

 

if (Field("Effort Code") != "ERRXE")

{

FusionPro.Composition.SetBodyPageUsage("F", false)

}

if (Field("Effort Code") != "ERRPE")

{

FusionPro.Composition.SetBodyPageUsage("H", false)

}

if (Field("Effort Code") != "EIRXE")

{

FusionPro.Composition.SetBodyPageUsage("J", false)

}

if (Field("Effort Code") != "EPRXE")

{

FusionPro.Composition.SetBodyPageUsage("N", false)

}

if (Field("Effort Code") != "EPRAE")

{

FusionPro.Composition.SetBodyPageUsage("S", false)

}

 

What I'd like to do is limit each value to just 20 records of each just for proofing.