Howdy andy - Well there are two ways to approach this. The normal way I would get into the database and redo it the way I want - that is generally an easier way to do things - instead of writing rules that eventually will get you the data you need - it is often faster to just have the data you need and omit the rules.
The second way - It looks as if you have two variables that you are working with - a name and a starting number. For the name you would just create 12 different txt fields and insert the same variable into each of the txt fields. So if the data was bill - it would just be showing that variable bill 12up. The second would be a starting number that i would guess that you would be getting from the database. You would just insert the original number in the first one and then have 11 different rules for the remainder - and you would insert a different rule in each txt field. The rule would just be to return the starting number +1 then the second would be return the starting number +2 etc. ] Hope that helps. ~Mark -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, May 04, 2007 7:51 AM To: FusionPro Users Forum Subject: [fusionpro] Static Variable? This job is a ticket that runs 12 up and is variable in three spots. The database has about 20,000 names. On each sheet the name will stay the same in all 12 locations , however there will be a number that is variable that will change in sequential order. (i.e. Bill=1-12_one sheet, Kathy=13-24_second sheet) This would be easy if the DB supplied had "Bill" 12 times. However, the DB has only one name per cell. I am trying to avoid messing with the original DB if possible. I keep running into dead ends and any help would be greatly appreciated. Andy Snyder Foresight Group | Lansing, MI -- Users of FusionPro Desktop have unlimited free email support. Contact Printable Support at [EMAIL PROTECTED] -- View FusionPro Knowledge Base, FusionPro Samples at www.printable.com/vdp/desktop.htm -- You are currently subscribed to fusionpro as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] -- -- Note: All e-mail sent to or from this address will be received or otherwise recorded by the e-mail recipients of this forum. It is subject to archival, monitoring or review by, and/or disclosure to someone other than the recipient. Our privacy policy is posted on www.printplanet.com -- -- Users of FusionPro Desktop have unlimited free email support. Contact Printable Support at [EMAIL PROTECTED] -- View FusionPro Knowledge Base, FusionPro Samples at www.printable.com/vdp/desktop.htm -- You are currently subscribed to fusionpro as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] -- -- Note: All e-mail sent to or from this address will be received or otherwise recorded by the e-mail recipients of this forum. It is subject to archival, monitoring or review by, and/or disclosure to someone other than the recipient. Our privacy policy is posted on www.printplanet.com --
