I can't build the entire rule for you, but I can try to get you started.
Basically, you're going to be using the ExternalDataFileEx object to
iterate through the records, similar to how the "Repeat a record"
example works, except you're not going to be re-writing your input file;
you're just going to be looking at the value of the field in each record
and comparing it to what you already have. Something like this:
var max_sales = 0;
var max_sales_company = "";
var inputFileName = FusionPro.Composition.inputFileName;
var dataFile = new ExternalDataFileEx(inputFileName, "\t");
for (var rec = 0; rec < dataFile.recordCount; rec++)
{
var sales = Int(dataFile.GetFieldValue(rec, "sales"));
if (sales > max_sales)
{
max_sales = sales;
max_sales_company = dataFile.GetFieldValue(rec, "company_name");
}
}
return max_sales_company;
Like I said, this is just to get you started. It's off the top of my
head, without any real data to test against. So you may have to tweak
it a bit.
Dan
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
FusionPro 5.0 Now Available!
Variable text on a curve and soft drop-shadows for variable text
LIMITED TIME upgrade offer of $299 per license for current customers:
http://fusionpro.printable.com/store/upgrade
New licenses available for $599 each at:
http://fusionpro.printable.com/store/
All FusionPro 5.0 customers to receive FusionPro 5.1 with
Adobe Acrobat 8 and InDesign CS3 support when released for FREE.
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
--
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
--
