Jump to content

Multiple rows in data need to print on one page.


dwhetzel

Recommended Posts

Hi All,

I am looking for some ideas and help on how to print data from multiple rows on one page of a two page letter.

There is a unique field for each name in the data "account id". There is no set number of rows for each id. One in the full data has 30 rows. I attached a sample of the data and a two page pdf that shows how the data fields need to be laid out. The back page is what has me stumped. I need to get the "close date" and the "amount" for each row that has the same "account id" to be placed on the back page of the doc.

I tried searching the forum but not sure what to even search for.

I assume I will need to use some kind of table and an array. I am totally ignorant of both I have just dabbled some in JavaScript by reading this forum for ideas and direction.

If anyone can point me in the right direction on where to start on this it would be greatly appreciated.

TestData.zip

VariableLayout.pdf

Link to comment
Share on other sites

Hi Dave,

 

Did a couple of these types of jobs for tax season. The general idea is to have 2 files with a parent/child relationship. You already have the 'child' table with all the transactions. All you need to do is make a copy of the file you already have and de-dupe down to one record per account based on account number... this will be the 'parent' file.

 

In your template, you'll need to define the child table in your on job start rule with an external data file. Next, in your on record start, you'll need to define a FP Table and loop thru the child table, populating the table cells with the data you want with when the account numbers match.

 

Hope this helps,

 

Gregg

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...