Go Back   MarcomCentral (PTI) and FusionPro User Communities > Software-Related Talk > FusionPro® VDP Creator

Notices

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old February 19th, 2016, 10:57 AM
dwhetzel dwhetzel is offline
Forum n00b
 
Join Date: Dec 2008
Location: Maryland
Posts: 8
Smile Multiple rows in data need to print on one page.

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.
Attached Files
File Type: zip TestData.zip (50.3 KB, 12 views)
File Type: pdf VariableLayout.pdf (544.0 KB, 23 views)
__________________
Dave Whetzel
Digilink Inc.
FP 9.3.6 Acrobat 11.0.14 Mac 10.10.5
dwhetzel@digilink-inc.com
Reply With Quote
  #2  
Old February 19th, 2016, 12:57 PM
GreggRusson GreggRusson is offline
Junior Community Member
 
Join Date: May 2011
Location: Seattle
Posts: 35
Default Re: Multiple rows in data need to print on one page.

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
Reply With Quote
  #3  
Old February 22nd, 2016, 05:05 AM
dwhetzel dwhetzel is offline
Forum n00b
 
Join Date: Dec 2008
Location: Maryland
Posts: 8
Default Re: Multiple rows in data need to print on one page.

Hi Gregg,
Thanks for your quick input. The explanation was spot on and I was able to find what I needed in this great community.
It's really simple once I grasped the concept.
__________________
Dave Whetzel
Digilink Inc.
FP 9.3.6 Acrobat 11.0.14 Mac 10.10.5
dwhetzel@digilink-inc.com
Reply With Quote
Reply

Tags
array, javascript, table

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -7. The time now is 01:37 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) 2011, PTI Marketing Technologies™, Inc.